topic Re: trim statement in QlikView

trim statement

everest226 — Wed, 25 Nov 2020 16:16:04 GMT

HI i have a field Name PANACNO which his following values .

PANACNO

1:1-2-3-4-5

1:1-2-3-4-5-6

1:1-2-3/2:4-5-6

1:1-2-4-3

1:1-2/2:3-4

1:2-1

1:2-1-3

1:2-3

1:2-3-4

and my statement is following

if(len(PANACNO )>3,
mid(PANACNO ,
Index(PANACNO ,'-',-1) ),1)

which will give me value but with(-). i only want number.

stalwar1‌

Re: trim statement

m_woolf — Wed, 14 Feb 2018 19:13:03 GMT

What are you wanting to get?

Re: trim statement

everest226 — Wed, 14 Feb 2018 19:25:04 GMT

Last number ,basically

Re: trim statement

Anonymous — Wed, 14 Feb 2018 19:37:11 GMT

try subfield(PANACNO,'-',-1)

Re: trim statement

everest226 — Wed, 14 Feb 2018 19:40:25 GMT

No it doesnot give me any value beside ( -)

Re: trim statement

Anonymous — Wed, 14 Feb 2018 19:42:50 GMT

what result do you expect for?:

PANACNO

1:1-2-3-4-5

1:1-2-3-4-5-6

1:1-2-3/2:4-5-6

1:1-2-4-3

1:1-2/2:3-4

1:2-1

1:2-1-3

1:2-3

1:2-3-4

Re: trim statement

m_woolf — Wed, 14 Feb 2018 19:44:06 GMT

If you want to fix your expression:

if(len(PANACNO )>3,
mid(PANACNO ,
Index(PANACNO ,'-',-1) )+1,1)

Re: trim statement

everest226 — Wed, 14 Feb 2018 19:44:22 GMT

Trying to capture

1:1-2-3-4-5 5

1:1-2-3-4-5-6 6

1:1-2-3/2:4-5-6 6

1:1-2-4-3 3

1:1-2/2:3-4 4

Re: trim statement

Anonymous — Wed, 14 Feb 2018 19:46:59 GMT

... works for me:

LOAD SubField(PANACNO,'-',-1) as FIELD INLINE [

PANACNO

1:1-2-3-4-5

1:1-2-3-4-5-6

1:1-2-3/2:4-5-6

1:1-2-4-3

1:1-2/2:3-4

1:2-1

1:2-1-3

1:2-3

1:2-3-4

];

Re: trim statement

zebhashmi — Wed, 14 Feb 2018 19:51:07 GMT

right(PANACNO,1)

Re: trim statement

everest226 — Wed, 14 Feb 2018 19:51:21 GMT

I have attach the qvw

Re: trim statement

everest226 — Wed, 14 Feb 2018 19:51:46 GMT

i have attach the qvw sample

Re: trim statement

Anonymous — Wed, 14 Feb 2018 19:54:48 GMT

please have a look

Re: trim statement

everest226 — Wed, 14 Feb 2018 20:02:50 GMT

yes wanted to fix same expression , i have attach the qvw sample

Re: trim statement

everest226 — Wed, 14 Feb 2018 21:19:30 GMT

i forgot to mention you that all the last number After last ( -)

so if

1:1-2-3/2:4-5-6 6

1:1-2-4-38 38

1:1-2/2:3-498 498

Re: trim statement

Digvijay_Singh — Wed, 14 Feb 2018 21:49:17 GMT

Subfield is the best option for this as suggested by roharoha

SubField(PANACNO,'-',-1)

Re: trim statement

shiveshsingh — Thu, 15 Feb 2018 04:56:30 GMT

T:load * inline [

PANACNO

1:1-2-3-4-5

1:1-2-3-4-5-6

1:1-2-3/2:4-5-6

1:1-2-4-3

1:1-2/2:3-4

1:2-1

1:2-1-3

1:2-3

1:2-3-4 ];

load SubField(PANACNO,'-',-1) as Output

Resident T;

drop table T;

Re: trim statement

shiveshsingh — Thu, 15 Feb 2018 04:57:01 GMT

SubField(PANACNO,'-',-1)