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.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
In the past I used Datawatch Monarch to scrape text files looking for wildcards and text patterns (text and number traps)
I've been trying to search to see if there was any solution to finding character/number/special patterns to create fields in a text import.
In this case we are trying to scrape some raw invoices which may have hundreds of customers over multitudes of pages. The reports were written in mainframe and unfortunately had no delimiters (fixed or otherwise). I know from past experience i can use the other program but that means convincing someone to let me buy another expensive program ^_^;;;
If anyone has a solution for this issue i'd greatly appreciate some direction.
Hi, if I understand your question, you are wanting to extract invoice values across multiple pages? One method of doing this, is to use pattern matching with regex, so you can put something like "(\£\d+\.\d\d)" which will find all monetary amounts in the records.