You’re offline. This is a read only version of the page.
2
I need to replace the original column text values with the New ID. I need to maintain the commas.
Original Column
| contract_communities_list |
| Avalon Wilton on River Rd (CT005), Avalon New Canaan (CT014), Avalon Darien (CT017), Avalon Norwalk Retail (CT021) |
| Avalon East NorwalkSOLD (CT026), Avalon New Canaan (CT014), Avalon NorwalkSOLD (CT022), Avalon Wilton on DanburySOLD (CT024) |
| Avalon East NorwalkSOLD (CT026), Avalon New Canaan (CT014), Avalon Wilton on River Rd (CT005), Avalon Norwalk Retail (CT021) |
| Avalon East NorwalkSOLD (CT026), Avalon New Canaan (CT014), Avalon Wilton on River Rd (CT005), Avalon Norwalk Retail (CT021) |
| AVA DoBro (NY037), Avalon Clinton North (NY533), Avalon Clinton South (NY534), AVA Fort Greene (NY026), Avalon MamaroneckSOLD (NY006), Avalon Midtown West (NY525), Avalon Morningside Park (NY823), Avalon OssiningSOLD (NY035), Avalon Riverview (NY011), Avalon Riverview North (NY018), Avalon West Chelsea (NY829), Avalon White Plains (NY022), Avalon Willoughby Square (NY039), Avalon Yonkers (NY047), Avalon Bowery Place II - JV (NY821), Avalon Green ISOLD (NY003), Avalon Green IISOLD (NY032), Avalon Green IIISOLD (NY038), AVA High Line (NY834), Avalon Bowery Place I (NY815) |
Reference Data to use for replacement
| Reference | New ID |
| eaves Quincy (MA003) | MA003 eaves Quincy |
| Avalon at The Pinehills (MA016) | MA016 Avalon at The Pinehills |
| Avalon at the Hingham Shipyard (MA027) | MA027 Avalon at the Hingham Shipyard |
| Avalon Northborough (MA030) | MA030 Avalon Northborough |
| Avalon Northborough II (MA032) | MA032 Avalon Northborough II |
| Avalon at The Pinehills II (MA033) | MA033 Avalon at The Pinehills II |
| Avalon Natick (MA037) | MA037 Avalon Natick |
Share
Report
All responses (
Answers (
