Urgent! How to save an excel file in pipe delimited form
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

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

  1. #1
    Join Date
    Oct 2000
    Posts
    76
    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.

  2. #2
    Join Date
    Mar 2001
    Posts
    45
    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

  3. #3
    Join Date
    Oct 2000
    Posts
    76
    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.

  4. #4
    Join Date
    Mar 2001
    Posts
    45
    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

  5. #5
    Join Date
    Feb 2001
    Posts
    203
    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
  •  


Click Here to Expand Forum to Full Width