Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi
I wrote the following Regex in Dataiku to extract the 8 digit number starting with 9.
Example: 93809629 or 93650953
Regex: [LCC|FACTURE\ |FACTURE][A-Z]{1,7}\s(\d\d\d\d\d\d\d\d)\
But it doesn't match for all the situations below.
1) LBB2022 FACT 93809929
2) LBBF.90930153 - 06/12/2021
3) LBBING FACTURE NO90857587 DU 02/12/21AFFRANCHISSEMENT
4) LBB90945758 CLT 662063
5) LBBFACT N 90903643 DU 02/12/2021
6) LBB93856595 FACTUREDEPARTEMENT
7) LBBFACTURE 93720887FRAIS AFFRANCHISSEMENTUSSY
๐ LBBFACT 93628786 DU 01/12/22
9) LBBFACTURE NO 93741852 DU 05/12/2022AFFRANCHISSEMENT
10) LBBN FACT : 93650972 REEUE LE 04/12/2022AFFRANCHISSEMENTS
Could anyone help me please?
Thank you so much
Operating system used: Windows
Hi, note that this has little to do with DSS itself ๐
You can try:
\D(9\d{7})(?!\d)
See it with your examples here: https://regex101.com/r/K30Fww/1
Hi, note that this has little to do with DSS itself ๐
You can try:
\D(9\d{7})(?!\d)
See it with your examples here: https://regex101.com/r/K30Fww/1
It works correctly!!! Thank you so much.