topic Re: regex replace in Talend Studio

regex replace

Anonymous — Thu, 26 Sep 2013 17:09:07 GMT

Hello Everybody,
I want to use regex to mask somme caractere. For exemple, I have this model : 0000 zzzz 0000 yyyy 0000
that's mean that the 4 first positions( first bloc ) will not be replaced and also the third and the fifth.
For the second bloc, i will replace mask using "z".
For the 4th bloc, I will replace by "y".
How can I do it with talend?
thank u for help

Re: regex replace

Anonymous — Fri, 27 Sep 2013 02:50:57 GMT

Hi,
Could you please check the component tFileInputRegex to see if it what are you looking for?
Best regards
Sabrina

Re: regex replace

Anonymous — Fri, 27 Sep 2013 09:23:19 GMT

Could you please show me a example coz I'm newbie in Talend.
Thank you

Re: regex replace

Anonymous — Tue, 01 Oct 2013 13:42:02 GMT

Could somebody help me to find a solution for my problem.
Thank you

Re: regex replace

Anonymous — Tue, 01 Oct 2013 16:07:36 GMT

hey,
try (input)------tNormalize----tSampleRow--------tReplace (or tJavaRow)
in tNormalize choose " " as separator and in tSampleRow choose line 2 and 4 with "2,4", then use tReplace or tJavaRow.

Re: regex replace

Anonymous — Wed, 02 Oct 2013 07:07:55 GMT

or just do in a tMap
input_row.your_column.susbtring(0,6) + " " + input_row.your_column.susbtring(input_row.your_column.length()-6,input_row.your_column.length())

Re: regex replace

Anonymous — Wed, 02 Oct 2013 10:55:18 GMT

hi,
using substring, if pattern change the result will be wrong or a bound exception.
So could be if the format is quite "static".
regards
laurent

Re: regex replace

Anonymous — Fri, 04 Oct 2013 09:29:59 GMT

It's not a static, the model is dynamic . I managed to do that :
4567 - ZA15 - B985 - 7413 - C5D4 but it replaces juste one time!!!
How can I do it many times
Thank you