topic Re: Regex Expression in tmap in Talend Studio

Regex Expression in tmap

lmit — Sat, 16 Nov 2024 09:11:37 GMT

Hi All,

I have a input with special characters in a string, if i find special character the output should have data before special character

for example : Input file will be like below

data

------

abc-de

abcde+fg

Output file should be like

data

-----

abc

abcde

How can i achieve it,i tried with regexp but i couldn't get the correct..

What could be the regexp to handle all special characters in tmap or in routine also will be fine

Can anyone please suggest how can i achieve it.some help would be helpful for me as i have seen some posts but was not useful

Thanks in advance,

Lmit

Re: Regex Expression in tmap

ashif2 — Tue, 10 Oct 2017 12:29:47 GMT

public class HelloWorld{

public static void main(String []args){
System.out.println("Hello World");
String str="abc d +";
System.out.println(str.substring(0,str.replaceAll("[^a-zA-Z0-9]", "~").indexOf('~')));
}
}

Here is my approach,replace all non alphanumeric with '~', take the substring..

Re: Regex Expression in tmap

TRF — Tue, 10 Oct 2017 12:30:21 GMT

Hi,

Here it is:

You can copy/paste the regex from here:

row10.code.replaceAll("[-+].*$", "")

Hope this helps.

Re: Regex Expression in tmap

lmit — Tue, 10 Oct 2017 13:40:00 GMT

Hi Ashifa,

Thanks for your quick reply , you code is working fine but i missed one more point thats is ,

input file

data

-----

P100078-9

If the data has alphabets , we should remove that also, i.e., my output should be

output file

data

---

100078

first we need to check in data whether its having special characters and alphabets, if so we need to remove alphabets and need populate the data which is before the special character.

Thanks a lot, it was very helpful.

Thanks in advance,

Lmit

Re: Regex Expression in tmap

lmit — Tue, 10 Oct 2017 13:40:49 GMT

Thanks TRF for your reply

Re: Regex Expression in tmap

TRF — Tue, 10 Oct 2017 13:45:29 GMT

Complete with this:

row10.code.replaceAll("[-+].*$", "").replaceAll("[A-Z]", "")

Re: Regex Expression in tmap

ashif2 — Tue, 10 Oct 2017 14:06:37 GMT

We can do this with one replaceall

str.replaceAll("[^0-9]", "")

Re: Regex Expression in tmap

lmit — Wed, 11 Oct 2017 19:11:30 GMT

Thanks Guys for your replies but both of your codes are removing the alphabets.below is the code

removechar.substring(0,removechar.replaceAll("[a-zA-Z]","").replaceAll("[^a-zA-Z0-9]", "~").indexOf('~'))

I tried with below codes

str.replaceAll("[^0-9]", "") & replaceAll("[A-Z]",""), i tried with changing positions also but couldn't success.

Its not showing error but the output is coming with alphabet.

Thanks In Advance,

Lmit