topic Re: Substring in QlikView

Substring

Wed, 01 Jul 2015 02:44:15 GMT

Hi,

I have a question, i have a field that has the value like 'Hilary/12yo' i want to separate this data into two fields, let's say Name and Age. i want to cut the value when meet the '/' symbol and put 'Hilary' into Name field and put '12yo' into Age field. Does anybody know the function to separate the value ?

Really need your help, your comments and view are really appreciated.

Thanks

Re: Substring

sunny_talwar — Wed, 01 Jul 2015 02:48:09 GMT

If you are trying to do it in script, you can try this:

LOAD Fields,

SubField(YourField, '/', 1) as Name,

SubField(YourField, '/', 2) as Age,

From abc

HTH

Best,

Sunny

Re: Substring

sunny_talwar — Wed, 01 Jul 2015 02:53:08 GMT

Attaching a sample for reference.

Re: Substring

Wed, 01 Jul 2015 03:02:49 GMT

Hi Sunindia,

Thanks for your help. It works and solve my problem.