see this link for previous blog http://me7486.blogspot.com/2008/06/regular-expression-for-parsing-csv-file_729.html
in addition to previous blogs, if you have situation like "this ""is"" not working",",right". you will need to use the following expression
((?(?=\x22)(?:\x22{1})(?<column>.*?)(?:\x22{1})|(?<column>[^,\r\n]*))(?:[,\r\n]))
in addition to previous blogs, if you have situation like "this ""is"" not working",",right". you will need to use the following expression
((?(?=\x22)(?:\x22{1})(?<column>.*?)(?:\x22{1})|(?<column>[^,\r\n]*))(?:[,\r\n]))
No comments:
Post a Comment