RegEx expressions deleting Suffix

Hi,

I've taken over a flow from a staff member that has left. The way it is created it pulls employee information and job numbers from a Sharepoint list, standardises the names using a find and replace and then goes on to push out templates based on Job number. He has 3 ReGex tools built in that affect the job number column. One of these is removing the TW suffix from the start of the job number. this is needed later on in the flow to assign a company to the job. i dont really understand the regex and couldnt figure out how to stop this, could someone please help. I have the regex tools in the workflow attached.

Thanks

Regex.yxmd

Regex

Accepted answers

fmvizcaino

Hi @chelseariver90 ,

Attached is an example showing how to get that done in an easier way. Since I don't have all the possibilities for the job number field, I could be simplifying, so let me know if I've done that.

Best,

Fernando Vizcaino

2020-01-16 Regex.yxmd

All comments

fmvizcaino

Hi @chelseariver90 ,

Would you be able to share some job number examples after the find/replace tool? It would be great to have at least 2 example, 1 that is working as expected and one that are not.

Best,

Fernando Vizcaino

chelseariver90

Thanks Fernando for the quick reply.

The job column has all its job numbers as TW then a 3 or 4 digit number after. TW1539 TW1896 etc but it also contains "sick, other, annual leave" and things like that. The Regex seems to be getting rid of all those ok but it is also taking the TW off the actual job numbers and just leaving the number.

Hope that is explained ok

thanks

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703