Regex collection to datatable

[Sachin_P]

str

"

1
5551
85%

2
258
100%

3
896
59%

4
213
10%

"

Op
ranking,route,percentage
1,555,85
2,258,100

and so on

Help me out

[vrdabberu (Varunraj Dabberu)]

Hi @Sachin_P

Please try the below workflow:

Input = "1
5551
85%

2
258
100%

3
896
59%

4
213
10%"
matches activity regex : "\d+[\s\S]*?\d+\%"

Assign activity:

Ranking= System.Text.RegularExpressions.Regex.Match(currentItem.ToString,"\d+(?=\s+\d+\s+\d+\%)").Value.Trim()

Route= System.Text.RegularExpressions.Regex.Match(currentItem.ToString,"(?<=\d+\s+)\d+(?=\s+\d+\%)").Value.Trim()

Percentage= System.Text.RegularExpressions.Regex.Match(currentItem.ToString,"(?<=\d+\s+\d+\s+)\d+(?=\%)").Value.Trim()

Workflow:

xaml:
Sequence26.xaml (13.6 KB)

Build Data Table:

Output:

Regards