re: OT: Excel Pivottables

["White, Peter" <peter.white@xxxxxxx>]

On a related (but still completely off-topic) note, does anyone know how,
within Excel, to match a text string against a template, and report whether
it's a good or bad match?

i.e. - an example string:

447956931123,04021001360 105811 1115 4C041 3J56T #KEY,22/01/04 11:44:30,2

Where the first field is a phone number, and the rest of the fields (sent
via SMS) are required.  The one snag is that these messages are coming from
all over Europe, so the formula needs to know to only run the comparison
between the 2 commas, i.e. I'd need the template to ignore everything
before
the first comma and after the last, and look for

0nnnnnnnnnn 105nnn hhmm aaaaa aaaaa aaaaaaaaaaaaaaaaaaaaaaaaaa...

Where n is a numeric, a is an alpha/numeric, and the other numbers are
constants.  The last field is only limited by the length of the SMS
message.
Because mobile numbers over Europe vary in length, doing a simple count in
to the text string doesn't work, it has to be a formula that knows to start
>from

Any help very welcome!

Pete

Oh, and my VBA knowledge is non-existent!


-----Original Message-----
From: Rob Mouser [mailto:groups@xxxxxxx]
Sent: 21 January 2004 20:13
To: ukha_d@yahoogroups.com
Subject: RE: [ukha_d] OT: Excel Pivottables


Thanks Pete

Aren't pivottables fun (NOT!) I use them a fair bit but was trying to
create
something a little more complex to analyze 14mb worth of invoice data(Some
50,000+lines.) I was trying to avoid inserting additional columns in the
source data as the whole idea was to have a fairly automated report, just
updating the pivot table when more data was added.
Guess I'm going to have to dive in and dust of my VERY dated and VERY VERY
limited VBA knowledge so I can automatically add the required
columns/additional info into the source data.

Hohum....

Rob



[Non-text portions of this message have been removed]


UK Home Automation Meet 2004 - BOOK NOW!
http://www.ukha2004.com

http://www.automatedhome.co.uk
Post message: ukha_d@yahoogroups.com
Subscribe:  ukha_d-subscribe@yahoogroups.com
Unsubscribe:  ukha_d-unsubscribe@yahoogroups.com
List owner:  ukha_d-owner@yahoogroups.com