Regex to extract string in-line

I want to extract string after Total for : . Thank you for any help and ideas.

Data

Total for : Jack - Distribution  2304.00
Sssd-  JJ Distribution
Total for : Milton - Distribution  35.96
Mobile - Distribution
Sales Osrder  dsfds 453452/11/2020 C61terter07175 bdfgdf Lugdfggdfgfdgber Cgf Inc  83.52dfgfd
Sales Orsdder  881430 2/18/2322021 C61e09206 Phipps Cabinets Inc  67.80
Total for : Mobile22 - Distribution  151.32
Raleigh - Distribution
Sales Order  872327515 2/16/2021 C2402329689 W232oodshapes  45823.44
Total for : Rayy - Distribution  458.44

sample output :
Jack - Distribution 2304.00
Milton - Distribution 35.96
Mobile22 - Distribution 151.32
Rayy - Distribution 458.44

@AhmedKutraphali

Check as below

Hope this helps you

Thanks

1 Like

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