Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Line delimited export ?

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    State? Insanity! :)
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default



    I need to have some data saved as Line Delimited.
    I have comma's within the text of my fields, so I cant just comma delimit it and then find replace comma for | SO..
    IS there a nice quick and easy way to do this?

    thanks!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Besides using the text to column method (under the data menu, choose text to columns and follow the instructions) I don't think there are any easy ways. I've written some macros to do such things recently. Let me know if you're interested.

    Dave

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-18 15:14, vampcatt wrote:


    I need to have some data saved as Line Delimited.
    I have comma's within the text of my fields, so I cant just comma delimit it and then find replace comma for | SO..
    IS there a nice quick and easy way to do this?

    thanks!
    Hi vampcatt:
    You can use the split vertical bar "|" as the delimiter ... when you go to DATA|TEXT_TO_COLUMNS|DELIMITED|Next then for Delimiters click in the box OTHER and then key-in the associated box | ... tht's it!

    HTH

    Please post back if it works for you ... otherwise explain a little further and let us take it from there!

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Guderup, Denmark
    Posts
    288
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    there is a way to do this but i don't know how practical it is.
    under Controlpanel / regional settings / numbers change your listseperator from , to |
    This wiill change your delimiters, but will also have an effect on the listseprator you use in excelfunctions.

    regards Tommy

  5. #5
    New Member
    Join Date
    Feb 2002
    Location
    State? Insanity! :)
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OK.. Maybe my post wasnt worded quite right, or I am not understanding the answers

    Text to columns works "backwards" from what I am trying to do..
    I have a spreadsheet.. columns a - o
    even if there is no value within a cell, I need to have everything | delimited.
    SO.. if I had
    1 2 3 4 6 7 9 I would need
    1|2|3|4||6|7||9
    so.. I have to export it to a |delimited text file.

    Did that make better sense?

    And Tommy.. I will look into that method, even if I can change that export, and change it back, thats fine.. since I am exporting text, it doesnt matter about my formulas for that exact document. So.. that might work?

    [ This Message was edited by: vampcatt on 2002-04-19 17:57 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •