topic Re: Regular expression for one case in Talend Studio

Regular expression for one case

stephbzr — Fri, 15 Nov 2024 22:43:04 GMT

Hi, I can't find a regex model to handle two columns in my dataset.

Example :

RF_

RX_S

AF_G

EJ_

FG_

Expected result (remove the last _) :

RX_S

AF_G

Thanks for your help!

Re: Regular expression for one case

gjeremy1617088143 — Fri, 22 Jul 2022 06:19:26 GMT

Hi @Stéphane Barbezier

first case :

"_$"

an underscore at the end of the line.

second case :

"^0(?!\\d+)"

a 0 at the beginning of the line not followed by one digit ore more digit

send me love and Kudos

Re: Regular expression for one case

stephbzr — Fri, 22 Jul 2022 07:23:34 GMT

I have already tried this solution and it doesn't work ! Here is an illustration of my tReplace :

Result: identical, no change

I attach my excel file with the example.

For the second case, I found a solution : tConvertype (integer) sets this automatically

Thank you for your suggestion

Re: Regular expression for one case

gjeremy1617088143 — Fri, 22 Jul 2022 08:32:59 GMT

use advanced mode and not simple mode, or play with the checkbox global expression and whole word.

https://help.talend.com/r/en-US/7.2/processing/treplace

Re: Regular expression for one case

stephbzr — Fri, 22 Jul 2022 09:50:09 GMT

I had used the advanced mode, but it does not change anything. Maybe underscore is used in the regex models to match a string while I want to match this underscore

Re: Regular expression for one case

PeggieP — Fri, 22 Jul 2022 10:20:59 GMT

Nice and amazing post this one is, thanks for sharing.

Re: Regular expression for one case

gjeremy1617088143 — Fri, 22 Jul 2022 12:19:33 GMT

I've tested it with advance mode it's working :

replace"_$" by ""

input :

dgg_

ddf_dfdgg

_dgds_dgd

output:

dgg

ddf_dfdgg

_dgds_dgd

you can check in the tReplace component Schema if you have your fields in the output schema

Re: Regular expression for one case

stephbzr — Fri, 22 Jul 2022 13:54:01 GMT

Can you share a screenshot with me? I followed the instructions, but it doesn't work for me, maybe I missed something...

Setting :

Result :

Re: Regular expression for one case

gjeremy1617088143 — Fri, 22 Jul 2022 14:12:44 GMT