This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The image shown above is the data set I am working with. I dropped in a PDF using the PDF input tool, and consequently the input tool included all of the data in one column. In the image above, the column includes the following information from a balance sheet:
Here is the workflow with your data file attached. As you can see, it works ok when there is data in the number columns. In situations like this where it becomes tricky to capture all the variances with a regex statement, I normally divide the data into different groups and build a different regex for each. You can add a record ID at the start and then use filter tools to break your data into different groups and recombine it at the end with a union tool.