Getting unnecessary characters while extracting invoice PDF to Excel

Help Activities
, ,
1

Hello all,

I am trying to extract invoice from my email and reading it to Excel. Along with that I am adding an extra column named Invoice link(Folder path where the invoice is located). After reading the data there is some unwanted character coming up in the excel. I have attached an image for reference

image
image861×236 7.87 KB

2

What’s the unwanted character you are seeing in excel? Im seeing a new row with “C” is that what you want deleted?

Many ways to do this, and if you see the letter C consistently in all extractions you can delete the row containing C before you export it into excel.

3

Please find this video. Instead of removing null rows here you can remove row containing “C”

4

Yes, the unwanted character here is ‘C’.
But what if there is an invoice which starts with C?

5

I do see C constantly

6

You can simply remove rows where you see a unique “C” entry. This only deletes rows in the table post extraction, so you won’t have an invoice name issue.

7

Okay will try

1 Like