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)
Microsoft copilot Agent
In Copilot Chat https://m365.cloud.microsoft/chat Click on All Agents on side bar Copilot Studio Provide the details and you are agent is r...
-
In SQL Server Integration services, we have Script Component, which can be used in Data Flow Task as Source, Destination or Transformation. ...
-
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...
-
I was trying to install SharePoint 2013, the setup was complaining about a pending system restart. Even after multiple restart / Shutdown. ...
No comments:
Post a Comment