Can I suggest using the rw_SelectAddrLine user defined function in the system series.
You can pass in the number of the line you want and all the separate address information and it will return the lines without any blanks.
in integer nLineNum;
in string sLine1_Contact;
in string sLine2_Company;
in string sLine3_Add1;
in string sLine4_Add2;
in string sLine5_Add3;
in string sLine6_City;
in string sLine6_State;
in string sLine6_PostalCode;
in string sLine7_Country;
Create one calculated field for each of the lines you want returned, changing the first paramter accordingly.
David Musgrave [MSFT]
Senior Development Consultant
MBS Services - Asia Pacific
Microsoft Business Solutions
Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.