I am trying to pull out a specific number from a text string using regex in UIPATH. The regex works in every case where there is not a colon in the text.
I am searching for the word EWO (with or without a :). i.e. EWO or EWO: I then require the 6 numbers which come after this word.
I have used the following up until I discovered there could be a colon: Text to search
TEST0203033 EWO 125399 WWT US QUOTE# 1235338.1
TEST0203033 EWO: 125399 WWT US QUOTE# 1235338.1
I have tried adding a :? to make the colon in the search optional, but get strange responses back.
In the String TEST0203033 EWO: 125399 WWT US QUOTE# 1235338.1
results : 12
Where I was expecting the result 125399
Original, does not work with colon
Produces some weird results