Course Names with Missing Pound Signs ("£") 1

[jannoth]

I'm trying to identify courses which have been set up incorrectly : the last part of the text field Activity.Name should contain a pound sign followed by a numberic value at the end

Correct: Course Name £5000
Incorrect: Course Name 5000
Incorrect: Course Name

Can someone please suggest a way of listing records which don't contain correctly formatted contents in Activity.Name?

Thanks

J

 

[Madawc]

Do two tests:

"£" in {your.field}

 Ubound({your.field}, " ") = 3

First put them next to the data, to confirm they work and maybe show up the need for extra tests. Test 1 would also work with the "£" somewhere else, and you could also try

Left(Split({your.field}, " ")[3]),1) = "£"

It also depends on what else is valid, e.g.

Special Maths Course £333

would fail but you could adjust the code yourself.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP