Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have a field which contain code and desc together.I want to separate the string and convert it into Code and Desc.With the help of sunfield I can fetch code but there are multiple spaces that is why I can't fetch Desc .
Example
1011700 CareFusion Australia 316 Pty Ltd -
1011702 CFN New Zealand 313 Ltd
Output:
Code:1011700
Desc CareFusion Australia 316 Pty Ltd
Code :1011702
Desc:CFN New Zealand 313 Ltd
Try this
Subfield(input, ' ',1) as code,
Mid(input, Index (input, ' ')+1) as desc
Try this
Subfield(input, ' ',1) as code,
Mid(input, Index (input, ' ')+1) as desc
Thanks