Confused in String

Help Activities
, ,
1

I have text file i want to extract only output value in my excel.Example:
Model=HM312 Engine=HM1231000001 - HM141999999
output value dynamic not fix.How to solve.

2

TEXT.txt (196 Bytes)

3

assign
model= System.Text.RegularExpressions.Regex.Match(txt, "Model[\s]+([\dA-Z]+)-").Groups(1).Value

and assign
engine = System.Text.RegularExpressions.Regex.Match(txt, "Engine[\s]+([\dA-Z]+ - [\dA-Z]+)").Groups(1).Value

image

refer to this
Sequence1.xaml (7.1 KB)

1 Like
4

Can you help me to string
Stroke =(2-stroke or 4-stroke)4 stroke
Power=2

5

stroke
(?s)Stroke (.*?)\-output

power
Power[\s]+([\d]+)

6

power,model,stroke not working fine in my system

7

whats the input file you are using?

8

i have string in webpage

9

Screenshot 2022-05-06 153726
Screenshot 2022-05-06 1537261132Ă—60 8.01 KB

10

can you copy that string and paste it here

11

again.txt (258 Bytes)

12

i see that power is still working

Model[\s]+([\da-zA-Z]+)

Engine[\s]+([\dA-Za-z]+ - [\dA-Za-z]+)

Stroke (.*?).output
13

what .output excatly means

14

its to match a string before “=output”

. means (any character)

15

Thanks for supporting me.Right now everything working fine.But one issue in stroke.Value comes blank.

16

System.Text.RegularExpressions.Regex.Match(textInformation, “Stroke(.*?).output”).Groups(1).Value

17

this

(?s)Stroke(.*?).output

18

not working stroke

1 Like
19

whats input?

20

Value Blank