topic Re: Replace the character in STRING with tMap in Talend Studio

Replace the character in STRING with tMap

Anonymous — Mon, 04 Feb 2019 07:15:14 GMT

Hi there,

I have a String data "\N" in timestamp column and I'd like to replace this character into "null", then convert the type from STRING to DATE.

How can I define the conversion rule in tMap ??

manodwhb — Mon, 04 Feb 2019 07:18:31 GMT

@wakkieeeeee ,you can use the below way.

row3.newColumn1.replaceAll("/N","NULL").equals("NULL")?null:TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",row3.newColumn1 )

Anonymous — Mon, 04 Feb 2019 07:26:02 GMT

row1.data.replaceAll("\\\\N", "")

The above would replace \N to nothing in your string "data"

TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",
"<Your string here>")

Use above to parse date from string

Anonymous — Mon, 04 Feb 2019 09:19:58 GMT

Hi there,

Thank you for your advise!

Thanks to your help, I could replace the "\N" to "null" and convert from STRING to DATE.

By the way, I have to do the same things on the all columns..

How do I cope with it with tMap?

I assume that I can utilize the Var function.

The function I created is the below;

row2.session_start_time.replaceAll("\\\\N","NULL").equals("NULL")?null:TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",row2.session_start_time)

How can I apply this function to all columns??

manodwhb — Mon, 04 Feb 2019 09:35:15 GMT

@wakkieeeeee ,you need to define manually in tmap for each column.

Anonymous — Thu, 20 Jun 2019 02:01:05 GMT

I have to remove double quotes from string but its throwing me below in tmap.

error msg:

Multiple markers at this line

- The method replaceAll(String, String) in the type String is not applicable for the arguments

(String)

- Syntax error, insert ")" to complete MethodInvocation

- Syntax error, insert ";" to complete Statement

- String literal is not properly closed by a double-quote

Anonymous — Thu, 20 Jun 2019 03:54:49 GMT

never mind fixed this with
StringHandling.CHANGE(row1.CLRTY_PROJ_NM,"\"","\"\"")