topic Re: RegEx - tmap in Talend Studio

RegEx - tmap

onchar — Sat, 16 Nov 2024 04:27:34 GMT

I have a field called Name which I am pulling from Salesforce. This field is annotated with a date/time stamp which is fine, but in order for me to use that field as a lookup, I need to completely remove the date/time stamp any space(s) in the end of the string. For example:

the string = somenamehere with spaces2019-10-05 07:01:09

tmap=row3.Name.replaceAll("\\d[:-]*","")

results = somenamehere with spaces

the results above has an extra space - might be hard to see --which I am running out of options on how to get rid of it.

My output file is a txt file with a field separator of a semi colon.

Any suggestions folks on how to setup my RegEx?

Re: RegEx - tmap

TRF — Mon, 07 Oct 2019 06:52:50 GMT

(row3.Name.replaceAll("\\d[:-]*","")). replaceAll(" $", "")

Re: RegEx - tmap

TRF — Mon, 07 Oct 2019 20:33:50 GMT

Did this help?
If so thanks to mark your case as solved.

Re: RegEx - tmap

onchar — Mon, 07 Oct 2019 21:25:18 GMT

Thank you so much.

Your way works better - before i saw this i had everything but . replaceAll(" $", "")

And I was using .trim() which wasn't consistent with some of the names in the file. - Thanks again.