topic Re: Need logic help. in QlikView

Need logic help.

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

In Given Data I want character after customer and before Delivery.

These character represents the customer no.

Please help me out asap.

Thanks

Lalit Kumar

Re: Need logic help.

varshavig12 — Thu, 15 Dec 2016 03:57:35 GMT

What is the expected output ?

Please, give an example for the same.

Re: Need logic help.

varshavig12 — Thu, 15 Dec 2016 03:59:24 GMT

Are you looking for something like:

Customer 107001-00022 Sales order 107001-SO-1415-0023 Delivery address New Delhi

what character are you talking about ?

Re: Need logic help.

lalitkgehlot89 — Thu, 15 Dec 2016 04:08:04 GMT

Expected output should be like this:-

107001-00022

107001-00003

107001-00004

107001-00005

.. .. . . . . .

. . . .. . . ..

107001-00021

107001-00022

and so on.

Re: Need logic help.

varshavig12 — Thu, 15 Dec 2016 04:11:49 GMT

Try this,

=TextBetween(F1,'Customer','Delivery')

Re: Need logic help.

MarcoWedel — Thu, 15 Dec 2016 21:51:57 GMT

Hi,

maybe also helpful to trim the leading and trailing spaces as well:

LOAD A,
    Trim(TextBetween(A, 'Customer', 'Delivery')) as CustomerNo
FROM [https://community.qlik.com/servlet/JiveServlet/download/1178265-257593/test%20Data.xls.xlsx] (ooxml, no labels, table is LB11_20161215_084329);

hope this helps

regards

Marco

Re: Need logic help.

varshavig12 — Tue, 20 Dec 2016 03:47:40 GMT

Please close the thread by marking the answer as correct.