Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi @Stéphane Barbezier
StringHandling.FTRIM("your string here")
Send me love and kudos
Have you tried the Trim function?
https://help.talend.com/r/en-US/8.0/data-mapper-functions-reference-guide/trim-function
Hi @Stéphane Barbezier
StringHandling.FTRIM("your string here")
Send me love and kudos
I am also having the same Issue. Did you get any solution?
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.