How to Extract Data from HTML Table: A Guide for Make.com Users

Have you ever found yourself stuck trying to extract data from an HTML table that's nested within an email? You're not alone. This is a common challenge that many Make.com users face. But don't worry, we've got a solution for you.

The Problem

Let's say you're trying to extract specific values from an HTML table that's nested within an email. The values you're interested in are "order number", "customer email", "customer name", "comments", and "star rating". You've tried using Regex and the text version, but that's not working. You've also tried using the text parser and deprecated "extract from html table" which retrieves the data with nested tables, rows, and columns, but it's hard for you to use. You're now trying to use the Iterator module but setting it up correctly is proving to be a challenge because it's a nested array.

The Solution

The solution to this problem is to utilize the “Text Parser: Match Pattern” with the following regular expression pattern:

Order Number\s*(\d+)[\s\S]+?Customer Email\s*([^\n]+)[\s\S]+?Customer Name\s*([^\n]+)[\s\S]+?Comments\s*([\s\S]+?)Star Rating\s*(\d+)

After applying the above pattern, the extracted information will include the Order Number, Customer Email, Customer Name, Comments, and Star Rating.

Troubleshooting Tips

If you're still having trouble after applying the above solution, make sure that you're entering the regular expression pattern correctly. A single typo can cause the pattern to not match correctly. Also, make sure that the HTML table in the email is formatted correctly. If the table is not formatted correctly, the regular expression pattern may not be able to match the desired values.

Conclusion

In conclusion, extracting data from an HTML table nested within an email can be a challenging task. However, by utilizing the “Text Parser: Match Pattern” with the correct regular expression pattern, you can easily extract the desired values. Remember, if you're still having trouble, don't hesitate to reach out for help. There's always a solution to every problem.

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.