Comma Separated Values

By giyad
Apr 2, 2007
  1. Ok, so I have a list of email addresses in an excel file(CSV) that I want to export. However, I want to add a comma to each email address.

    I also have the list in access and using the export function I can add a comma to the beginning and end of each row. However, I only want to add a comma to the end of each row. Does anyone know a way to add a comma in bulk to a list of values?
  2. Nodsu

    Nodsu TS Rookie Posts: 5,837   +6

    It's a single command line operation in a real operating system of course..

    How about you add a column with blanks or spaces after the e-mail addresses in Excel and export to a CSV file? The separating comma will be appended.
  3. jobeard

    jobeard TS Ambassador Posts: 11,173   +989

    any special character will do, *IF* it NEVER occurs an any field of the data.
    One that is seldom found in text is the TAB charater, \t or 0x09
  4. giyad

    giyad TS Enthusiast Topic Starter Posts: 59

    Worked like a charm! Thanks so much!
Topic Status:
Not open for further replies.

Similar Topics

Add your comment to this article

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...