topic Re: Removing spaces from a string in java in Talend Studio

Removing spaces from a string in java

patricesoulet — Sat, 16 Nov 2024 14:11:17 GMT

Hello,
Anyone know how remove all spaces from a string in tMap with EREPLACE or with tReplace component ?
For example, if i have ' a3d fdj fdo fds fds &pp ', the result must be 'a3dfdjfdofdsfds&pp'.
I tried EREPLACE(string," ",""), EREPLACE(string,"\s",""), EREPLACE(string,"\\s",""), ...

Re: Removing spaces from a string in java

Anonymous — Wed, 22 Oct 2008 18:11:51 GMT

to remove beginning and trailing spaces:

StringHandling.TRIM(" hellow world! ")

EREPLACE worked for me (in TOS 3.0.0, see pics)

StringHandling.EREPLACE(row1.newColumn," ","")

Re: Removing spaces from a string in java

patricesoulet — Thu, 23 Oct 2008 10:24:35 GMT

Yes, rigth, that work ... in this case ...
But when string is from an Excel file, where the cell is formatted as number with space for thousands seprator ... spaces aree not removed ...
My job :

Re: Removing spaces from a string in java

patricesoulet — Thu, 23 Oct 2008 10:53:44 GMT

Finaly, i've find ... the thousands separator is not a space, but the hexa decimal caracter A0.
With StringHandling.EREPLACE(myString, "\\xA0",""), i can resolve my problem ...

Thanks for your help strpdsnk.

Re: Removing spaces from a string in java

Anonymous — Tue, 23 Feb 2016 10:06:01 GMT

how to remove space in a string in tmap "
ex " abc def " to "abcdef"

Re: Removing spaces from a string in java

Anonymous — Wed, 24 Feb 2016 08:50:55 GMT

columnName.replace(" ","")

Re: Removing spaces from a string in java

Anonymous — Wed, 24 Feb 2016 12:53:12 GMT

or column.replaceAll(" ","") if you wanna get more aggressive

Re: Removing spaces from a string in java

Anonymous — Wed, 24 Feb 2016 15:58:58 GMT

Both replace() and replaceAll() replaces all the occurrence found. However, there is difference in the type of arguments they accept.
replace() works on CharSequence, where as replaceAll(), accepts regex, so you can do a regular expression based pattern matching. The later is more flexible, but might result in a bit of performance overhead of compiling the regex and then do a matching.

Re: Removing spaces from a string in java

Anonymous — Thu, 25 Feb 2016 15:58:12 GMT

ah, I was not aware of the difference. thanks!

Re: Removing spaces from a string in java

Anonymous — Mon, 21 Nov 2016 16:47:56 GMT

Hi All,
Can any one tell me how to do this operation
For example, change format of older data from ‘13960036’ to ‘1396 0036’
so its like '1396<<4 space>>0036'
there are 4 spaces need to be added between the string
Please tell how i can do
thanks