PDF to Text Subdivided Data Issue

I am trying to convert the information from a pdf to an excel spreadsheet using the PDF to Text tool. I'm running into issues though because some of the data in two of the columns is being subdivided into new lines as seen highlighted below for record IDs 45 & 46. I've also attached my working DM and the invoice in case anyone is able to help. Thank you!

UATP Template.yxmd

11 - 2024 SW UATP 1.pdf

Workflow

Datasets

Developer Tools

Reporting

Tips and Tricks

Help

Text Mining

Accepted answers

Wesley Mendonca

Hi! I would first check if there's any configuration that could logically link these records.

If that doesn’t work, another approach would be to use the Multi-Row Formula Tool, targeting Column 3 as the key to merge fields from Column 4 and Column 5. You could use a formula like this:

IF ISNULL([Row+1:Column3]) OR [Row+1:Column3] = "" THEN
    [Column4] + "\" + [Row+1:Column4]
ELSE
    [Column4]
ENDIF

I developed an example of this project.

Let me know if that can help you! ; )

sample_pdf.yxmd

All comments

Wesley Mendonca

Hi! I would first check if there's any configuration that could logically link these records.

If that doesn’t work, another approach would be to use the Multi-Row Formula Tool, targeting Column 3 as the key to merge fields from Column 4 and Column 5. You could use a formula like this:

IF ISNULL([Row+1:Column3]) OR [Row+1:Column3] = "" THEN
[Column4] + "\" + [Row+1:Column4]
ELSE
[Column4]
ENDIF

After applying this formula, you can use the Filter Tool to remove any null or empty records based on Column 3.

Wesley Mendonca

Hi! I would first check if there's any configuration that could logically link these records.

If that doesn’t work, another approach would be to use the Multi-Row Formula Tool, targeting Column 3 as the key to merge fields from Column 4 and Column 5. You could use a formula like this:

IF ISNULL([Row+1:Column3]) OR [Row+1:Column3] = "" THEN
    [Column4] + "\" + [Row+1:Column4]
ELSE
    [Column4]
ENDIF

I developed an example of this project.

Let me know if that can help you! ; )

sample_pdf.yxmd

mallieteal21

Thank you so much!

Wesley Mendonca

you´re welcome I am happy that worked!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703