Creating Macro To Search String for Specific Values

I have tried to create a macro that searches strings for specific value. I know that this function works when not set up as a macro but I would like to be able to set this up for repetitive use. I have a start to it but don't know why I can't get it to finish and pull out the text in the end. This is the first macro I have ever tried to create and would really like some assistance on what I need to do in order to make it work. I will attach what I have so far.

SearchString.yxmc

Macros

Accepted answers

enelson

I was able to figure out the issue. I didn't realize that you could change settings to be able to view messages from macros which helped me narrow down where the issue was occurring. The goal of this macro is to be able to tell someone who is unfamiliar with a database if a string exists and which field and row that string exists. DISCLAIMER: This will add computing time which is extremely noticeable for larger databases that are over 1 GB. This is for investigative purposes to help someone who is not familiar with a database.

SearchString.yxmc

All comments

BenMoss

Could you explain why the find and replace tool wouldn't offer the functionality you require?

MarqueeCrew

@enelson,

I had created a "contains in-list" macro for another user and placed it into the gallery. I think that you could learn from the macro (https://gallery.alteryx.com/#!app/Contains-In-List/5a5903fda18e9e2508e5ae0d) and modify it for your use (or use it as-is).

Please let me know your thoughts.

Cheers,

Mark

enelson

The Reason Find & Replace doesn't work is because I am looking for which field a string exists as well as a row to match. The Find & Replace tool (to my knowledge) does no offer that much functionality.

enelson

SearchString.yxmc

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703