community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Text Trapping

Highlighted
Meteor

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. 

Comet

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.

 

I'd suggest reading through the tool mastery article which covers what you can do with regex and using a online tool like https://regex101.com/ to check you've got the right syntax.

 

 

Nebula
Nebula

Hi @mompermj 

 

Can you provide some sample inputs that have been sanitized to remove company identifiers? 

 

 

Dan 

Labels