In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more 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
19 - Altair
19 - Altair

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