topic Re: Replace a string in Talend in Talend Studio

Replace a string in Talend

nikhilsh1 — Thu, 30 May 2013 11:48:34 GMT

Hi ,
I am having one complete line e.g 1|null|test.
I have to replace null with the ""(empty string) in Talend .
its a complete line and not a separate column.Because in our case its dynamic column content which are coming into one single column..?

Re: Replace a string in Talend

Anonymous — Thu, 30 May 2013 11:53:46 GMT

Hi,

its a complete line and not a separate column.Because in our case its dynamic column content which are coming into one single column..?

That means you cannot use method

ReplaceAll(string s1, string s2)

in tMap?
Best regards
Sabrina

Re: Replace a string in Talend

Anonymous — Thu, 30 May 2013 12:15:08 GMT

I would use the replace method from String.replace
s = s.replace("null", "\"\"")

Re: Replace a string in Talend

janhess — Fri, 31 May 2013 11:21:04 GMT

Or even s.replace("null","")

Re: Replace a string in Talend

Anonymous — Mon, 03 Jun 2013 04:23:22 GMT

Hi nikhilsh,
Is there any update for your issue?
Best regards
Sabrina

Re: Replace a string in Talend

nikhilsh1 — Mon, 03 Jun 2013 09:52:49 GMT

yes thank you for your update .its working but i want the output as dynamic column again and not the string as
we are converting it the string for processing ..

Re: Replace a string in Talend

Anonymous — Mon, 03 Jun 2013 10:01:02 GMT

Nikhil,
What is your output - file or database? support for dynamic schema will depend on that.
Thanks,
Nishad Joshi.

Re: Replace a string in Talend

nikhilsh1 — Mon, 03 Jun 2013 10:02:36 GMT

its a file not the database.we are creating it as input for our external table

Re: Replace a string in Talend

Anonymous — Mon, 03 Jun 2013 10:20:10 GMT

Then whatever you are saying is possible... you'll need more than one tMap to achieve this. Just make sure layout of the file does not change during transformation. One more thing, tSetDyanmicSchema component supports only positional file. For any other file type (Delimited, etc.), dynamic schema is your best bet.