1. TechSpot is dedicated to computer enthusiasts and power users. Ask a question and give support. Join the community here.
    TechSpot is dedicated to computer enthusiasts and power users.
    Ask a question and give support.
    Join the community here, it only takes a minute.
    Dismiss Notice

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: 10,046   +763

    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 New Comment

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