Split the string

rupaliqlik — Sat, 16 Nov 2024 20:07:50 GMT

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

Re: Split the string

Vegar — Fri, 06 Sep 2019 04:38:53 GMT

Try this

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

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

Re: Split the string

rupaliqlik — Fri, 06 Sep 2019 06:53:11 GMT

Thanks

topic Split the string in QlikView

Split the string

Re: Split the string

Re: Split the string