Parsing Field

[dcjames]

I have a field with the following data

0 10 12 ? * 2,3,4,5,6 *

What I'm looking to do is get only the info between the *. Ultimately I would like to do some sort of if statement

e.g. If {field name} in ['1','2','3'] then "Weekly" else ""

Thought that would work but unfortunately it doesn't.

Any help is appreciated

 

[pmax9999]

Does the data always contain 2 *s. If so you could use the following code to pull out the data between them"

Trim(Split({Table.Data},"*")[2])

Does that help?

Cheers
Pete

 

[pmax9999]

And if you wanted to then test that result and return "Weekly" if it contains a 1, 2 or 3 you could use the following:

If      Trim(Split({Table.Data},"*")[2]) Like "*1*" or
        Trim(Split({Table.Data},"*")[2]) Like "*2*" or
        Trim(Split({Table.Data},"*")[2]) Like "*3*" 
Then    "Weekly"

Hope this helps.

Cheers
Pete

 

[dcjames]

Pete,

Thank you very much! This was exactly what I needed.

David