PDF to Text Subdivided Data Issue

[mallieteal21]

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!

[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 · Accepted solution]

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! ; )

[mallieteal21]

Thank you so much! 

[Wesley Mendonca]

you´re welcome ;) I am happy that worked!