I have a CSV file... The separating characters are the "#" symbol.
I am searching for between 1 and 3 words, no more.
Some of the separators have sentences in them, I want to ignore those.
I do NOT want to actually SELECT the # symbols.
I am using EDIT PLUS and a Macro Engine to do this, so i will be writing a simple Macro, I want to grab the 1-3 word entries that are between the # symbols, ignoring the actual # symbols themselves, and ignoring the sentences that are entries on their own.
The following are three examples of what I might find.
###Word#####
###1 Word#####
###Word Word Word#####
I feel like I am going insane, I am 90% new to regular expressions. I have used them before in macros in my edit plus, but now I have a serious project that I need to do this check on over 7,000 entries, and I have read the entire Internet on Reg Ex's and I am just dumbfounded. If you can help me I will be eternally grateful, if you can't? Meh... *shrugs* I'll figure something out. Thanks for anything...
Almost forgot. There are some entries that are just the plain letter X capitalized. I want to ignore those too. Those would look like:
#X##Word#####
#X##2 Word#####
#X##Word Word Word#####