Recommend data-cleaning/reformatting programs/languages

I’m pretty sure the president doesn’t want a commercial service. I think he wants a software package we can buy and just use. Let me try to show you the kind of thing we’re trying to do. This is what we get:

[JOHNNY’S BUILDERS AND ] [CONTRACTORS INC 8910 HARVARD ] [ST APT 700 ] [SAN FRANCISCO] [CA]

This is what we want:

[JOHNNY’S BUILDERS & CONTRACTORS INC ] [] [8910 HARVARD ST #700 ] [] [SAN FRANCISCO] [CA]

Where the brackets indicate fields.
[ul][li]AND in the Name field has been changed to &;[/li][li]The business name portion of the Address field has been concatenated onto the name;[/li][li]An additional business name field has been added;[/li][li]The street address portion of the Address field, and the rest of the address from the secondary address field have been concatenated;[/li][li]APT[space] has been changed to #.[/ul][/li]
I’ll see what I can find out about python.