Forum Discussion

FP68's avatar
FP68
Helper I
6 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
    6 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. 

     


     


     

FP68's avatar
FP68
Helper I
6 months ago

Thanks a lot, it works fine