C# Reading CSV data with correct cell format using Regex

C# Reading CSV data with correct cell format using Regex.

I am facing issue with CSV cell format.

My excel data is as below:

Date      |    Acct    |  Name
20210928  |  3.02+ 13  | ABC

where Acct is 14 digit number. But Acct number is displayed as in above format.

Code for reading excel data is as below:

var csvlines = File.ReadAllLines(file);
Regex CSVParser = new Regex(",(?=(?:[^"]*"[^"]*")*(?![^"]*"))");
var csvLinesData = csvlines.Skip(1).Select(l => CSVParser.Split(l).ToArray());

With this code, CSV comma separated cells value will be added in Array.
But here for Acct field data is getting fetched as “3.02+ 13” but I need it as 14 digit number

How can I do that in above code? any thing to do with Regex?

Read more here: Source link