Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon,
text string 'SE38' is between strings 'SE16O*' and ' Z*'. Is there a script function to check for this?
Many thanks,
Leonardo
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
Not sure I understand your requirement? Can you elaborate?
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
I am still not sure what exactly you are trying to do. Can you share few lines of data with expected output?
did you mean?
load
'SE38' > 'SE16O' and 'SE38' < 'Z',
'SE38' > 'SEF' and 'SE38' < 'Z'
AutoGenerate 1;
Maybe something like
=Wildmatch( Textbetween(TEXTFIELD,'SE160',' Z'),'*SE38*')
maybe using the relational operators precedes/follows.
regards
Marco
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
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.
I still don't understand the requirement