Removing characters after the last _

[Sammy22]

Hello,

i have a field with names such as below and need to remove the numbers after the last _

ab_bread_21

bc_milk1_1

bc_tomato_75

solution required

ab_bread

bc_milk1

bc_tomato

please help!

[jdunkerley79]

You can use the REGEX_Replace functions something like REGEX_Replace([Field1],"_[^_]*$", "") should work

Have attached a sample

[atcodedog05 · Accepted solution]

Hi @Sammy22 

Here is how you can do it.

Workflow:

Hope this helps : )

[binay2448]

Find attached my solution...