I'm currently working on a job but i'm facing a problem. I got a field that contains strings that i would like to separate in two columns but I can't find the good regex to split it in the way I want, here is an exemple.
All my fields are structured that way : " hello, my name is steven, I live in Paris (215484845)"
I want to separe it in : 1/ hello, my name is steven, I live in Paris and 2/ 215484845 <----- ( it's the ID)
But it may happens that some parenthesis can be found before the ones that handle the ID, but this one is always at the end of the string.
So if a string like this is find: "Hello, my name is jeff, i'm (27) and i like ice cream (58646846)" i want to split it that way:
1/ Hello, my name is jeff, i'm (27) and i like ice cream and 2/58646846
Thanks in advance for your help !
I think you're going to need to exploit the structure of the phone number to do this and split when the parser finds a parenthesized string with 9 digits (ignoring all other parenthesized tokens). Is that something you can do, or will that lead to data errors?
Please check the attached job.
two output ports:
row1.Desc is nothing but your input string.