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?