Dear all,
I try to get the regexmatch formulae so that if the pattern is match with case 1 or 2 below then proceed with next step, if it falls to case 3 then return to error.
Case 1: My best company_0123456798_Something 2 documents_Calculation 1
Expected result: True
Case 2: Company 9A_0123456798_dhjgsfhjg_hgjhg
Expected result: True
Case 3: 0127637655_Bcd-gjgajg
Expected result: False
I have write the below formulae but it does not working. Please help me. Thank you.
^[A-Z|0-9|\s*]\_\d{10}\_*
Solved! Go to Solution.
Without knowing all the rules I've built the following which returns the correct result:
^.*?[_]\d{10}.+
Hope this helps,
M.
Hey @smile_dt06
does this work?
REGEX_MATCH([Field],'[A-Za-z0-9 ]*_\d{10}_.*')
Which should only be true for strings that start with a combination of letters, numbers and spaces, followed by a 10 digit number flanked by underscores
Hope that helps
Ollie