RegEx

[yilingchen02]

Hi there,

I have extract the content after "_". For example:

Before:

2022_NZ_ABC

2022_NZ_DEF

2022_NZ_GHI

After:

ABC

DEF

GHI

How can I achieve this using RegEx?

Thanks,

Yiling

[flying008 · Accepted solution]

Hi, @yilingchen02 

^.*_([a-zA-Z]+?)$

[ShankerV · Accepted solution]

Hi @yilingchen02 

One way of doing this.

Many thanks

Shanker V

[yilingchen02]

It worked! Many thanks

[yilingchen02]

Sorry one complication: when my input looks like this 2022_NZ_JK-LMN, I was expecting output "JK-LMN", but the above RegEx would return null. How can we handle inputs with hyphen?

THanks,

Yiling

[ShankerV · Accepted solution]

Hi @yilingchen02 

Please find the modified regex code.

Many thanks

Shanker V