Counting Specific Letters in a String

[MaSchmid]

Dear All,

I was wondering if it is possible to count how often a particular character (i.e. 'A') occurs in a string (i.e 'AGCTATGCA). In this example the answer should be 3 (obviously).

Now doing this using a script is easy, but I can't figure out how to do it in a field calculation.

What I really would like to do is to be able to enter a string (its a DNA sequence btw) in >field1< which should result in a auto-enter calculation in >field2<. The calculation requires the number of 'A's in the string in >field1<.

Any suggestions?

Thanks,

M

[comment]

Try the PatternCount() function.

a auto-enter calculation in >field2<.

Why not use a calculation field?