Hello everyone,
I have two REGEXP_EXTRACT functions in Big Query SQL which I am trying to translate and use in ADF Mapping Data Flow as a derived column:
REGEXP_EXTRACT(lower(value), r".
eh=(.
?)&")
REGEXP_EXTRACT(lower(value), r"recommendation=([^&]+)")
regexExtract(lower(toString(value)),'.
eh=(.
?)&')
regexExtract(lower(toString(value)),'recommendation=([^&]+)')
Where value can be something like: brand=gucci%2cboss%2cburberry%2chugo+boss&
eh=1b7c5c4a90bed76ad175951d9921c40889ad06cef635f718eff764e0f06890f3
&gender=male&reco_src=app&recommendation=
framefit
&sorttype=price-asc
And and result should be:
1b7c5c4a90bed76ad175951d9921c40889ad06cef635f718eff764e0f06890f3
framefit
But I'm getting error in ADF: "Unable to parse the expression. Please make sure it is valid."
Thanks for your help!
Hello @
Petar Stojiljkovic
,
Please try the below expression!
regexExtract(lower(toString(value)), ".eh=(.*?)&")
regexExtract(lower(toString(value)), "recommendation=([^&]+)")
regexExtract(lower(toString(value)), '.eh=(.*?)&', 1)
regexExtract(lower(toString(value)), 'recommendation=([^&]+)', 1)
Azure Data Factory managed virtual network
