Client Management Suite

I do not know c# at all but I need to pre-process a csv file that I am importing

 

essentially I have data such as

 

Serial Number         Model            Order Number

2xf434                    t420                     12345

SC02512312          Mac                       12323

 

Basically what I need it if it finds a row where if the serial number starts with SC  I need to it strip the C and just return C02512312 in the example above and if not just return the rows as they are in the csv to begin with.

 

Any help is appreciated

 

Did the sharepoint team not strip it out for you? https://www.symantec.com/connect/forums/how-do-i-pre-process-import-data-importing-computers I've not tested this but from the links above you can loop all the data for (int i = 0; i < importData.Rows.Count; i++) { DataRow row = importData.Rows[i]; //need to get the column name, 0 should work if (row[0].StartsWith("SC") { row[0].Substring(1, row[0].Length-1) } }

No they were no help, lol

 

I'll test and tweak with what you have above which gives me a good starting point

thanks