dan_stan
asked on
Function to select data between two characters
Hi,
I have lines in my database like the below-
Call assigned to the ABCD-NL/SALES/OFFICE01/ group by DSTN (switched in group context)
Call assigned to the ABCD-NL/ADMINISTRATION/OFF ICE01/ group by DSTN (switched in group context)
I want to be able to select fields in between the first two slashes -
SALES
ADMINISTRATION
Can you help me?
I have lines in my database like the below-
Call assigned to the ABCD-NL/SALES/OFFICE01/ group by DSTN (switched in group context)
Call assigned to the ABCD-NL/ADMINISTRATION/OFF
I want to be able to select fields in between the first two slashes -
SALES
ADMINISTRATION
Can you help me?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
,updatetxt as department From updatedb
This did the trick, not the prettiest, but it works!
Thanks