How to use Contains when String and Target are columns
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm trying to search a single value of Column A in comma separated list in Column B. But unfortunately Contains doesn't work with the format "Contains([Procedure], [HCPCS])
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That's a nice way to split column into rows. Thanks @bpatel I tried using the tool Text to Columns; looks like it has a limit of 43 rows. It doesn't split more than 43?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The Text to Columns tool does parse out more than 43 rows. The number of rows depends on what is being parsed out.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Not to diminish the utility of the solutions provided by @bpatel or @JShankman , but your initial Contains function had the fields reversed
"Contains([Procedure], [HCPCS])
The syntax is actually "Contains([Field to search in], [Value to find]) . if you change it to "Contains([HCPCS], [Procedure]), you'll find it returns true for the 1st record and false for the second
Dan
