How do I remove an empty row in HTML text - HTML file to JSON

Like (0) Share

Report

Posted on 17 Nov 2023 07:49:56 by SuperUser-

Hi all & thanks for the support!

I'm in the process of creating a flow which takes a HTML email attachment and converts it to JSON. It captures the attachment via email > converts the contentBytes to a string > Replaces the column delimiter with '^' and row delimiter with '|' > Converts it to text > splits the text by each row > filters out rows containing 0 characters > splits and maps data to it's respect column.

After using the select data operation in the last step and mapping column names to data from the filtered HTML text output, I get this error:

After combing through the HTML text output, I found that there is a row with no data however only has a column delimiter which I believe is causing this error.

Is this the correct assumption and how can I remove this to not have this error?

I have the same question (0)

Summarized by AI

AI generated content may be incorrect

Did you find this summary helpful?

All responses (3)

Answers (1)

Chriddle 8,087 Super User 2025 Season 2 on 17 Nov 2023 at 08:29:09

Like (1)

Report

Re: How do I remove an empty row in HTML text - HTML file to JSON

split(item(), '^')[a_number] fails whenever a row does not contain sufficient amount of '^' (a_number-1).

You can check this with the length(split(item(), '^')) before accessing it.

But parsing HTML is harder than you might imagine, and often impossible when only using PA expressions ‌.
Can you show an example of the HTML table source?

Was this reply helpful? Yes No
SuperUser- 6 on 17 Nov 2023 at 08:27:13

Like (0)

Report

Re: How do I remove an empty row in HTML text - HTML file to JSON

Thanks @v-bofeng-msft I had it set to 0 - didn't even think to change it. Setting a higher value works well, cheers.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on 17 Nov 2023 at 08:22:37

Like (0)

Report

Re: How do I remove an empty row in HTML text - HTML file to JSON

Hi @SuperUser- ,

You can determine the length of the string and skip it if it is less than a certain range, for example:

length(item())

Best Regards,

Bof

Was this reply helpful? Yes No