I need help to get the final regex code to match each item
Pos. Item Code Item name Qty Price each VAT Disc. Invoice Price Total Price 1 CLMT39411 Marvel 80th Anniversary Impossible Puzzle 1 7,90 € 1 2,00 % 7,74 € 7,74 € Characters Unit price = Base price 7,70 € + 2,54 % (0,20 €) freight surcharge Country of origin: IT HS-Code: 950300 2 DAHO3008-743 The Witcher PVC Statue Geralt of Rivia 22 cm 6 29,27 € 1 8,00 % 26,93 € 161,57 € Country of origin: CN HS-Code: 392640 3 FK54678 Seinfeld POP! TV Vinyl Figure Elaine in 1 3,76 € 113,00 % 3,27 € 3,27 € Sombrero 9 cm Country of origin: VN HS-Code: 950300 4 FLTO20191204SG Transformers Furai Model Plastic Model Kit 1 32,70 € 1 2,00 % 32,05 € 32,05 € Shattered Glass Drift 16 cm Country of origin: CN HS-Code: 950300 5 HASF0374 Marvel Legends Series Action Figure 2022 1 16,88 € 1 0,00 % 16,88 € 16,88 € D'Spayre 15 cm Country of origin: CN HS-Code: 950300 6 HOT904929 Avengers: Endgame Movie Masterpiece 1 237,37 € 1 0,00 % 237,37 € 237,37 Action Figure 1/6 Captain America (2012 Version) 30 cm Unit price = Base price 231,49 € + 2,54 % (5,88 €) freight surcharge Country of origin: CN HS-Code: 950300 7 HOT908810 Spider-Man Videogame Masterpiece Action 1 262,92 € 1 0,00 % 262,92 € 262,92 € Figure 1/6 Cyborg Spider-Man Suit 2021 Toy Fair Exclusive Unit price = Base price 256,41 € + 2,54 % (6,51 €) freight surcharge Country of origin: CN HS-Code: 950300 8 MAFC04310 Fate/Stay Night Heaven's Feel Pop Up Parade 1 27,17 € 1 2,00 % 26,63 € 26,63 € PVC Statue Saber Alter 17 cm Country of origin: CN HS-Code: 392640 9 MCF15103 Justice League Movie Action Figure Speed 1 10,61 € 1 2,00 % 10,40 € 10,40 € Force Flash 18 cm Country of origin: CN HS-Code: 950300 10 SMK005 Marvel Comics Metal Keychain Thor Hammer 1 5,24 € 1 2,00 % 5,14 € 5,14 € Country of origin: CN HS-Code: 732690 11 SS100326 Star Wars Mythos Action Figure 1/6 Boba Fett 1 244,54 € 1 0,00 % 244,54 € 244,54 € 30 cm Unit price = Base price 238,48 € + 2,54 % (6,06 €) freight surcharge Country of origin: CN HS-Code: 950300 12 SS300789 Star Wars The Mandalorian Premium Format 1 507,75 € 1 0,00 % 507,75 € 507,75 € Figure Cara Dune 48 cm Unit price = Base price 495,17 € + 2,54 % (12,58 €) freight surcharge Country of origin: CN HS-Code: 392640 13 TLSBANARITAWB01 Naruto BST AXN Action Figure Itachi Uchiha 10 10,59 € 1 2,00 % 10,38 € 103,78 € 13 cm Country of origin: CN HS-Code: 950300 Subtotal page 1 1.588,82 € Continuation on page 2 heo GmbH, West Campus 1, 76863 Herxheim, Germany | Phone: +49 7276 92928-123 | Fax: +49 7276 92928-11 | E-Mail: info@heo.com | Internet: www.heo.com Registered office: Herxheim/Pfalz, Germany | Court of jurisdiction: Landau in der Pfalz, Germany | Commercial registerLandau HRB 3154 | VAT ID: DE813027049 Board of Directors: Ulrich Dudenhöffer, Christoph Reichelt | Europe-wide distribution network with additional heo branches in France and Spain Details of bank account: Bank: Deutsche Bank AG Heidelberg | Beneficiary: heo GmbH, Deutschland | IBAN: DE48 6727 0003 0066 8061 00 | BIC: DEUTDESM672Amount brought forward, page 1 1.588,82 €
14 WLS1356 Kill Bill Replica 1:1 Hattori Hanzo Sword 1 113,72 € 1 2,00 % 111,44 € 111,44 € Unit price = Base price 110,90 € + 2,54 % (2,82 €) freight surcharge Country of origin: CN HS-Code: 930700 Shipping costs 0,00 € Subtotal Including freight surcharge Discount 0,00 % Total 1.731,48 € 34,84 € 0,00 € 1.731,48 € plus VAT 0% based on 1.731,48 € 0,00 € Total 1.731,48 € Due date 08.06.2022 Reverse-Charge-Procedure / Steuerschuldnerschaft des Leistungsempfängers / steuerfreie innergemeinschaftliche Lieferung Tax free intracommunity delivery, VAT Reg.No. RO30984897 Our general terms and conditions in their current version at the order date apply to any kind of business relation. The current versioncan be found online at the following address:
heo GmbH, West Campus 1, 76863 Herxheim, Germany | Phone: +49 7276 92928-123 | Fax: +49 7276 92928-11 | E-Mail: info@heo.com | Internet:www.heo.com Registered office: Herxheim/Pfalz, Germany | Court of jurisdiction: Landau in der Pfalz, Germany | Commercial register: Landau HRB 3154 | VAT ID: DE813027049 Board of Directors: Ulrich Dudenhöffer, Christoph Reichelt | Europe-wide distribution network with additional heo branches in France and Spain Details of bank account: Bank: Deutsche Bank AG Heidelberg | Beneficiary: heo GmbH, Deutschland | IBAN: DE48 6727 0003 0066 8061 00 | BIC: DEUTDESM672
I found the following code but it doesn't match everything. I need to to match everything on each new line until Unite price or Country of origin.
the code is:
(\d+)\s(.*)\s(\d+)\s(\d+,?\d+)\s€\s?(\d+)?\s(\d+,?\d+)\s%\s(\d+,?\d+)\s€\s(\d+,?\d+)\s€\r\n(.*)
Any ideas? Thanks