Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tExtractRegexFields component

Hello (I am beginer in talend),

I want to create a job using tExtractRegexFields component in order to separate a column into two column.

 

The input column contain firstname last name separated with a space ex: " Steve Jobs". i want an output with two columns firstname "Steve" and another last name "Jobs".

 

I dont find the write expression to put in Regrex: I tried this one "(\\w+)(.*)$" it doesn't work. I tried  " ([A-Z]*) ([A-Z]*)" it doesn't work too 😕

 

Could you help me to find the good expression? Thank you

Labels (2)
1 Reply
fdenis
Master
Master

try with " ([a-zA-Z]*)[ ]*([a-zA-Z]*)"