Urgent! How to save an excel file in pipe delimited form

[jt]

Hi, I have an excel file that need to be converted to a pipe (|) delimited plain text file. Excel offers saving in tab,space and comma delimted form, but not any other characters. PLEASE help to let me know how to do this!

Thanks

[contactrb]

Though the method i am suggesting is not a direct one (in fact a bad one), no problem,
based o your urgency, to do the job follow this.

Export it to flat file with the available delimiter , tab space.

Using any one of the text file editor, globally replace that delimiter by | symbol.

Hope it may meet your urgency.

[jt]

Thanks for the suggestion. I tried this method. The problem with comma or space is you might have comma or space as part of a field data, so you might add extra pipe there, using tab as delimiter, the search and replace function in Notepad does not let you to search by tab. So that doesn't work neither. Can you somehow trick the search to take tab as input? Thanks.

[contactrb]

I too thought the same while giving the solution.
Is there Unix available in your site.
If so well and good, transfer the file to UNIX, using vi editor,
open the file and supply this command:

1,$ s/ /\|/g

after s/ it is not blank space, just press tab key alone.
/\ is not shift 6, it is / and \

Proceed...

[sree_sri]

I know that, This is not perfect but try this.
add new columns between the data columns and put
'|' in the new columns. Then export into flat file with or with with out delimiter.

EX:

EMP_NAME EMP_NO,LOC


After adding new column in excel

emp_name|emp_no|loc.