If you are receiving the Input file as CSV, you can also query this directly with OLEDB. I don't recall the exact connection string, but something like this:
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & [in_CSVPath] & "; Extended Properties=""t...
Hmmm, I would do a regression test then. Try to get a sample of at least 50-100 PDFs (the bigger, the better, but also it will take you longer to verify the Replace logic you will need to implement) and then see what are the most common errors made b...
No bigge Amrutha, glad I could help ;)Can you, by any chance, save the PDF in any shape of text document (.txt, .doc)? That way you could parse it with a RegEx relatively easy without the need of resorting to OCR solutions.---------------------------...
If there is a logic behind the worksheet name, store the query in a text Data Item and the Worksheet name on another Data Item. Add some logic to set the name of the worksheet via a calculation stage. Add another calculation stage after that to amend...
For issue 1, I would advice you to use the Label "Smoking Status" as an anchor (image method) and the relative positions of the Yes and no checkboxes as relative coordinates based on that anchor. If all you need to find out is if the checkbox is edit...
