Hi,
Sometime in the past, data was loaded into tables from spreadsheets and the tabs and form feeds were included in the data. I can locate all the bad data, and am looking for a clear method to remove only the 'bad' character from a field, despite where it occurs. For example, you can see 09 at the end of the rawtohex column. I need to change Canada-Albertachr(9) to 'Canada-Alberta'. The form feeds in the second example are in a numeric field.
If anyone has had to do this, I'd appreciate knowing your method.
Thanks, Linda
Table Column Contents Rawtohex
----------------- ------------ -------------------- ---------------------------------
REG.AMA_COUNTRIES COUNTRY_NAME Canada-Alberta 43616E6164612D416C62657274612009
REG.AMA_COUNTRIES COUNTRY_NAME Canada-British Colum 43616E6164612D4272697469736820436F6C756D6269612009
REG.AMA_COUNTRIES COUNTRY_NAME Canada-Manitoba 43616E6164612D4D616E69746F62612009
REG.AMA_COUNTRIES COUNTRY_NAME Canada-New Foundland 43616E6164612D4E657720466F756E646C616E642009
REG.AMA_COUNTRIES COUNTRY_NAME Canada-Nova Scotia 43616E6164612D4E6F76612053636F7469612009
REG.AMA_COUNTRIES COUNTRY_NAME Canada-Ontario 43616E6164612D4F6E746172696F2009
REG.AMA_COUNTRIES COUNTRY_NAME Canada-Quebec 43616E6164612D5175656265632009
REG.AMA_COUNTRIES COUNTRY_NAME Canada-Saskatchewan 43616E6164612D5361736B617463686577616E2009
REG.AMA_COUNTRIES COUNTRY_NAME Afghanistan 41666768616E697374616E2009
REG.AMA_COUNTRIES COUNTRY_NAME Albania 416C62616E69612009
REG.AMA_COUNTRIES COUNTRY_NAME Algeria 416C67657269612009
REG.AMA_COUNTRIES COUNTRY_NAME Algeria 416C67657269612009
REG.AMA_COUNTRIES COUNTRY_NAME Angola 416E676F6C612009
REG.AMA_COUNTRIES COUNTRY_NAME Antigua 416E74696775612009
Table Column Contents Rawtohex
----------- ----------- ---------- ------------
REG.AMA_LOG MEDSCHOOLID 84708 38343730380D
REG.AMA_LOG MEDSCHOOLID 84708 38343730380D
REG.AMA_LOG MEDSCHOOLID 84709 38343730390D
REG.AMA_LOG MEDSCHOOLID 84709 38343730390D
REG.AMA_LOG MEDSCHOOLID 84710 38343731300D
REG.AMA_LOG MEDSCHOOLID 84710 38343731300D
REG.AMA_LOG MEDSCHOOLID 84710 38343731300D
REG.AMA_LOG MEDSCHOOLID 84710 38343731300D
REG.AMA_LOG MEDSCHOOLID 84710 38343731300D
REG.AMA_LOG MEDSCHOOLID 84710 38343731300D
REG.AMA_LOG MEDSCHOOLID 84710 38343731300D
REG.AMA_LOG MEDSCHOOLID 84710 38343731300D
REG.AMA_LOG MEDSCHOOLID 84710 38343731300D