topic Re: Using RegEx in tMap in Talend Studio

Using RegEx in tMap

kdv — Mon, 08 Oct 2018 21:46:04 GMT

Hi All

I am using a tMap to read in some data, transform it and output a new file.

I would like to use a regular expression to parse the string in one of the columns.

As an example, here is a raw input string:

Firstname Surname:Acme - 364315

I would like to be able to apply a regex to the above string to return only Firstname Surname

My syntax is totally wrong, but I am looking for something along the lines of row1.columname.parse("[^:]*") to go into the expression for that particular column

I understand there is a simple way to do this using the normal Java string manipulators to find the first instance of ":" and then get everything up to there. But I want to be able to use regex because I have more complex constructs that I want to be able to use regex with. Ie being able to use RegEx is important. Don't get hung up on the simplicity of my example above

What is the syntax I should be using please?

Thanks

Re: Using RegEx in tMap

TRF — Mon, 08 Oct 2018 22:07:57 GMT

From my understanding, you want to get the left part of row1.columname before ":". Right?
The simplest regex in this case is row1.columname.replaceAll(":.*$", "")
This method works for most cases as soon as you get the expression to represent what you want to remove.
String.split() may also be really usefull in many cases.
Home this helps.

Re: Using RegEx in tMap

kdv — Mon, 08 Oct 2018 22:13:32 GMT

Thanks, that worked. My regex wasn't working before. But your solution does the trick. Cheers!