The innermost SUBSTRING will yield this:
LUC20031026901 ; Vehicle
Consolidated
SUB35030172701 ; Building
LIQ200310121 ; Liquor
and when the semicolon is added, it will look like this:
LUC20031026901 ; Vehicle ;
Consolidated ;
SUB35030172701 ; Building ;
LIQ200310121 ; Liquor ;