Split the string

[rupaliqlik]

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 

kaushik.solanki 

sunny t

[Vegar · Accepted solution]

Try this

Subfield(input, ' ',1) as code,

Mid(input, Index (input, ' ')+1) as desc

[rupaliqlik]

Thanks