topic how to delete blank spaces in 1 string (talend open studio) in Talend Studio

how to delete blank spaces in 1 string (talend open studio)

Anonymous — Mon, 24 Jun 2013 10:02:06 GMT

Hello
I have an error message "for input string: 14 789" when i would like transfer 1 file .csv to a table mysql.
I used Treplace ( replace " " with "") et tmap (StringHandling.EREPLACE(row1.Montant,"\\s","")
but my pbroblem always exists .
Thanks
Tha

Re: how to delete blank spaces in 1 string (talend open studio)

Anonymous — Mon, 24 Jun 2013 10:05:09 GMT

Hi,
There is also an option "Trim all columns" in Advanced Settings of tFileInputDelimited component.
Best regards
Sabrina

Re: how to delete blank spaces in 1 string (talend open studio)

Anonymous — Mon, 24 Jun 2013 10:08:54 GMT

Hi Tha
Just try this code in tJava and apply at rowlevel if you are using file component
String foo = " 14 789";
System.out.println("value = "+foo.replace(" ", ""));
System.out.println("value = "+foo.replaceAll("\\s", ""));

thanks
Anil Kumar Burri
http://anilkumarburri.wordpress.com/

Re: how to delete blank spaces in 1 string (talend open studio)

Anonymous — Mon, 24 Jun 2013 14:16:12 GMT

Hi,
Tk your solutions.
I tried your both 2 solutions: code java and "Trim all columns" in Advanced Settings of tFileInputDelimited. But no success.
For anilmca4u, there are 200 different lines "for input string" avec 200 values when i run my jobs:
For input string: "2 725"
For input string: "2 725"
For input string: "2 725"
For input string: "2 725"
For input string: "12 489"
For input string: "12 489"
For input string: "12 489"
For input string: "12 489"
For input string: "1 050" ...
TKs
Tha

Re: how to delete blank spaces in 1 string (talend open studio)

Anonymous — Mon, 24 Jun 2013 17:08:58 GMT

String foo = "2 725".replaceAll(" ", "");
Hope this will work for you..

Re: how to delete blank spaces in 1 string (talend open studio)

Anonymous — Mon, 24 Jun 2013 17:27:34 GMT

For umeshrakhe,
It didn't work. Sorry

Re: how to delete blank spaces in 1 string (talend open studio)

Anonymous — Tue, 25 Jun 2013 06:20:05 GMT

Hi Tha
Sorry but for me it is working fine for every value u given, for your reference find the screen shot

thanks
Anil Kumar Burri
http://anilkumarburri.wordpress.com/

Re: how to delete blank spaces in 1 string (talend open studio)

RA6 — Mon, 04 Jun 2018 13:55:50 GMT

@umeshrakhe

Can you help on this issue please?
Link: https://community.talend.com/t5/Design-and-Development/Tmap-Error-NumberFormatException-For-input-string/m-p/122572#M77213

Thank you.