How to find the specific values from a dynamic string

Help Studio
, ,
1
  1. please set up p2p in axiom for the following:

1933-1111=11.70kms
1111-1088=9.40kms
1088-1634=5.70kms
1634-1933=9.80kms

  1. 1933 830022 105.90
    830022 - 1294 = 32.20

  2. please set up p2p in axiom for the following:

1933-1131=101.40kms
1131-9043=40.20kms
9043-1933=116.00kms

1933-1800=108.90kms
1800-9043=52.90kms
9043-1933=116.00kms

1933-1122=83.80kms
1122-9043=27.10kms
9043-1933=116.00kms

1933 - 1122 = 83.80 km
1122 - 9043 = 27.10 km
9043 - 1933 = 116.00 km
thanks

Above is the sample of string, I am getting in my flowchart. First set of digits is source then destination and next one is distance difference. I want the digits from the string. I used regex to get the digits but getting all digits in single line.
I want digits data in the same format as above.

Also, strings will not come in same format always as shown in above sample.

Please help . Any leads would be appreciated.

Thanks,
Alamgir

2

@Alamgir - You mean like this…??

image
image526×795 27.4 KB

3

Hi @prasath17 ,

Thanks for the quick response.
How will be output after this regex pattern ?

Also, “-” and “=” is not fixed. Sometime space will be there to separate.

4

Do you have some samples? That will help to build a solid pattern…

5

Above data are the 4 samples of string.

6

My bad…I didn’t pay attention to the one with spaces…Could you please check this??

image
image698×846 33 KB

If all looks good…I will show you how to write it next…

7

It seems like correct output. But, the flow will be in loop. Above 4 samples come at 4 different times.
Can we test it like that?

8

@Alamgir - Yes…it works…

image
image983×779 39 KB

  1. Matches activity → Pass your input string and Pattern…and Save the result…

image

  1. For Each Loop

image
image1325×553 17.6 KB

Try like this…Hope this helps…

9

Okay, Thank you.

@prasath17 , the input we are passing first one contains the text in first line, for others may it wont. Can it works?

10

Please give it a try first…and then let us know what works and what not? we will take it from there…

11

Ok Sure.

Please share the xaml file if possible.

12

It’s just only two activities…so try based on the screenshot provided…was it not clear??

13

Hi @prasath17 .

I have tested it with this regex expression. Its working fine but no getting the value after decimal point. Am I missing something in expressions?

image
image1272×603 43.2 KB

14

@Alamgir - you missed the + symbol at the end…it should be [\d\.]+

Please check the my initial screenshot provided in the regextester. Even thought in the workflow screenshot its not visible, it is showing clearly initially.

15

Ok @prasath17

My bad, Thank you!

16

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