Urgent!!! Is this possible

  • Thread starter Thread starter elovelace256
  • Start date Start date
E

elovelace256

I have a spreadsheet with row 1 as my header allof the other rows i need

exported to a file in the format below. This is critical and any help
is
greatly appreciated

This is my spreadsheet layout. But there could be up to 8000 rows:
c_last_name c_first_name c_middle_name c_userid
Ables Donna F
donna.ables
Lovelace Eric
eric.lovelace

I need to export this to a file in this format. Each row needs to be
enclosed in ( ) and each field in that row needs to be in " " with a
comma
seperating each field.
( "ables" ,"donna" , "f" ,"donna.ables" )
( "lovelace" ,"eric" , "" ,"eric.lovelace" )


Thanks a million
 
I would create the data in one column, using a formula like:

="( """&lower(a2)&""" ,"""&lower(b2)&""" , """&lower(c2)&"""
,"""&lower(d2)&""" )"

You could do this on a separate sheet, or on the original sheet and hide all
the other columns. Then save the file (presumably as type TXT).
 
Assuming your data appears in columns A, B, C, and D, then you can
create a formula that looks like this:
="(" & char(34) & A2 & char(34)& "," & char(34) & B2 & char(34)& ","
& char(34) & C2 & char(34)& "," & char(34) & D2 & char(34)& ")"

Char(34) creates a quote mark in the output. You can then save the
appropriate section of data as a text file, or copy it into the
clipboard and paste it into MS Notepad, for instance.

Let us know if you need anything more!

Dave O
 
Back
Top