In my data I have one string column. The data in this column can have several slash marks '/'. I need to extract the text between second and third slash mark.
num(subfield(SURCE_DATA,'/',2)) as SURCE_DATA_New
hope this helps
subfield(SURCE_DATA,'/',2) as EXTRACT
It will give result like
Subfield is the best function to achieve this.
Retrieving data ...