topic [resolved] Trying to use StringHandling.CHANGE to replace "*" with " ". in Talend Studio

[resolved] Trying to use StringHandling.CHANGE to replace "*" with " ".

Anonymous — Sat, 16 Nov 2024 12:25:58 GMT

Hi,
I have a input row wich can contain "*", and I wan't to replace "*" with " " (e.g. "asd*asd" -> "asd asd"). I tried using this code in the output row expression in tMap:

StringHandling.CHANGE(TABLE1.ROW,"*"," ")

But I get this error:

Exception in component tMap_1
java.util.regex.PatternSyntaxException: Dangling meta character '*' near index 0
*
^
	at java.util.regex.Pattern.error(Unknown Source)
	at java.util.regex.Pattern.sequence(Unknown Source)
	at java.util.regex.Pattern.expr(Unknown Source)
	at java.util.regex.Pattern.compile(Unknown Source)
	at java.util.regex.Pattern.<init>(Unknown Source)
	at java.util.regex.Pattern.compile(Unknown Source)
	at java.lang.String.replaceAll(Unknown Source)
	at routines.StringHandling.CHANGE(StringHandling.java:87)
	at modelo181.preparar_tablas_0_1.Preparar_Tablas.tOracleInput_1Process(Preparar_Tablas.java:3490)
	at modelo181.preparar_tablas_0_1.Preparar_Tablas.runJobInTOS(Preparar_Tablas.java:17858)
	at modelo181.preparar_tablas_0_1.Preparar_Tablas.main(Preparar_Tablas.java:17726)

I also tried using:

TABLE1.ROW.replace('*',' ')

But I get this error:

Exception in component tMap_1
java.lang.NullPointerException
	at modelo181.preparar_tablas_0_1.Preparar_Tablas.tOracleInput_1Process(Preparar_Tablas.java:3490)
	at modelo181.preparar_tablas_0_1.Preparar_Tablas.runJobInTOS(Preparar_Tablas.java:17857)
	at modelo181.preparar_tablas_0_1.Preparar_Tablas.main(Preparar_Tablas.java:17725)

Sorry if this is a newbie question, thanks in advance,
Khor.

Re: [resolved] Trying to use StringHandling.CHANGE to replace "*" with " ".

janhess — Tue, 24 Jan 2012 11:51:22 GMT

have you tried TABLE1.ROW.replaceAll("*"," ")
I think your replace problem was because you have single quotes.

Re: [resolved] Trying to use StringHandling.CHANGE to replace "*" with " ".

Anonymous — Wed, 25 Jan 2012 08:11:58 GMT

Hi janhess, thanks for your reply
I tried TABLE1.ROW.replaceALL("*"," ") and it throws an error too:

Exception in component tMap_1
java.lang.NullPointerException
	at modelo181.preparar_tablas_0_1.Preparar_Tablas.tOracleInput_1Process(Preparar_Tablas.java:3490)
	at modelo181.preparar_tablas_0_1.Preparar_Tablas.runJobInTOS(Preparar_Tablas.java:17857)
	at modelo181.preparar_tablas_0_1.Preparar_Tablas.main(Preparar_Tablas.java:17725)

Re: [resolved] Trying to use StringHandling.CHANGE to replace "*" with " ".

janhess — Wed, 25 Jan 2012 09:08:07 GMT

Presumably you have a null value in table1.row. Try ! Relational.ISNULL(TABLE1.ROW1)?TABLE1.ROW.replaceALL("*"," "):""

Re: [resolved] Trying to use StringHandling.CHANGE to replace "*" with " ".

Anonymous — Wed, 25 Jan 2012 09:17:38 GMT

Hi janhess,
You're right, there is null values coming from the lookup table and the java function can't work with them, that's why I was getting NullPointerException errors.
Thank you,
Khor.