Hi Team,
I'm struggling to get the regex expression for the following values. I want to capture the text before the first _ symbol into one field and after the _symbol value into another field. I need a common expression that works for all.
broadridge_endur_exch_trades_parent
1end_endur_exch_trades_parent
1end_endur_comp_trades_parent
1img_img_gl_000
1img_gl
1gmi_GNACMFF1
1lst_agr_trd
epx_epx_afs_file
fxcal_balance_report
I am using the following expression, but it's not working
rex field=Datafeed_name "^(?\w{3,10})_(?\w+)$"
Can you please help?
@vnravikumar @jakt54
\w
includes _
, that is where your attempt fails.
Try this; "^(?<field1>[^_]+)_(?<field2>\w+)$"
\w
includes _
, that is where your attempt fails.
Try this; "^(?<field1>[^_]+)_(?<field2>\w+)$"
thanks for the quick turn around mate...will check and confirm