Checking if it's possible to use Mathematical Functions for data selected as text from webpage

Questions and Help
1

I am still new to Text Blaze and trying to figure it all out.

I am using the {site} command with text data type. I am just choosing data from a Snowflake database for reports I have to write up.

I have to choose how the different ways someone funded an account
So an example would be 15 inbound bill payments and 10 inbound electronic money transfers. In an ideal world what I would like to do is have a command where I can add those numbers together and have it state something like:
"There was total inbound transfers" and for the above example it would print
"There was 25 total inbound transfers".

Is that possible? I suspect not as the data as read as text. I have not looked at Data Blaze yet so not sure if that could help.

Any suggestions would be appreciated. Thanks

2

Hi @Robert_Cooke
Sure, that's possible.
You want to name the selectors and then use them in a formula.
Something like this:
{bill_payments={site: ....}}
{electronic_money_transfer={site:...}}
There were {=bill+payments + electronic_money_transfer} total inbound transfers

Please let me know if you have any questions.

Thanks,
Dan

1 Like
3

Hi Dan,

Thanks for the response. I have made progress but still facing issues. The main part is I can't seem to name or rename the selectors without breaking it. When I copy the data from the page the selector has this big name #appCellanchor... and on it goes. I can do a manual edit and rename it but when I do that it doesn't pick out the data at all so as far as I can tell it has to exactly match the given name to extract the data.

I did make progress with the formula and the full selector name but now I have the issue where because there is a dollar sign when you copy I get an error cannot convert "$16,330.47" to a number etc. I can use the "Replace" formula to get rid of the dollar sign but I still can't use the output of that in a formula.

I feel like if there was a way to name the selector without affecting the extraction of the information I could do it but it doesn't seem possible to me.

Any other ideas let me know. I still feel I learned a bit about formulas after playing around because of your suggestion so I still regard as a win.

4

Hi @Robert_Cooke
(1) We can help you create a great selector. Please email us at support @ blaze.today and we'll schedule a quick call
(2) You need to remove the thousand separator as well. You can do it with another replace or use regex:

{text="$16,330.47"}
{number=replace(replace(text,"$",""),",","")}
{=number}
{=number * 10}

1 Like
5

Could you please explain the syntax of the Replace function in that snippet