Removing spaces from a string in java

[patricesoulet]

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",""), ...

[Anonymous]

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," ","")

[patricesoulet]

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 :

[patricesoulet]

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.

[Anonymous]

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

[Anonymous]

columnName.replace(" ","")

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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