Mohamed Moumni

Mohamed Moumni

  • NA
  • 48
  • 8.4k

how to compare two string with a specific number forme ?

Jul 6 2017 5:43 AM
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 
 
 

Answers (2)