Line delimited export ?

vampcatt · Apr 18th, 2002, 04:14 PM

I need to have some data saved as Line Delimited.
I have comma's within the text of my fields, so I cant just comma delimit it and then find replace comma for | SO..
IS there a nice quick and easy way to do this?

thanks!

davers5 · Apr 18th, 2002, 06:06 PM

Besides using the text to column method (under the data menu, choose text to columns and follow the instructions) I don't think there are any easy ways. I've written some macros to do such things recently. Let me know if you're interested.

Dave

Yogi Anand · Apr 18th, 2002, 09:12 PM

Quote:

On 2002-04-18 15:14, vampcatt wrote:

I need to have some data saved as Line Delimited.
I have comma's within the text of my fields, so I cant just comma delimit it and then find replace comma for | SO..
IS there a nice quick and easy way to do this?

thanks!

Hi vampcatt:
You can use the split vertical bar "|" as the delimiter ... when you go to DATA|TEXT_TO_COLUMNS|DELIMITED|Next then for Delimiters click in the box OTHER and then key-in the associated box | ... tht's it!

HTH

Please post back if it works for you ... otherwise explain a little further and let us take it from there!

Tommy Bak · Apr 19th, 2002, 02:55 AM

Hi
there is a way to do this but i don't know how practical it is.
under Controlpanel / regional settings / numbers change your listseperator from , to |
This wiill change your delimiters, but will also have an effect on the listseprator you use in excelfunctions.

regards Tommy

vampcatt · Apr 19th, 2002, 06:55 PM

OK.. Maybe my post wasnt worded quite right, or I am not understanding the answers

Text to columns works "backwards" from what I am trying to do..
I have a spreadsheet.. columns a - o
even if there is no value within a cell, I need to have everything | delimited.
SO.. if I had
1 2 3 4 6 7 9 I would need
1|2|3|4||6|7||9
so.. I have to export it to a |delimited text file.

Did that make better sense?

And Tommy.. I will look into that method, even if I can change that export, and change it back, thats fine.. since I am exporting text, it doesnt matter about my formulas for that exact document.

So.. that might work?

[ This Message was edited by: vampcatt on 2002-04-19 17:57 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 04:14 PM	#1
vampcatt New Member Join Date: Feb 2002 Location: State? Insanity! :) Posts: 26	I need to have some data saved as Line Delimited. I have comma's within the text of my fields, so I cant just comma delimit it and then find replace comma for \| SO.. IS there a nice quick and easy way to do this? thanks!

Apr 18th, 2002, 06:06 PM	#2
davers5 Board Regular Join Date: Feb 2002 Posts: 255	Besides using the text to column method (under the data menu, choose text to columns and follow the instructions) I don't think there are any easy ways. I've written some macros to do such things recently. Let me know if you're interested. Dave

Apr 19th, 2002, 02:55 AM	#4
Tommy Bak Board Regular Join Date: Feb 2002 Location: Guderup, Denmark Posts: 287	Hi there is a way to do this but i don't know how practical it is. under Controlpanel / regional settings / numbers change your listseperator from , to \| This wiill change your delimiters, but will also have an effect on the listseprator you use in excelfunctions. regards Tommy

Apr 19th, 2002, 06:55 PM	#5
vampcatt New Member Join Date: Feb 2002 Location: State? Insanity! :) Posts: 26	OK.. Maybe my post wasnt worded quite right, or I am not understanding the answers Text to columns works "backwards" from what I am trying to do.. I have a spreadsheet.. columns a - o even if there is no value within a cell, I need to have everything \| delimited. SO.. if I had 1 2 3 4 6 7 9 I would need 1\|2\|3\|4\|\|6\|7\|\|9 so.. I have to export it to a \|delimited text file. Did that make better sense? And Tommy.. I will look into that method, even if I can change that export, and change it back, thats fine.. since I am exporting text, it doesnt matter about my formulas for that exact document. So.. that might work? [ This Message was edited by: vampcatt on 2002-04-19 17:57 ]