Parse text

(0) Share

Report

Posted on by SN-07111935-0

Please help me extract Microsoft Inc. and Abc Ltd. from below text. The information could be in multiple lines in few scenarios.

This Eleventh Amendment to the Excel Services Agreement (this “Amendment”), is entered into as of July 1, 2024 (the “Amendment Effective Date”) by and between Microsoft Inc.(“Vendor”) and Abc Ltd. (“Customer”).

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

eetuRobo 4,558 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Note that your example texts "Microsoft Inc." has two spaces in between "Microsoft" and "Inc.".

Try Regex: \b[A-Z][a-zA-Z]*(?:\s+[A-Z][a-zA-Z]*)*\s+(?:Inc\.|Ltd\.)

That should work with one or multiple spaces in between "Company" and "Inc." or "Ltd."

Was this reply helpful? Yes No
SN-07111935-0 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for looking into this.

Is there a dynamic way to pull these details based on constants ("Vendor") and ("United")? The names does not always ends with Inc. or Ltd. but these values will be constant which comes after the actual name. Also the beginning of Vendor name will always have "by and between" whereas customer name will always have "and" in the beginning.

Was this reply helpful? Yes No
Suggested answer

eetuRobo 4,558 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Replace text -action could work with that.

First replace anything before "by and between" with empty string. Regex: ^(.*?)\s+by and between

Then replace everything after first "(" with empty string. Regex: \((.*)

Then replace everything before " and" with empty string. Regex: ^(.*?)\s+and

Then again everything after first "(" with empty string. Regex: \((.*)

Code to copy to your editor:
SET TextToParse TO $'''This Eleventh Amendment to the Excel Services Agreement (this “Amendment”), is entered into as of July 1, 2024 (the “Amendment Effective Date”) by and between Microsoft Inc.(“Vendor”) and Abc Ltd. (“Customer”).''' Text.Replace Text: TextToParse TextToFind: $'''^(.*?)\\s+by and between''' IsRegEx: True IgnoreCase: False ReplaceWith: $'''%''%''' ActivateEscapeSequences: False Result=> Replaced Text.Replace Text: Replaced TextToFind: $'''\\((.*)''' IsRegEx: True IgnoreCase: False ReplaceWith: $'''%''%''' ActivateEscapeSequences: False Result=> Vendor Text.Replace Text: Replaced TextToFind: $'''^(.*?)\\s+and''' IsRegEx: True IgnoreCase: False ReplaceWith: $'''%''%''' ActivateEscapeSequences: False Result=> Customer Text.Replace Text: Customer TextToFind: $'''\\((.*)''' IsRegEx: True IgnoreCase: False ReplaceWith: $'''%''%''' ActivateEscapeSequences: False Result=> Customer

test with different company names:

Was this reply helpful? Yes No