Regex for repeating line

Help Studio
, ,
1

Hi, can please someone help me to define Regex to read out following lines?
5digits space 11digits space 3digits 5space TextInDifferentLength

12000 30200524004 234 ABC…
12000 38406433003 345 BCD…
12000 39801890003 456 CDE…
12000 24398320000 567 DEF…

Thx and kind regards,
Vanja

2

Hi @VanjaV

use the matches activity with this regex

^\d{5}\s\d{11}\s\d{3}\s.+$

Happy Automation

2 Likes
4

You should use the Generate Data Table activity for this. Define it as delimited with space as the delimiter. Then you can get a datatable of this data.

1 Like
5

@VanjaV

is there any other text or somethign after this ? if so please show a sample of full data

if nothing then just split using environment.newline and it would give each line as a separate array element

cheers

1 Like
6

Hi @prashant1603765

Thank you very much. It worked like this : “^\d{5}\s\d{11}\s\d{3}\s{3}.+$”

1 Like