This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.
I am trying to return using Regex or something else (text to col is not working) everything after a specific set of keys. When I apply "cinciii(.*)" on Regex is returning everything after "cinciii", but I want to return also "cinciii" and I want to add some more rules in order to not make a regex tool for every key. I have like 6 key that I need to use them :"patruuu, cinciii, sasee, sapteee, opttt, nouaaa" . There is any possibility to include them on a single formula?
Basically I want to return everything in RED.
Thank you in advance !
NR DOCUMENT CINCIII379296 SC DANIVA B.R.D. - G.S.G. AG.FILIASI
FACTURA: patruuu348145 B.R.D.#NAME?
FACTURA NR CINCIII380245 ALECCIA STIL FRUTTI 32080725 B.R.D. - G.S.G. SUC. TITAN BUCURESTI
You can run regex into a batch macro also to do this...
What I've attached could work for you... Basically you'd run the search term field in the ? anchor as the control field and your datasource into the other end of the macro input. It should search each field for every one of your regex terms and return a column for each of your search terms with the matching entry.
Should being the key word. I haven't tested it for your data but I did change the regex parse..
FYI - if you are only matching one of your keywords at one time in the field - go with @Jean-Balteryx or @AkimasaKajitani - if you need to match each key word against each entry - the batch macro is a better way.... The one keyword in each field can be done via the | option - but since regex will stop executing once a match is made - this will not work if you need to check each keyword against every record (and hope to get multiple results from each record).