How to extract effective data

Help Studio
, ,
1

Hi all,

I used some processing to get a set of strings, as shown below:

  1           3.7 KGS        3.097 KGS     0.056

I want get the value 3.7 and 3.097 and 0.056, so how to do it, please help, thank you.

2

Hey!

Try this:

System.Text.RegularExpressions.RegEx.Match(StrInputVariable,"\d{1,}.\d{1,9}").ToString

Reference:

Regards,
NaNi

3

assuming txt = your string

System.text.regularexpressions.regex.match(txt, "([\d\.]+)\sKGS[\s]+([\d\.]+)\sKGS[\s]+([\d\.]+)").Groups(1).value

will give 3.7

System.text.regularexpressions.regex.match(txt, "([\d\.]+)\sKGS[\s]+([\d\.]+)\sKGS[\s]+([\d\.]+)").Groups(2).value

will give 3.097

System.text.regularexpressions.regex.match(txt, "([\d\.]+)\sKGS[\s]+([\d\.]+)\sKGS[\s]+([\d\.]+)").Groups(3).value

will give 0.056

@Chen-Jim

4

Hello Jack,
Thanks for your reply! Your answer is very helpful to me.
And I have another strings want to extract, please help.

 44       3,856.0 KGS    2,741.814 KGS    84.552
1 Like
5

Hey!

Try the above expression even if the changes in data the mentioned expression will work…

Regards,
NaNi

7

Hi,
It was return one value…

8

Hi,

The following sample might help you.

image
image979×723 27.6 KB

Sample20220726-6.zip (2.5 KB)

Regards,

9

Hey!

How about the following?

System.Text.RegularExpressions.RegEx.Match(StrInputVariable,"[0-9].[0-9].\d+.[0-9]+|[0-9].[0-9]+").ToString

Refrence:

StudioReference:

KGSRegEx
KGSRegEx1255×657 29.6 KB

Output:

KGSOutput

Regards,
NaNi

10

@Chen-Jim

just update the regex to this (for all items)

([\d\,\.]+)\sKGS[\s]+([\,\d\.]+)\sKGS[\s]+([\,\d\.]+)