topic Re: purge function- where error? in QlikView

purge function- where error?

Tue, 28 Oct 2014 15:25:47 GMT

Hello,

Could anyone tell me, plese, why

PurgeChar(peek(debit_date), SubField(peek(debit_date),'-',1))

returns '-8.5.24',

if the incoming string is '100000-08.05.2014'?

Thanks in advance

Re: purge function- where error?

Kushal_Chawda — Tue, 28 Oct 2014 15:29:39 GMT

what exactly output you need?

Re: purge function- where error?

Tue, 28 Oct 2014 15:38:28 GMT

'-08.05.2014'

Re: purge function- where error?

Kushal_Chawda — Tue, 28 Oct 2014 15:40:43 GMT

try like this

Subfield( Debit_Date,'-',2)

Re: purge function- where error?

Tue, 28 Oct 2014 15:50:37 GMT

Because the function returns 100000 (1 and 0) as characters to exclude in the string -08.05.2014

Re: purge function- where error?

MarcoWedel — Tue, 28 Oct 2014 15:58:48 GMT

SubField(peek(debit_date),'-',2)

Re: purge function- where error?

MarcoWedel — Tue, 28 Oct 2014 15:59:50 GMT

forgot the leading '-':

'-'&SubField(peek(debit_date),'-',2)

Re: purge function- where error?

MarcoWedel — Tue, 28 Oct 2014 16:01:01 GMT

Or simply

Right(peek(debit_date),11)

if the date format is always the same

Re: purge function- where error?

Wed, 29 Oct 2014 09:49:53 GMT

Marco, thank you for response.

The problem is that rhe string is not always '100000-08.05.2014' it might be a longer string, containing debt and its start_date.... it might be '100000-08.05.2014-50000-25.04.2014', for example. and i need to evaluate the first subfield (this is the sum of debt to be fully or partly repaid) and leave teh rest part of the string unchanged.

How can i solve it?

Re: purge function- where error?

MarcoWedel — Wed, 29 Oct 2014 10:00:26 GMT

The SubField(peek(debit_date),'-',2) solution should work for those field values as well:

regards

Marco

Re: purge function- where error?

Wed, 29 Oct 2014 10:01:09 GMT

Carlo Belletti, thank you for responce. Can you kindly explain how does it get '-8.5.24' in such way? and how to gwet the substring without first substring in such a way?

regards,

Alexa

Re: purge function- where error?

Wed, 29 Oct 2014 10:01:13 GMT

Hi,

it is giving correct answer only

here you have

if the incoming string is '100000-08.05.2014'

PurgeChar(peek(debit_date), SubField(peek(debit_date),'-',1))

returns '-8.5.24',

keepChar(peek(debit_date), SubField(peek(debit_date),'-',1))

it will give 100000

subfield(peek(debit_date),'-',1)) it will give 100000

subfield(peek(debit_date),'-',2)) it will give 08.05.2014

according to your requirement you can use these scenarios

Re: purge function- where error?

Wed, 29 Oct 2014 10:20:14 GMT

oh, yeah... now I understand my error... I thougth it works like subfielb, but extracts ... didnt mentioned that it takes away all the symbols =(

thanks for explanation/

Only question is why should

keepChar(peek(debit_date), SubField(peek(debit_date),'-',1))

give 100000 and not 1000000001?

Re: purge function- where error?

Wed, 29 Oct 2014 10:23:02 GMT

If I have figured out correctly your problem, i think a possible solution is:

Step1: index the '-' character with the index function

in your specified case index function in debit_date field, for '-' character returns 7

INDEX FUNCTION: index(debit_date,'-')

you have to use this value in the FINAL FUNCTION..

Step2

use the result of the first step to select only the string partyou need (in your case date part)

FINAL FUNCTION: mid(debit_date,index(debit_date,'-'))

This method solve the problem of the debit string lenght.

Re: purge function- where error?

Wed, 29 Oct 2014 10:23:10 GMT

Yeah you are right that keepchar syntax will give 1000000001

it will keep all the characters what we gave values to keep in the list

Re: purge function- where error?

Wed, 29 Oct 2014 10:39:31 GMT

Thank you, Carlo Belletti, for an interesting solution!

regards,

Alexa

Re: purge function- where error?

Wed, 29 Oct 2014 14:53:25 GMT

thank you once more Carlo Belletti because i've just understood, that YOUR answer is correct=)