Hi Community,
I've got a bit of a problem with project of mine.
I'm retrieving the data from my client invoices in Flexicapture. One of the rows in the table contains some data that I don't need to extract.
What I want to do is: to get ride of the "info I don't need" part. Either by removing the row, since it's on different row than the others information I need or by keeping only the 1st line of every cell in the "number/info" column.
Any ideas?
-Dany
I've got a bit of a problem with project of mine.
I'm retrieving the data from my client invoices in Flexicapture. One of the rows in the table contains some data that I don't need to extract.
| Qty | Number/info | Description | Cost |
| 1 | Info I don't need |
Some information Some information | 10,00 |
| 2 | Info I don't need |
Some information Some information Some Information | 20,00 |
| 3 | Info I don't need | Some Information | 30,00 |
What I want to do is: to get ride of the "info I don't need" part. Either by removing the row, since it's on different row than the others information I need or by keeping only the 1st line of every cell in the "number/info" column.
Any ideas?
-Dany
Comments
1 comment
Hi Dany,
As far as I can see the information you wanted is in the same table row as useful info. So please consider parsing string (which is a table cell value) since it is NOT considered a different table row in a table you presented.
Hope that helps,
Vladislav
Please sign in to leave a comment.