CSV Data with Commas

Results 1 to 2 of 2

Thread: CSV Data with Commas

  1. #1
    Join Date
    Dec 1969

    Default CSV Data with Commas

    I&#039;m trying to parse a csv file that looks like this:<BR>"John Doe",<BR>"My Fake Company, INC",<BR>"Street 7907"<BR><BR>How can I use a reg exp to parse out the entire data field in the company field?<BR><BR>thanks<BR><BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: CSV Data with Commas

    This pattern will do the trick:<BR><BR>s*?("(?:""&#124.)*?")s*?(?=,)&#124([^,]+)

Posting Permissions

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