Hello,
I'm having a little trouble creating a regular expression to extract some information from a string. Given the string
Column : Indv Clt Id ("COMP"."V01TPRFL_RLT_CLT""INDV_CLT_ID")
I want to extract the portions
Indv Clt Id
V01TPRL_RLT_CLT
INDV_CLT_ID
At the moment my regular expression looks like this
This is the output being captured by this expression.
Label = Indv Clt Id
Table = TPRFL_RLT_CLT
Field = INDV_CLT_ID
It all looks ok except table should be V01TPRL_RLT_CLT. Can anyone tell me why I'm not capturing the entire string? Thanks for all your help!
I'm having a little trouble creating a regular expression to extract some information from a string. Given the string
Column : Indv Clt Id ("COMP"."V01TPRFL_RLT_CLT""INDV_CLT_ID")
I want to extract the portions
Indv Clt Id
V01TPRL_RLT_CLT
INDV_CLT_ID
At the moment my regular expression looks like this
Code:
$_ =~ /Column\s*:\s*(.+)\s*\("COMP"\."(.+)""(.+)"/
This is the output being captured by this expression.
Label = Indv Clt Id
Table = TPRFL_RLT_CLT
Field = INDV_CLT_ID
It all looks ok except table should be V01TPRL_RLT_CLT. Can anyone tell me why I'm not capturing the entire string? Thanks for all your help!