The following returns any record with the carriage return character in the accountid field of table accounts. (db2)

select *
from accounts
where accountid like '%' || char(x'0D') || '%'

For those pesky spanish files

iconv --from-code=ISO-8859-1 --to-code=UTF-8 ./oldfile > ./newfile

bash substring

${i:0:21}

where i is a string, 0 is the start point and 21 the length.

eg
i='123456789'
echo ${i:1:4}

produces '2345'

echo ${'123456789':1:4}
does not work,
> echo ${'123456789':1:4}
-bash: ${'123456789':1:4}: bad substitution