Select delimiter in .txt creation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to send an Excel file to a system that expects text with ASCII 124 ['|'] as the delimite. Can the delimiter be changed from the tav in excel. I passing thru Access, where one has control of the delimiter, but Access made to many changes to the formatting of my data.
 
Chip Pearson has written code that allows you to write a text file (csv
style) and specify the delimiter.

http://www.cpearson.com/excel/imptext.htm

--
Regards,
Tom Ogilvy


Chartsmalm said:
I need to send an Excel file to a system that expects text with ASCII 124
Click to expand...
['|'] as the delimite. Can the delimiter be changed from the tav in excel.
I passing thru Access, where one has control of the delimiter, but Access
made to many changes to the formatting of my data.
 
Back
Top