Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

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

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

13 Replies

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

Not sure I understand your requirement? Can you elaborate?

Not applicable

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

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

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

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

MVP
MVP

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

did you mean?

load

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

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

AutoGenerate 1;

MVP
MVP

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

Maybe something like

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

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

maybe using the relational operators precedes/follows.

regards

Marco

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

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

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

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.

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

I still don't understand the requirement

Community Browser