Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Creating Macro To Search String for Specific Values

enelson
5 - Atom

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.

4 REPLIES 4
BenMoss
ACE Emeritus
ACE Emeritus

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

MarqueeCrew
20 - Arcturus
20 - Arcturus

@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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
enelson
5 - Atom

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
5 - Atom

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. 

Labels