Numeric Filter

[mrichey]

Is there a formula that can be used to search a field and filter out all non-numeric data? Thank you!

 

[IanWaterman]

Try something like this

whileprintingrecords;
local stringvar result:="";

local numbervar code := length({Field});

local numbervar n := 1;



while n <= code do
(
if {Field}[n] in [Totext(0),Totext(1),Totext(2),Totext(3),Totext(4),Totext(5),Totext(6),Totext(7),Totext(8),Totext(9)] then result = result + &quot;&quot; else
result = result + {Field}[n];

n:= n+1;
);
result;


Ian Waterman
UK Crystal Reports Consultant

 

[IanWaterman]

Sorry not thinking no need for totext(), just put numbers in &quot;&quot;, eg &quot;2&quot;.

Ian