For every record where the field Test contains the word "Please" - I want to replace the string with "This is a test", below is the logic I am applying and it is not working- I tried using case, like, and a changed from " to ' and = to == but I cannot get anything to work.
| eval Test=if(Test=="Please", "This is a test", Test)
Try like this
...| eval Test=if(match(Test,"Please"),"This is a test", Test)
The equal sign does the exact comparison (value should match exactly). Since you want to check for "contains", you can use match(Test,"Please")
or like(Test,"%Please%")
.
Try like this
...| eval Test=if(match(Test,"Please"),"This is a test", Test)
The equal sign does the exact comparison (value should match exactly). Since you want to check for "contains", you can use match(Test,"Please")
or like(Test,"%Please%")
.
thank you this works!