Get a specific value after using extract pdf text

[BHUSHAN_NAGAONKAR1 (Bhushan)]

I have assigned a value to an integer. I want to find that value.
I have a extracted the whole pdf using Extract pdf text. I want to search for a value. It is an amount basically.

It should extract and remove any unwanted annotations in between.
For eg
Int = 14567

Extracted Pdf value me contain this value but with ,/. ,
For eg 14,567.00
it should eliminate those punctuation marks and get the final value

Thankyou

[lrtetala (Lakshman Reddy)]

Hi @BHUSHAN_NAGAONKAR1

YouVar.Replace(",","").Replace("/","").Replace(".","").Replace(",","")

[Parvathy (PS Parvathy)]

Hi @BHUSHAN_NAGAONKAR1

Input = "14,567.00"
Output = Input.Replace(",","").Replace("/","").TrimEnd("0"c).TrimEnd("."c)

Check the below image for better understanding @BHUSHAN_NAGAONKAR1 :

Hope it helps!!

[lrtetala (Lakshman Reddy)]

@lrtetala

YouVar.Replace(“,”,“”).Replace(“/”,“”).Replace(“.”,“”).Replace(“,”,“”)

@BHUSHAN_NAGAONKAR1

[BHUSHAN_NAGAONKAR1 (Bhushan)]

What does c indicate?

[BHUSHAN_NAGAONKAR1 (Bhushan)]

And can I use “.00” so that it does not remove any other from the amount.

Such 14305.00

[Parvathy (PS Parvathy)]

Hi @BHUSHAN_NAGAONKAR1

The "c" after the period indicates that it’s a character literal in VB.Net.

Regards

[Parvathy (PS Parvathy)]

Hi @BHUSHAN_NAGAONKAR1

Input = "14305.00"
Output = Input.Replace(",","").Replace("/","").TrimEnd("0"c).TrimEnd("."c)

Regards

[BHUSHAN_NAGAONKAR1 (Bhushan)]

Thanks @lrtetala @Parvathy for your time and help

[Parvathy (PS Parvathy)]

You’re welcome @BHUSHAN_NAGAONKAR1

Happy Automation!!