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

[#1]

Good afternoon,

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

Many thanks,

Leonardo

[sunny_talwar]

Not sure I understand your requirement? Can you elaborate?

[#3]

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]

did you mean?

load

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

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

AutoGenerate 1;

[swuehl]

Maybe something like

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

[MarcoWedel]

maybe using the relational operators precedes/follows.

regards

Marco

[MarcoWedel · Accepted solution]

like this:

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]

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