Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Script: checking whether a text string is between other text strings

Good afternoon,

text string 'SE38' is between strings 'SE16O*' and ' Z*'. Is there a script function to check for this?

Many thanks,

Leonardo

1 Solution

Accepted Solutions
MarcoWedel

like this:

QlikCommunity_Thread_203243_Pic1.JPG

table1:

LOAD *,

    string follows 'SE16O' and string precedes 'Z' as Flag

Inline [

string

SE38

68HC11

TI35

SN7400

QV12

_SE38

\SE38

+SE38

SE5

SE05

];

hope this helps

regards

Marco

View solution in original post

13 Replies
sunny_talwar

Not sure I understand your requirement? Can you elaborate?

Not applicable
Author

Hi Sunny,

I would need a function that can check if 'SE38' is between 'SE16O*' and ' Z*', which the case. A similar check would be if 'SE38' is between 'SEF*' and ' Z*', which is not the case.

Thanks

sunny_talwar

I am still not sure what exactly you are trying to do. Can you share few lines of data with expected output?

maxgro
MVP
MVP

did you mean?

load

     'SE38' > 'SE16O' and 'SE38' < 'Z',

     'SE38' > 'SEF' and 'SE38' < 'Z'

AutoGenerate 1;

swuehl
MVP
MVP

Maybe something like

=Wildmatch( Textbetween(TEXTFIELD,'SE160',' Z'),'*SE38*')

MarcoWedel

maybe using the relational operators precedes/follows.

regards

Marco

MarcoWedel

like this:

QlikCommunity_Thread_203243_Pic1.JPG

table1:

LOAD *,

    string follows 'SE16O' and string precedes 'Z' as Flag

Inline [

string

SE38

68HC11

TI35

SN7400

QV12

_SE38

\SE38

+SE38

SE5

SE05

];

hope this helps

regards

Marco

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Wow, learned something new. And you beat a few high-profiles along the way Maybe there is an advantage to being a foreign language-speaker after all.

sunny_talwar

I still don't understand the requirement