We are currently extracting data using this approach
But the Project Value can be present with space or without space(After Project Value) so how can we configure that have tried using Trim
1)Project Value - ABC
2)Project Value- XXX
3)Project Value -YYY
Thanks team in advance
Please try using the following RegEx pattern:
Hope this helps,
Hi @anmita ,
Could also try in the below way :
A Trim operation would be required after the Extraction
@arjunshenoy , @supermanPunch thanks for the quick responses
Just a question can it work in all scenarios if they have not kept any space
You could check the same in here : https://regex101.com/
So, When failing you can get the Input data on which it is failing and provide us with more info on the pattern.
Currently, it does accept with spaces or no spaces, but also a Hyphen is needed to be present.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.