topic Re: Remove spaces before a string in Talend Studio

Remove spaces before a string

stephbzr — Fri, 15 Nov 2024 22:42:59 GMT

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

Re: Remove spaces before a string

SMR040 — Fri, 22 Jul 2022 12:08:52 GMT

Have you tried the Trim function?

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

Re: Remove spaces before a string

gjeremy1617088143 — Fri, 22 Jul 2022 12:38:46 GMT

Hi @Stéphane Barbezier

StringHandling.FTRIM("your string here")

Send me love and kudos

Re: Remove spaces before a string

PeggieP — Sat, 23 Jul 2022 06:16:39 GMT

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

Re: Remove spaces before a string

stephbzr — Sat, 23 Jul 2022 18:06:02 GMT

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.