Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

PDF To Text - Amounts in a Credit Column shifting

w_gore
8 - Asteroid

 

I am preparing a workflow using computer vision tools to read numerous purchase card statements from PDF files.  I have successfully read each file using PDF to Text.  My workflow results in a record for each transaction.  However, I have not determined how to flag/identify a transaction with a credit amount (as shown in screenshot).

 

PDF to Text configuration:

Text Extraction Options - Read Text Content Only checked with Risk Score and Output selection checked

Output Options - Alteryx Table

 

Looking for suggestion on how to isolate these credit values.  Thanks for the help.

 

WG

 

p.s. I should have mentioned the credit amount aligns with all other amounts (charge column).  There are no discerning spaces/breaks before a "credit" amount or "charge" amount.

 

10 REPLIES 10
alexnajm
18 - Pollux
18 - Pollux

Do you feel comfortable using RegEx? I'd probably use it to identify all the spaces and determine the difference based on how many spaces there are before the last value!

Labels
Top Solution Authors