I have CSV logs I'm bringing in that can sometimes have a comma in the value, and IF a comma exists then the value will be surrounded in quotes, otherwise it will not be quoted. for example the CSV data below:
05052021,"001,003",Joe Smith,"description, with a comma"
05052021,002,"Jones,Bill",description without a comma
05052021,003,"Smith,Emmitt","again, with comma"
I'm assuming this will be done with regex, but I'm nto sure how to go about it. Thanks in asvance!
Please sign in to leave a comment.