How can I stop repeated words

elfstoneUK · January 9th, 2006, 08:44 AM

Ladies and Gentlemen,
Your help please.
I'm new to regular expressions. I have read about them and tested a few, so I'm convinced this is the way to go. :)

I have is a large (file) document that has repeated text (tokens) in it. These repeated tokens(text) are not the same in consecutive documents. The tokens always have an underscore in them and they are always uppercase. However, I need to display the first occurrence of each token into a listbox. The trouble is, I always get the repeats in my list box. :(
Clearly, I need some sort of 'repeat limiter' in my expression.

Code:

([A-Z]+(_)[A-Z_;]+[0-9]+)

Here is an example of some tokens I need to find:

Code:

SYS_IDTN;3;CCD;EVENT_TIME;8;14585900;JOB_NUM;6;DUJ748;SYS_IDTN;3;DCD;;EVENT_TIME;8;15052300;

As you can see the tokens are starting to repeat. My expression doesn't stop this.
Any ideas?

Serge314 · September 8th, 2006, 03:04 AM

Hi,

I'm master of Perl regex. :-) Do you use Perl? May be this regex help you?
([A-Z]+(_)[A-Z_;]+[0-9]+).*$

Regards,
Serge
http://www.gameintellect.com