For example, I need to extract the $ NAME: sandy until $$.TO and then join with the contents inside $NAME: patrick which is start from G1 until $$SRU.
Your sample data seems to indicate that the data for each name starts with "$ NAME" and ends with a line ".EON", which is the base of our suggestions until now. The quoted sentence seems to indicate something different. So you should clarify:
- how do you recognize which line belongs to which name (via $ NAME and .EON, or different)?
- how do you determine which part of those lines for a particular name you are interested in?
- [Update: additional question] do you need to preserve the order of these entries/lines?