trouble writing to csv file

Results 1 to 3 of 3

Thread: trouble writing to csv file

  1. #1
    PJ Guest

    Default trouble writing to csv file

    Hello. I&#039;m writing records from a table to a csv file. All is well except for when a field contains a comma (such as "Manager, Systems Engineering"). The comma forces the rest of the value to the next column. Is there a simple way to avoid this? I want to maintain the integrity of the value without throwing the csv out of order.<BR><BR>Thanks!

  2. #2
    Join Date
    Dec 1969

    Default RE: trouble writing to csv file

    if instr(datafield,",") &#062; 0 Then<BR>datafield = """" & datafield & """"<BR>End If

  3. #3
    PJ Guest

    Default thanks

    that did the trick

Posting Permissions

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