how to compare two string with a specific number forme ?

Question

I have a list of string that contains invoice names,

FACTURE 147-2016 OCP CAMERAS
FACTURE 148-2016 OCP 20 DETECTEURS
FACTURE 150-2016 VIVOENERGY ALTAIR 5X
FACTURE 158-2017 VIVO ENERGY MOHAMMEDIA

I want to compare with the names in the list and the names in an excel file.

the excel file just contiet form

FACTURE 147-2016 or FACTURE150-2016

i try to use ( string.Split , string.contains ) but Sometimes there is space between invoice and code and sometimes not.

how cant i compare just with the code and year FACTURE 147-2016

Rafnas T P · Answer

just remove FACTURE from your string in the list and in excel and trim that string then you can compare ex FACTURE 147-2016 after removing FACTURE 147-2016 trim this then 147-2016 FACTURE147-2016 after removing FACTURE 147-2016 trim this then 147-2016

Mohamed Moumni · Answer

I fix it like this foreach (string n in ls_Nfacture) { string a= n.TrimStart(new char[] {' '}); string b = a.TrimStart(new char[] { 'F' 'A' 'C' 'T' 'U' 'R' 'E'}); string D= b.TrimEnd(new char[] {' '}); ls_num_Fact.Add(D); }