Line delimited export ?

vampcatt

New Member
Joined
Feb 22, 2002
Messages
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!
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
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
 
Upvote 0
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!
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,511
Messages
6,114,054
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top