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. 

     


     


     

cengizhanarslan's avatar
cengizhanarslan
Super User
7 months ago

Please try the measure below:

Countries2 =
VAR _x =
    SEARCH ( "ApplicationName=", [TAGS], 1, -1 )
VAR _z =
    IF (
        _x > 0,
        SEARCH ( ";", [TAGS], _x, BLANK() ),
        BLANK()
    )
RETURN
_z