Remove spaces before a string

[stephbzr]

Hello,

After reading the data in CSV, I need to remove spaces. 

I tried the advanced settings option "remove spaces at beginning and end of field..." of tFileInputDelimited, but it removes spaces after, I want only spaces before. Being new to java, I tried the stripLeading() method I found, but without success.

Is there a component or another java method I can use in tjava or another component?

 

Thank you for your help

[SMR040]

Have you tried the Trim function?

https://help.talend.com/r/en-US/8.0/data-mapper-functions-reference-guide/trim-function

[gjeremy1617088143 · Accepted solution]

Hi @Stéphane Barbezier​ 

StringHandling.FTRIM("your string here")

Send me love and kudos

[PeggieP]

I am also having the same Issue. Did you get any solution?

[stephbzr]

Yes it works very well, thank you  @guenneguez jeremy​ 

@Couch Lisa​ I used the solution in a tJavaRow , but you can also use it in a tMap.