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)
Engineering Excellence
Engineering Excellence Having solid engineering process and tools in place help to improve the agility of the system. Here is the high-level...
-
In SQL Server Integration services, we have Script Component, which can be used in Data Flow Task as Source, Destination or Transformation. ...
-
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...
No comments:
Post a Comment