I have a problem while creating the CSV file. I use to write the CSV file by separating with delimiter "|", this works fine if any text doesn't have any commas (","). The problem is if any text contains comma, then the remaining text continues to next cell, which is wrong. look into the examples
Perfect line:
10|001300221|SIMSON||WILLIAMS|A|20080818|1525|8753||HOLZGRAFE|| PEDIATRICS INTENSIVE CARE|ASSISTANT PROFESSOR/CLINICIAN|GUH PASQUERILLA HEALTHCARE CNT
In the above case, CSV writes in the same cell and then fine.
with comma:
10|001300221|SIMSON||WILLIAMS|A|20080818|1525|8753||HOLZGRAFE|| PEDIATRICS, INTENSIVE CARE|ASSISTANT PROFESSOR/CLINICIAN|GUH PASQUERILLA HEALTHCARE CNT
look at the bold sentence, there you see the comma and the line after comma is seprating to next cell.
I don't want like that, is there anyway to skip that comma and need as it is in the written file?