Monday, June 20, 2011

Are you slicing CSV row data

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.

No comments:

Post a Comment

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...