Using Find function

[Former Member]

I have group of words or string of words in a field. I need to pull unique word from those strings. E.g. pull logo out from field below.

Field:

Dmemrnnlogommm

Hunmbsglogonnnnn

Vsfttdvbz logo nnn

Shbsbbdh logo

Where field contain logo from above. I need to Extract logo.

l need help with variable to pull logo wherever there is logo in group of word or words in the field.

Thanks much

[amitrathi239 · Accepted solution]

try with this variable.

=if(match(field);"*logo*") then "logo" else (field)

[amitrathi239]

try this.

=If([Cond A]="All" And ([Cond B])="Trial"; "Test";

If([Cond A]="All" And ([Cond B])="Pool"; "Test1";

if(left(sample;1)="X" and (right(sample;3)="111”); "Fresh";"Test2"))

[Former Member]

Thanks Thanks Thanks!

[Former Member]

Thanks Amit - Works!! - Please see what I put together based on your response/answer. I need more assistance:

=If([Cond A]="All" And ([Cond B])="Trial"; "Test";

If([Cond A]="All" And ([Cond B])="Pool"; "Test1";

if(left(sample;1)="X" and (right(sample;3)="111”); "Fresh"))

The above variable works but I need to put another else after "Test1" before the if(left(sample;1.....). I am not getting it right.

This is what I want:

=If([Cond A]="All" And ([Cond B])="Trial"; "Test";

If([Cond A]="All" And ([Cond B])="Pool"; "Test1"; Else "Test2";

if(left(sample;1)="X" and (right(sample;3)="111”); "Fresh"))

Thank you.