How to retrieve data


#1

how to extract the data present in the following text.
Input Text : " Service Spare Parts
10 6549790 5 Joint medium 9,65 48,25
Country of origin: DE
delivery date: 20.04.2018 ex works
20 6627490 4 Front Handle for 27050 E 22,79 91,16
Country of origin: DE
delivery date: 20.04.2018 ex works
30 6222290 5 Roller, threaded 0,64 3,20
Country of origin: DE
delivery date: 18.04.2018 ex works
40 30160XA 2 Silicone Leaflet Washer, diameter 13,20 26,40
3 - 5.5 mm, type dome valve, package of
10
Country of origin: DE
delivery date: 18.04.2018 ex works
50 30160XB 2 Seal, package of 10 10,02 20,04
Country of origin: NL
delivery date: 18.04.2018 ex works
Goods value: 189,05
Net value of goods: 189,05
Transport insurance: 0,38
299 carried forward 189,43"

here if input string is: “10 6549790 5 Joint medium 9,65 48,25
Country of origin: DE”
Output required :Variable 1:10
variable 2:6549790
variable 3: 5
Variable 4:Joint medium
Variable 5:9,65
Variable 6:48,25
where length and strings value may vary as shown in text. also the string with different format as here “Service Spare Parts” are to be removed. how to extract these text while having these constraint of length and values. if regex function to be used then how to extract data.


#2

Probably a for each will work., the question is what data you need¿?

For example:

this is the content in the right side of your for each activity: yourString.Split({environment.NewLine},StringSplitOptions.None).tolist

then inside the forech you can do some work with an if activity getting only data from lines with substrings .

Which info you need?


#3

Hi,

Please find workflow attached check if it works for you.String.zip (2.2 KB)
Thanks


#4

yeah thanks it helped… But while I run that code I used to get “5” as output of first variable when I have " Service Spare Parts
10 6549790 5 Joint medium 9,65 48,25
Country of origin: DE
delivery date: 20.04.2018 ex works" this string as input…Output starts with 5, then 10 then 6549790 upto 48,25". Why is it so?


#5

5 is the count of matches, Just Remove message box having matchCollection count. Sorry i forgot to remove that count message box.