How to find out if a string contains a specific string in it?

[Ben Ronen]

Hey,

what should I use in a conditional statement in order to execute a command only on observations whose string variable (their name) contains a specific phrase?
For example, I'm looking for something like:

replace var = x if name _____________

where the "______________" part should check if a specific sequence of letters I'll define is part of name.

Thanks in advance,
Ben

[William Lisowski]

replace var = x if strpos(name, "_____________")>0

or looking at your previous posts, if you are using non-English text,

replace var = x if ustrpos(name, "_____________")>0

would probably be a better choice, and would work in either case, while strpos will only work with single-byte characters.

[Ben Ronen]

Thanks a lot William!

[vicky chann]

replace var = x if strpos(name, "_____________")>0

or looking at your previous posts, if you are using non-English text,

replace var = x if ustrpos(name, "_____________")>0

would probably be a better choice, and would work in either case, while strpos will only work with single-byte characters.

hi William, what if I am checking whether multiple strings is contained in a very long string?

[Hemanshu Kumar]

You would just use the or/and operators, depending on whether you want any of those multiple strings to figure, or all of them to figure in the string variable:

replace var = x if ustrpos(name, "xxxxxxxxxxxxxx")>0 | ustrpos(name, "yyyyyyyyyyyyyy")>0 | ustrpos(name, "zzzzzzzzzzz")>0

OR

replace var = x if ustrpos(name, "xxxxxxxxxxxxxx")>0 & ustrpos(name, "yyyyyyyyyyyyyy")>0 & ustrpos(name, "zzzzzzzzzzz")>0