Reply to thread

Message

<blockquote data-quote="fcsobel" data-source="post: 109139" data-attributes="member: 16823">I put up a new version that should get around the embedded commas.<a href="http://projects.c3o.com/MediaPortal/plugins.zip" target="_blank">http://projects.c3o.com/MediaPortal/plugins.zip</a>For those who care the problem is that JSON data is comma delimited but there may be commas within strings like this:&quot;Language, Sex, Violence, Other&quot;Regular expressions are the civilized way to get around this problem but they make my head hurt so I found an example here:<a href="http://www.4guysfromrolla.com/webtech/120400-1.3.shtml" target="_blank">http://www.4guysfromrolla.com/webtech/120400-1.3.shtml</a>Which helped me write this code to replaces the commas outside of quotes with '\b' which is then used to delimit the columns.string commapat = &quot;,(?=([^\\\&quot;]*\\\&quot;[^\\\&quot;]*\\\&quot;)*(?![^\\\&quot;]*\\\&quot;))&quot;;Regex reg = new Regex(commapat);RowString = reg.Replace(RowString, &quot;\b&quot;);</blockquote>

[QUOTE="fcsobel, post: 109139, member: 16823"] I put up a new version that should get around the embedded commas. [url]http://projects.c3o.com/MediaPortal/plugins.zip[/url] For those who care the problem is that JSON data is comma delimited but there may be commas within strings like this: "Language, Sex, Violence, Other" Regular expressions are the civilized way to get around this problem but they make my head hurt so I found an example here: [url]http://www.4guysfromrolla.com/webtech/120400-1.3.shtml[/url] Which helped me write this code to replaces the commas outside of quotes with '\b' which is then used to delimit the columns. string commapat = ",(?=([^\\\"]*\\\"[^\\\"]*\\\")*(?![^\\\"]*\\\"))"; Regex reg = new Regex(commapat); RowString = reg.Replace(RowString, "\b"); [/QUOTE]

Verification