WhilePrintingRecords;
Global StringVar Array AddressParts;
Global StringVar StreetNumber;
Global StringVar StreetName;
Global StringVar UnitNumber;
Local NumberVar Index;
If Not IsNull(YourField) then
(
AddressParts := Split({YourField}," ");
StreetNumber := AddressParts[1];
If UBound(AddressParts] >= 2 then
StreetName := Replace(AddressParts[2],",","");
If UBound(AddressParts] >= 3 then
For Index := 3 to UBound(AddressParts) do
UnitNumber := UnitNumber & " " & AddressParts[Index];
)
""
WhilePrintingRecords;
Global StringVar StreetNumber;
StreetNumber
http://stackoverflow.com/questions/697519/split-function-equivalent-in-tsql