Enquiry of Regex_Replace function

Hi all,

As some data cannot convert to some format, any syntax can solve the below situations? The main issue is to remove the most right side of symbol "*"

Source :

[1] JL225*

[2] KM*130

[3] **WY2294

[4] UV3*35*7

Output :

[1] JL225

[2] KM*130

[3] WY2294

[4] UV3357

Thanks a lot.

Best Regards,

Johnny

Topic of Interest

Accepted answers

TomWelgemoed

Hi @johnnyycchan ,

This is a bit clumsy, but represents how my mind works!

if Contains([Field 1], '*')
Then
ReverseString(substring(ReverseString([Field 1]),FindString(ReverseString([Field 1]),'*'),Length([Field 1])-1))
else [Field 1]
endif

I'm basically reversing the text, finding the first instance of the character we're looking for, doing a substring from that point forward and then reversing the string back again. And I only do that where this character exists.

Hopefully that helps?

Regards,

Tom

All comments

TomWelgemoed

Hi @johnnyycchan ,

This is a bit clumsy, but represents how my mind works!

if Contains([Field 1], '*')
Then
ReverseString(substring(ReverseString([Field 1]),FindString(ReverseString([Field 1]),'*'),Length([Field 1])-1))
else [Field 1]
endif

Hopefully that helps?

Regards,

Tom

johnnyycchan

HI Tom,

It works. Thanks a lot.

Best Regards,

Johnny

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703