Remove numbers from address 1

[Jake1]

I need to remove the street address (number) from an address field and only print the text part of the address. I have done this in foxpro and dbase by locating the first "blank" in the address and then printing/listing the rest of the address. I assume this is how I would have to do this also but I am not sure on how to create and execute the formula.

 

[IdoMillet]

If you are 100% sure all address fields start with a number with a space after it, then:
-------------------------------------
LEFT({address}, InStr({Address}," &quot)
-------------------------------------

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[mbarron]

This should get you what you're looking for. I've added a check step in case your address doesn't start with a number.


if isnumeric(left({your.field},1)) then
mid({your.field},instr({your.field}," &quot ) else
{your.field}
Mike

Before: After