topic Input Edit in QlikView

Input Edit

tmumaw — Thu, 22 May 2014 17:45:45 GMT

Hello all,

I have a file which I need to strip off a percentage. The format can be 1/100% or 25/25% or 11/100%. I only need the whole number at the beginning, but sometimes it can be 1 position and other times it can be 2 positions. Any ideas?

Thanks

Re: Input Edit

fkeuroglian — Thu, 22 May 2014 22:16:40 GMT

Hi, you can use SUBFIELD function

subfield(Field, ';' ,2)

gives:

'cde' if Field is 'abc;cde;efg'

in you case:

subfield(Field, '/' ,1)

would return the first part before the first /

good luck

Fernando

Re: Input Edit

tmumaw — Fri, 23 May 2014 10:54:58 GMT

Thank you Fernando. That worked perfectly. Have a great weekend.