# Recommend data-cleaning/reformatting programs/languages **URL:** \ **Category:** In My Humble Opinion\ **Created:** [September 14, 2017, 4:42pm UTC](https://boards.straightdope.com/t/recommend-data-cleaning-reformatting-programs-languages/796326 "2017-09-14T16:42:36Z")\ **Posts on this page:** 1\ **Showing post:** 3
**Author:** ![Johnny\_L.A](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/johnny_l.a/32/1084_2.png) [@Johnny\_L.A](https://boards.straightdope.com/u/Johnny_L.A)\ **Post date:** [September 14, 2017, 7:00pm UTC](https://boards.straightdope.com/t/recommend-data-cleaning-reformatting-programs-languages/796326/3 "2017-09-14T19:00:12Z")
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. --- _[View the full topic](https://boards.straightdope.com/t/recommend-data-cleaning-reformatting-programs-languages/796326)._