Data rectification-Excel--(URGENT)

Hi @kumar.varun2 @GreenTea
In a excel file below i’m not able to fetch right value.
i’m just trying to fetch value from invoice & incorporate into excel.
hence i observed that while fetching the value from invoice, instead of taking “consumption” it is taking y36.

Just sending u the details for reference.
image

Here’s the code for reference:-

@kumar.varun2 @GreenTea @nameless PLEASE HELP…!!

@mitul_choudhary

Check below for your reference

Hope this may help you

Thanks

share the invoice pdf or pdf text

As u can see in excel in 3rd row this value is not coming as per invoice value.
image

whereas in invoice 3rd row is having the value :

@kumar.varun2 @Srini84 @GreenTea PLEASE HELP IN THIS CASE…!!!

@mitul_choudhary

You can add or condition to your regex expression as below

“Y36|CONS” and other keywords

This will search your keywords and replace according to that

Hope this may help you

Thanks

this case is sorted that’s a another case…!!!

@mitul_choudhary

Okay, In this case I suggest to open a new thread and share the details

Please don’t merge the issues in one thread

Thanks

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.