How to delimit?

My data just like that belowed

name,sex,phone-number,address,notes,email

"andrew","male","203-222-222","aab","pretty good job,need contince","adfsa@.yahoo.com"

....

so,Row delimiter is {CR}{LF} no problem

Column delimiter is Comma{,} appear error at notes including a comma inside the content

how should i delimit ? thanks

maybe between single quotes|||how to perform between single quotes?|||Have you tried the text qualifier option? The text values you have are indeed qualified with a double quote, so this will allow you to have a comma inside the text value.|||

it really like a double quote, although looks similar

can be working after specify text qualifier

thanks