Get text with formula

Help
, ,
1

Hi everyone,

I’m trying to copy an amount online.

what i need to do is put a formula and paste it in a word file. is this doable?

pls help.

Thanks!

2

It is possible.
Just install word package in order to work with msword application.

1 Like
3

Hi Rahatadi.

Already installed word package.
May I ask how and where will I put the formula in my get text properties?

Thanks.

4

can you give an example of the data that you are trying to use along with the formula?

5

Hi VirajN,

i need to get the value in the box.
its auto generated.

image
image969×158 30.2 KB

and paste it here.

image
image967×304 41.3 KB

the challenge is that i need to get the 12% of this value and paste in the next box sa tax, and in the next box the sum of the value and tax.

6

Use Read Text Activity In Word Application Scope.
Get the field value you’re looking for.
Store it in a variable, Output
Output=cint(Output)
Tax=Output x 12/100
Sum=Output+Tax

7

what i can think of is:
create an excel.
first column will be value,
2nd column will be gst 12% or just 1.12 for multiplication purpose
3rd column will have multiplication of 1st and 2nd column
copy the value of 3rd column to where you want

maybe this can help you a little better.

8

if me, i will use Click Image activity on “Final Bill Fee” text → then click indicate to the disabled input bar that written 600,000.00 → after that use Get OCR Text activity and indicate it to the same disabled input bar as well. (the output of Get OCR Text activity is a string).

then the output string you convert it to integer and use your formula to get the 12% of the value → then convert it back to string.

finally, use the output string on your word activity.

1 Like
9

Thanks wija,

really helpful :slightly_smiling_face:

1 Like
10

No problem :wink:

11

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