String Split On CSV asp.net C#

Question

A574A02211 S193FDRA3 20141023S17337 WAN HAI 307

A024A13787 S1023F S1023F WAN HAI 316

A574A02181 S187FDRA3 20141024S17337 WAN HAI 307

i have a csv file like that as above but,

nextCellPlace = FindNextCell(data[dataCounter], spacePlace);
spacePlace = data[dataCounter].IndexOf(" ", nextCellPlace);
arrivalShip.Add(GetCellValue(data[dataCounter], nextCellPlace, spacePlace));enter

im using this code get a third column data, but i wantto slipt front date data and string data, like that this

A574A02211,S193FDRA3,20141023,S17337,WAN HAI 307

if met at no date data i wantto write down NULL then goto continue get second data

like that this

A574A02211,S193FDRA3,20141023,S17337,WAN HAI 307

A024A13787,S1023F,NULLDATE,S1023F,WAN HAI 316

A574A02181,S187FDRA3,20141024,S17337,WAN HAI 307

If data is in fixed width format then instead of split use substring to get each value and then use length to check for date data. SubString on MSDN — haraman
– haraman, Commented Nov 3, 2015 at 7:45

Hamed · Accepted Answer · 2015-11-03 07:28:58Z

2

You can get lines of your csv file using the following.

string[] lines = File.ReadAllLines(pathToCSVFile);

Then, you can split each line and analyse its containing.

for(int i = 0; i < lines.Length; i++)
{
   string[] fields = lines[i].Split(" ", StringSplitOptions.RemoveEmptyEntries);

   // analyse the fields
}

Not that the number of elements in fields can be considered as a hist that whether the line contains Data or not.

answered Nov 3, 2015 at 7:28

Hamed

1,2133 gold badges22 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Thomas Over a year ago

Are you sure about split(" " ? not split "," ?

Ekrem Tapan Over a year ago

i dont use split for ',' i just seperate this data == 20141023S17337 like that this 20141023,S17337, if front no date like that this nulldate, S17337

Kvam · Accepted Answer · 2015-11-03 08:15:31Z

There are a few cases that makes a simple .Split(' ') not work: blank values and values containing spaces. How about defining an array of indexes where you want to split your data, then run a set of substring operations to split it the way you want? This will also allow you to split in the middle of words such as 20141023S17337 => 20141023, S17337.

var input = @"A574A02211     S193FDRA3     20141023S17337     WAN HAI 307
A024A13787     S1023F                S1023F     WAN HAI 316
A574A02181     S187FDRA3     20141024S17337     WAN HAI 307";

var positionsToSplitOn = new int [] { 0, 15, 29, 37, 48 };

var lines = new List<List<string>>();
foreach (var line in input.Split('\n'))
{
    var columnValues = new List<string>();
    for (int i = 0; i < positionsToSplitOn.Length - 1; ++i)
    {
        columnValues.Add(line.Substring(positionsToSplitOn[i], positionsToSplitOn[i + 1] - positionsToSplitOn[i]).Trim());
    }
    columnValues.Add(line.Substring(positionsToSplitOn[positionsToSplitOn.Length - 1]).Trim());
    lines.Add(columnValues);
}

Collectives™ on Stack Overflow

String Split On CSV asp.net C#

2 Answers 2

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Related