Query on REGEX

Hi !!

Example String is -> Rate of Interest 11.970 Current Balance 10,21,234

With the above example string I have, for Rate of interest, I need only the Numeric digits near it and if there is no number near Rate of Interest, like if the string is
“Rate of Interest Current Balance 10,21,234” then my expected output is “it should return an empty value.”

Thanks in advance !!

Hi @Rakesh_Sampath

Try this regex

(?<=Rate of Interest).[0-9 .,]+

Or u can try the below regex too

Use matches activitiy for this

If the output from matches activitiy is null then u can make sequence to return an empty value

3 Likes

Got it, Thanks @NIVED_NAMBIAR

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.