Calculating the average/median from raw data

Hi

Currently i have data being output like this when grabbed from a piece of text

“message”: “$8001-$12000”,

the output of this into a form is: $8001-$12000"

How do i separate the two values and gets its median which would be 10,000, if the values were separated i could use an array or calculation to just add the two and then divide by 2 but i can’t figure out the initial step.

Split the string by the hyphen, giving you an array of {$8000;$12000}. Get rid of the $-sign in each entry and do as you mention.

I tried using the below
assign
DollarAmt=Split(DollarAmt."-")

It didn’t work, DollarAmt being the variable that the 8001 value is stored in…

Hi,

Hope the following helps you.

Sample20200528-2.zip (15.6 KB)

Regards,

1 Like

Thank you! This helped

1 Like

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