Get a specific value after using extract pdf text

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

Hi @BHUSHAN_NAGAONKAR1

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

1 Like

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!!

1 Like

@BHUSHAN_NAGAONKAR1

1 Like

What does c indicate?

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

Such 14305.00

Hi @BHUSHAN_NAGAONKAR1

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

Regards

1 Like

Hi @BHUSHAN_NAGAONKAR1

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

Regards

Thanks @lrtetala @Parvathy for your time and help

1 Like

You’re welcome @BHUSHAN_NAGAONKAR1

Happy Automation!!

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