open data myData.dbc >use original >add table ReceivedAndTruncated && Add received table to DBC >use ReceivedAndTruncated in 0 >for ix=1 to fcount() > lcFrom = alltrim(upper(field(ix,'ReceivedAndTruncated'))) > lcTo = alltrim(upper(field(ix,'Original'))) > IF !lcFrom == lcTo > ALTER table ReceivedAndTruncated ; > rename column &lcFrom to &lcTo > ENDIF >endfor >select Original >append from ReceivedAndTruncatedWhen done delete ReceivedAndTruncated using 'remove table'.