topic Re: text after char in QlikView

text after char

jood_ahmad — Mon, 18 Jan 2016 09:49:00 GMT

Dears,

how can i get the text after specific char like if i have :

ad,sj2

0,2

0,10

jak,kavin

and i need the just to retrieve only the char after the ',' i try the right but i cant apply it in all cases some time i did not get the right data

any idea about this .

Re: text after char

sunny_talwar — Mon, 18 Jan 2016 11:45:44 GMT

Have you tried SubField()?

May be this:

SubField(FieldName, ',', 2) as NewFieldName

SubField(FieldName, ',', -1) as NewFieldName

Re: text after char

Anonymous — Mon, 18 Jan 2016 11:56:58 GMT

Sunny, with this expression he will get complete subfield from specified location but as asked by him

and i need the just to retrieve only the char after the ','

I think he need char only, like say

ad,sj2 Here he should get sj onlly instead of sj2

Ahmad, Is it right??

Re: text after char

sunny_talwar — Mon, 18 Jan 2016 12:10:23 GMT

May be this in that case?

PurgeChar(SubField(FieldName, ',', 2) as NewFieldName, '0123456789') as NewField

Re: text after char

mohsinqlik — Mon, 18 Jan 2016 12:10:34 GMT

Adding to logic sunny shared

purgechar(SubField(FieldName, ',', 2),1234567890) as NewFieldName

Regards,

Mohsin

Re: text after char

Anonymous — Mon, 18 Jan 2016 12:14:55 GMT

Good One Sunny

Will this alias work inside the field parameter?

Re: text after char

sunny_talwar — Mon, 18 Jan 2016 12:29:49 GMT

Thanks man

Re: text after char

sunilkumarqv — Mon, 18 Jan 2016 12:33:33 GMT

perhaps you can use like this

subfield(PurgeChar(FieldName,'0123456789'), ',',2) as NewField

Re: text after char

jood_ahmad — Mon, 18 Jan 2016 13:45:16 GMT

yes

Re: text after char

jood_ahmad — Mon, 18 Jan 2016 13:47:25 GMT

Dears,

thank you very much to your replay the closest answer is Sunny

SubField(FieldName, ',', 2) as NewFieldName

the addition thing is define a variable to count how mane char after the ',' .

thank you all

Re: text after char

Mark_Little — Mon, 18 Jan 2016 14:37:06 GMT

Hi,

I would read that they only wants the first character after the comma or , char.

So something like

LEFT(SUBFIELD(FieldName,',',2),1) AS NewField

Mark

Re: text after char

kkkumar82 — Tue, 19 Jan 2016 10:31:12 GMT

Hope this may help you Len(SubField(F1, ',',2)) Thanks Kiran