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
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.
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())
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