Alteryx Community is the go-to hub for analytics professionals to learn, connect, and solve problems faster. Explore expert-led discussions, product resources, and best practices to build, automate, and scale your analytics workflows with Alteryx.
I have a text field with content such as this "2016-01-30_2.Monthly_P&L". I'd like to parse the field into 4 fields: Year, Month, Date and just a Name field so the fields would be: 2016-01-30_2.Monthly_P&L 2026 01 30 2.Monthly_P&L I used this RegEx expression "(\d+)-(\d+)-(\d+)_(\d+\.\w+\_\w+\&\w+)" but result looked like…
I need help Regex gurus. I have data in the attached file that needs to be parsed out into 4 columns. I included a screenshot on the output tab of what it should have in the 4 columns. I can get 75% of the way there but I can't get that last bit. I have tried a bunch of different ways, but the problem is that it's not a…
Hello Alteryx Experts! I know you will be able to help me find a solution to my issue. I have very dirty data, very dirty data! But there is hope at the end of the tunnel. I have a text field where I need to extract 3 numbers which occur together. Th first number will always be preceded with an "S", the next number by "O"…
I would like to extract 6 digit number from each row , each should start with reporting and rows have trailing spaces DATA REPORTING FOR: 1000035909 ABCD BANK MIPPL INTERNATIONAL SETTLEMENT SERVICE PROC DATE:10AUG25 REPORTING FOR: 100003570 ABCD BANK MIPPL INTERNATIONAL SETTLEMENT SERVICE PROC DATE:10AUG26 REPORTING FOR:…
Hello Professionals, I'd want to thank all professionals who helped me when I was stuck while studying for Alteryx Designer Core. I'm unsure if the next step is Alteryx Designer Advanced, but I'd like to continue learning more about Alteryx. Any advice and instructions on what sources to learn and practice is very much…
Hello, Could you, please help me? I want to check the AR_ Name column in the Client column and keep the common matching text (50-60% matching ). Moreover, if inside the AR_ Name clients have a similar name and if they do not match at all with the Client column, should return the AR_ Name. This should be applicable only for…
How do I remove invalid characters from an Excel filename using RegEx. I.E. I don't understand how to populate the Regular Expression field. Thank you. Brian
I'm struggling with splitting string in two parts by delimiter, which is a dash ("-"): "sample part 1-sample part 2" The problem is that sometimes the text contains a dash (and should be split into two new fields, Say "Output 1" and "Output 2"), sometimes not which means that there is no Output 2 and that field should be…
My current Python Code : (\<Shares|\<Shares\:|[^\-]Share\:|\<Underlying Share\:|\<Exchange|\<Exchange\:)\s\s\s\s+([[:alpha:]|\s|\-]+)\s I'm looking to extract the following : 1. Share Name [Share / Shares / Shares: ] 2. Ticker Code [ REUTERS : / Bloomberg Ticker: / Bloomberg Code: / Reuters Code: / RIC: / Bloomberg: ] 3.…
Hello - thanks for the help in advance. I have cells that follow this format: qual RES1 'Restaurant' = 'Five Guys/Burger {US}' qual GY1 'Gym' = 'Planet Fitness' qual LOC1 'Location' = 'New York/{Bronx, Brooklyn}' concept 'Example 1' where 'School' = 'Syracuse University' and RES1 and 'Meal Type' = 'Dinner' concept 'Example…
It looks like you're new here. Sign in or register to get started.
