Count characters

[emikoo]

Hi,

I have a table containing a memo field (1440 char. long). The memo field contains a sequence of characters, and I would like to do a count on each character. ie:

table:
Name_id String
John AABBCBCACBVB

to be converted in:
John A 3
John B 5 etc.

-OR-
Name_id A B
John 3 5

If got on this forum a vba script that parses the string in 1440 individual records. This however does take a lot of time to run (over a million records for one weeks data). Any suggestions to create the above listed result?

Thnxs,

EK

 

[oharab]

You could do it in a query.
Copy this function into a module in your database, then create a new query:

SELECT Name_ID,CountChar([String],"A&quot AS A,CountChar([String],"B&quot AS B,CountChar([String],"C&quot AS C...

will give you

Name_id A B
John 3 5


HTH

Ben ----------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

----------------------------------------