Regex extractor between lines

Hi All I have a string below
I have to extract the details from string below as follows

10 834190906HEATING CARTRIDGE INCL MICA INSULATING
Information purpose: please see below components 6 SET
Order no.: 50093634/10
Confirmed Delivery date 03.05.2023

10-20 834190904 HEATING CARTRIDGE AIR HEATER
6 PC 47,76/1 286,56
Price (Gross) 1 PC 47,76
Order no.: 50093634
content of 834190906
Confirmed Delivery date 03.05.2023

10-30 834190905 INSULATING SLEEVE HEATING CARTRIDGE
6 PC 21,21/1 127,26
Price (Gross) 1 PC 21,21
Order no.: 50093634
content of 834190906
Confirmed Delivery date 03.05.2023

40 829404076 MAINTENANCE PACKAGE PNEUMATIK
1 PC 301,96/1 301,96
Price (Gross) 1 PC 301,96
Order no.: 50093634/20
Confirmed Delivery date 23.01.2023

SIG Combibloc Postfach 11 41 Tel: (02462) 79-0 Registergericht
Systems GmbH D-52438 Linnich Fax: (02462) 79-2519 Düren HRB 3935
Steuer-Nr: 20002/93010
www.sig.biz USt-Ident: DE812365118

Geschäftsführung: HSBC Trinkaus & Burkhardt AG
Franz-Josef Mines (BLZ 300 308 80) 1 0854 008
Dr. Gregor Pawlitzki BIC: TUBDDEDD
IBAN: DE18 3003 0880 0010 8540 08
ZA95/EN /GL3SIG Combibloc

ORDER CONFIRMATION Number: 61990960 Date: 17.01.2023 Page 2

Article no. Description Quantity Unit Unit Price Total in EUR

50 839920002 FILTER NORDSON PROBLUE
5 PC 93,74/1 468,70
Price (Gross) 1 PC 93,74
Order no.: 50093634/30
Confirmed Delivery date 23.01.2023

60 860190421 PROXIMITY SWITCH QUADER+K-STECK 1.5M
6 PC 22,43/1 134,58
Price (Gross) 1 PC 22,43
Order no.: 50093634/40
Confirmed Delivery date 23.01.2023

70 829341313 BEARING BUSH
20 PC 4,36/1 87,20
Price (Gross) 1 PC 4,36
Order no.: 50093634/50
Confirmed Delivery date 23.01.2023

80 829285677 APPLICATTION HEAD HEISSLEIM
2 PC 1.320,88/1 2.641,76
Price (Gross) 1 PC 1.320,88
Order no.: 50093634/60
Confirmed Delivery date 23.01.2023

90 860604041 SUCTION UNIT CB6 FA. ACLA
25 PC 4,98/1 124,50
Price (Gross) 1 PC 4,98
Order no.: 50093634/70
Confirmed Delivery date 23.01.2023

100 839990906 INFRARED RADIATOR 2.3KW-115V
1 PC 332,59/1 332,59
Price (Gross) 1 PC 332,59
Order no.: 50093634/90
Confirmed Delivery date 23.01.2023

110 829251109 ROTARY PULSE EMITTER
1 PC 420,47/1 420,47
Price (Gross) 1 PC 420,47
Order no.: 50093634/100
Confirmed Delivery date 23.01.2023

120 829291070 proximity 5371288
1 PC 89,80/1 89,80
Price (Gross) 1 PC 89,80
Order no.: 50093634/110
Confirmed Delivery date 23.01.2023

130 820108619 ROLLER LAT BOTTOM FOLDER
6 PC 4,20/1 25,20
Price (Gross) 1 PC 4,20
Order no.: 50093634/120
Confirmed Delivery date 23.01.2023

140 888487019 ANGLED CONNECTION C8X1/4
12 PC 2,07/1 24,84
Price (Gross) 1 PC 2,07
Order no.: 50093634/130
Confirmed Delivery date 23.01.2023"

I want to extract the details after every new line with space

Thank you

HI @Naga_Abhishek_Reddy_Chepp

Checkout this Expression

System.Text.RegularExpressions.Regex.Matches(YourString,"(?s)^\b\d.(.*?)\d{2}.\d{2}.\d{4}")

Will get you all the matches and you can loop through each matches with for each activity

Regards
Sudharsan

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