Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have the following data in my database as a single field.
(84700) Pharmacy.
From this field i would like to extract Two fileds.
84700 as ID and Pharmacy as Group.
Please, note i would like to ignore the brackets () here.
Can someone please provide some pointers.
TIA
Sai.
If the source field is [myfield]:
...
Purgechar(SubField(myfield, ' ', 1), '()') as ID, SubField(myfield, ' ', 2) as Group,
...
If the source field is [myfield]:
...
Purgechar(SubField(myfield, ' ', 1), '()') as ID, SubField(myfield, ' ', 2) as Group,
...
LOAD PURGECHAR(PURGECHAR(SUBFIELD(Field, ' ', 1),'('),')') AS ID, SUBFIELD(Field, ' ', 2) AS Group FROM...
Oh, well, so many people were faster than me. 😄