-
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
J.T.
-
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.
Thanx
Ramesh.
______________________________
There is nothing Impossible.
Even Impossible says
I M POSSIBLE
-
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.
J.T.
-
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...
Thanx
Ramesh.
______________________________
There is nothing Impossible.
Even Impossible says
I M POSSIBLE
-
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.
sree
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|