topic Extracting digits before and after the comma in Discussions

Extracting digits before and after the comma

joshua — Fri, 09 Jun 2023 22:11:14 GMT

Hi,

I'm struggling from extracting digits from a string before and after the comma

how can I get 0.98 and 0.97 from a string?

string = "A_BD_CEEE:0.98,0.975620708";

first_number = Num( Regex( string, "(\d\d?\d?):", "\1" ) );

expected out

first_number = 0.98

second_number = 0.975

thanks

Re: Extracting digits before and after the comma

txnelson — Sat, 17 Apr 2021 01:13:21 GMT

Here is how I would do it

names default to here(1);
string = "A_BD_CEEE:0.98,0.975620708";

first number=num(word(2,string,":,"));
second number = round(num(word(3,string,":,")),3);

Re: Extracting digits before and after the comma

jthi — Sat, 17 Apr 2021 04:58:33 GMT

If the numbers cannot be negative this should work:

Names Default To Here(1);

string = "A_BD_CEEE:0.98,0.975620708";
numString = Regex Match(string, "(\d+.\d*),(\d+.\d*)");
first_number = Num(numString[2]);
second_number = Num(numString[3]);
Show(first_number, second_number);

Re: Extracting digits before and after the comma

Georg — Sat, 17 Apr 2021 11:24:36 GMT

In addition to the solution of @jthi ,

there is quite a good documentation on regex:

https://www.jmp.com/support/help/en/16.0/jmp/regular-expressions.shtml#

The problem of your initial approach was, that there is no number before :, only after.

And you need to include the . into the string to get the first number. See changes below.

Regex is worth to learn because it is really powerful.

string = "A_BD_CEEE:0.98,0.975620708";

first_number = Num( Regex( string, ":(\d.\d?\d?)", "\1" ) );