Text parser. Need help to find out a more elegant formula

[Jorge.c]

Hi,

I am considering to build a spreadsheet to parse text fields... but I am worried of not being capable of finish it.

In this link you will see the first simple step:

https://docs.google.com/spreadsheets/d/176dM4i20nDmyKrjzIUuyKlrOCMjC0oQi0BArYX7NYg8/edit?usp=sharing


Please, could you tell me if there is a formula to compare lists of words... or will I have to learn to program vba macros?

Thank you,

 

[Deepak]

You are looking a solution for Google sheet or excel?
You are looking to just extract the first block of text from the long text.

 

[Jorge.c]

Thank you,

The sample is a google sheet (easier to share), but the formula should be similar in both programs.

The text could be at any position. Not necesarily the first block.

 

[Peter Bartholomew]

If you are going to get serious about parsing text you will probably need to use regular expressions from the scripting library. If you search for 'RegEx' you should find a file I posted with some borrowed UDFs (user defined functions) that accepts RegEx patterns and return matches.

There are a lot of other discussions that will be returned and maybe some of those would help.

 

[bosco_yip]

Thank you,

The sample is a google sheet (easier to share), but the formula should be similar in both programs.

The text could be at any position. Not necesarily the first block.

1] Since you asked question and attached with a Google Sheet, it is against the forum's rule by :
"….The forum based on the type of question/area of Excel you are interested in…."

2] We don't discussion questions other than Excel.

3] Post closed

Regards
Bosco