I'm just getting started.
Now that I've imported my excel data, I want to write a bunch of policies relating the what text is in the columns.
It seems like CONTAINS is the right way to go but it doesn't seem to like the way I'm doing it:
CONTAINS(2P)
Gives me an error: Expected different text.
I also tried CONTAINS("2P")
Gives me an error: Function 'CONTAINS' can't accept parameters: (string).
What am I doing wrong?
Start simple...what are you expecting to pull out of your text column or what are you expecting as a result. Give us an example of what you expect to get from CONTAINS(2P)?
Usually I would see this as CONTAINS([Your Text Field],'2P') ...and then do something with that....such as, IF CONTAINS ([Your Text Field],'2P') Then 1 END as a flag. Or, IF CONTAINS ([Your Text Field],'2P') Then 'Blue' END And so on. OR you can leave it by itself as a TRUE|FALSE result: CONTAINS ([Your Text Field],'2P') Hope that points the way.
Best, Don
(Please, don't forget to click Select as Best or Upvote !)
