Post reply

Comma seperated file

  • May 13, 2009 at 12:05 pm

    #131343

    In my package I'm outputting the results to a csv file which is comma delimited. In the address column some of the address has comma for e.g. Department of Language and Literature, Japanese Section, Box 87020. In this case the results are pushed to the next column. Is there a way I can keep the address in one column?

    Thanks,

    Bhavna

  • May 13, 2009 at 12:37 pm

    #993981

    Hello,

    Are you putting a " in the text qualifier box? This would force quotes around all the output fields which would eliminate the commas in that field from being recognized as delimiters.

    Thanks,

    Strick

  • May 13, 2009 at 12:50 pm

    #993992

    I'm not. Tried with the " in the text qualifier box and it worked. Thanks Strick!

    ~Bhavna

  • May 13, 2009 at 12:57 pm

    #994001

    You're welcome, glad I could help!

    Strick

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply