+ Reply to Thread
Results 1 to 3 of 3

Correct an unwanted split in csv file

Hybrid View

jreimer Correct an unwanted split in... 01-14-2008, 04:28 PM
chucklod Some thoughts 01-14-2008, 05:19 PM
jreimer Yeah, I'm aware that if I... 01-14-2008, 05:23 PM
  1. #1
    Registered User
    Join Date
    01-14-2008
    Posts
    18

    Correct an unwanted split in csv file

    I have a problem that I'm not sure if its able to be fixed with a macro or not, but I'd sure like it to be.

    I download a lot of leads for our company and the file that I received them in is a .csv file - I opened it up and I have column issues. Anywhere there's a comma, obviously, it got split - so, in a company column that ends in ", Inc.", the "Inc." got shoved to the next column, shoving over every column after that... there's a lot of these.

    Is there a way to automate a fix???? Even if its not perfect, just by finding a "Inc" (and some other known culprits) in column B and adding it to the end of column A and moving over the following columns would help out tremendously!

  2. #2
    Registered User
    Join Date
    01-07-2008
    Posts
    38

    Some thoughts

    This is a notorious problem with .csv files. I have not been able to find a single solution that corrects all problems, once the .csv file has been created. Post-creation editing almost always causes more problems than it creates. If your file is of any substantial size, manually scanning each line is terribly time-consuming, error-prone and frustrating. As you by this time are probably aware.

    If you have the ability to control the way file is created, you can try other separators, such as TAB character (which makes it a .tsv file), or vertical bar ( | ) character. Those are far less likely to conflict with cell contents.

    Chuck L

  3. #3
    Registered User
    Join Date
    01-14-2008
    Posts
    18
    Yeah, I'm aware that if I saved it as another format it would be much better, however, in this case, I don't. I was hoping for a solution

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1