Replace the character in STRING with tMap

[Anonymous]

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]

@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]

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]

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??

tmap image03.PNG

[manodwhb · Accepted solution]

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

[Anonymous]

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]

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