When you slice the CSV row data with embedded commas, double quotes and line breaks. it becomes complex to handle. An well defined RegEx will help you here. Here is handy RegEx “,(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))” which works great. Read more detail here.
Subscribe to:
Post Comments (Atom)
-
I was trying to install SharePoint 2013, the setup was complaining about a pending system restart. Even after multiple restart / Shutdown. ...
-
Recently a new learner of C# asked me a question on C# Virtual & Abstract properties. It turned out to a deep dive. Detail follows. D...
-
In SQL Server Integration services, we have Script Component, which can be used in Data Flow Task as Source, Destination or Transformation. ...
No comments:
Post a Comment