Forum Discussion

FP68's avatar
FP68
Helper I
7 months ago
Solved

Syntax problem

Hello, I've a clolumn with a long string [TAGS] in which I can find "ApplicationName=xxxxxx" In this string, each data is separate with ";" I just want to know the position of the ";" after the "A...
  • MasonMA's avatar
    MasonMA
    7 months ago

    Hi, 

    You may try

    Countries2 =
    VAR _x =
        SEARCH ( "ApplicationName=", [TAGS], 1, BLANK() )
    VAR _z =
        _x + LEN ( "ApplicationName=" )
    VAR _result=
        SEARCH ( ";", [TAGS], _z, BLANK() )
    RETURN
        _result
     
    Tested with some random data. 

     


     


     

MasonMA's avatar
MasonMA
Super User
7 months ago

Hi, 

You may try

Countries2 =
VAR _x =
    SEARCH ( "ApplicationName=", [TAGS], 1, BLANK() )
VAR _z =
    _x + LEN ( "ApplicationName=" )
VAR _result=
    SEARCH ( ";", [TAGS], _z, BLANK() )
RETURN
    _result
 
Tested with some random data.