Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
lalitkgehlot89
Partner - Creator II
Partner - Creator II

Need logic help.

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

6 Replies
varshavig12
Specialist
Specialist

What is the expected output ?

Please, give an example for the same.

varshavig12
Specialist
Specialist

Are you looking for something like:

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

or

what character are you talking about ?

lalitkgehlot89
Partner - Creator II
Partner - Creator II
Author

Expected output should be like this:-

107001-00022

107001-00003

107001-00004

107001-00005

.. .. . . . . .

. . . .. . . ..

107001-00021

107001-00022

and so on.

varshavig12
Specialist
Specialist

Try this,

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

MarcoWedel

Hi,

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

QlikCommunity_Thread_243408_Pic1.JPG

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

varshavig12
Specialist
Specialist

Please close the thread by marking the answer as correct.