How to strip out any number in a field? 2

[ziggs]

I have a Crystal Report that has an address field. Within that Address field are the digits, a street name and then a street type. However, sometimes a free format can be used (i.e. Main St/1st St, Taco Bell, Garage area of 123 Main St). Anyway, I need to find a way to take away for numbers in this string. Most of the time, the numbers will be in front, but not always.

Any Direction?

TIA

 

[Turkbear]

Hi,
By 'take away' what do you mean?

Not show them?
Use them in some formula?
Just display the Numbers?


Please provide a sample of what you would like to see:
( What is in the field vs what you want)
Also,
What Crystal Version?
What database and version?
What connection method?






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

Try:

numbervar i;
numbervar j := len({@string});
stringvar x;

for i := 1 to j do(
if isnumeric({@string}) then
x := x else
x := x + {@string});
trim(replace(x," "," "));

-LB

 

[kskid]

lbass,

Just a thought but I think ziggs wants just the address number taken away. I think he just want to take the 123 from 123 Main St.

Otherwise

/1st st

will become

/st st

can we just split the line and check for numeric value on each word?

-lw

 

[ziggs]

Unfortunately, garbage in, garbage out. I have to code to make sure that an address does not EVER get published. Thus, I still need to code out 1, in 1st St since the positioning of the digits may, in just a few cases, be in the middle of the record.

I'll play with the lbass's formula in just a bit.

Thanks!

 

[synapsevampire]

You can simplify a bit

numbervar i;
numbervar j := len({@string});
stringvar x;
for i := 1 to j do(
if not(isnumeric({@string})) then
x := x + {@string});
);
trim(x)

-k

 

[ziggs]

synapsevampire and lbass's formula works, but for each row it just adds another street until a string is over 254 characters long. I'm still trying to figure out how to reset the variables after it populates for each row.

 

[lbass]

Just add "" to the x variable as below:

numbervar i;
numbervar j := len({@string});
stringvar x := "";

for i := 1 to j do(
if isnumeric({@string}) then
x := x else
x := x + {@string});
trim(replace(x," "," "));

-LB