Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Flat File with @ as delimiter
I need to make a flat file to send data to another organisation.
I am aware of saving Excel sheets as txt files however my problem is that the other organisation require the @ symbol to be the delimiter and ASCII 13 carriage return to show the End of Line Marker. Can anyone give me guidance on how to set the delimiter to be the @ symbol instead of a comma or space? Using Excel to do this would be ideal as I can make one sheet user friendly for our users and a hidden sheet linked to user friendly page to be used to be converted to the flat file (we currently use this method to transfer data to our bespoke databases). Any advice or guidance appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tab Delimiter File | Excel Discussion (Misc queries) | |||
Converting pivot to flat file | Excel Discussion (Misc queries) | |||
Define Excel delimiter by file extension | Excel Discussion (Misc queries) | |||
copy excell file to a CSV file and than to Notepad | Excel Discussion (Misc queries) | |||
export excel file as csv with text delimiter of " | Excel Discussion (Misc queries) |