hello all,
I am simply trying to save a sheet as a text file with the column contents saved as a simple long string of data, regardless of content.
Ex. If my columns were this: (underscores represents columns, the pipes and ampersands are actual cell content).
a213_____|_____text1_____&_____14.44000_____|_____endtext
I would want the text file to read:
a213|text1&14.44000|endtext
None of the "Save As" choices allow this. All end up with at least tab's separating the original cell contents. Also tried changing the delimiter in the control panel, but NULL is not an allowed choice. And opening the csv in any text editor still has tabs as separators anyway.
Thanks
Scott
Bookmarks