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
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.
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.
