Shell Programming and Scripting

i had a shell script writing a xml file. I need to use "& # 163;" instead of "£", and replace others characters like: > to > , and so on.. Anyone know how to convert the character automatically? my script as below:


do
# GET FEED REC
SQL2="SELECT A.*, B.subject FROM feed_details A, feed_category B where A.status=0 and A.feedCategoryId=B.id limit 1"
#FEED="$(/usr/bin/mysql -N -u${DB_USER} -p${DB_PWD} -h${DB_HOST} ${DB_NAME} -e "${SQL2}")"
FEED="$(/usr/bin/mysql -N -u${DB_USER} -p${DB_PWD} ${DB_NAME} -e "${SQL2}")"
arrayDB=($FEED)

echo " <item>"
echo " <guid isPermaLink="false">SMS${arrayDB[$dbId]}-${DB_CUR_DATE}</guid>"
echo " <pubDate>${arrayDB[$dbPubishDate]}</pubDate>"
echo " <dc:subject>${arrayDB[$dbSubject]}</dc:subject>"
echo " <dc:description>SMS</dc:description>"
echo " <dc:type>Text</dc:type>"
echo " <dc:format>text/plain</dc:format>"
echo " <description>${arrayDB[$dbDescription]}</description>"
echo " </item>"

# UPDATE STATUS TO 1 (DONE)
SQL3="UPDATE feed_details SET status=1 WHERE id='${arrayDB[dbId]}' limit 1"
done


I am trying to convert the value from DB to xml character set, £--> "& # 163;"
Anyone can help???

Many solutions , u can transfrom via dml using the function replace.

Code:

  1* select replace('example£1','£','& # 163;') from dual
Pulse cualquier tecla para continuar ...

REPLACE('EXAMPLE
----------------
example& # 163;1

Or you can modify the variable:

Code:

FEED="example£1"
FEED=$(echo ${FEED}|sed -e "s/£/& # 163;/g")

Or if you have perl , and wanna change a source data.

Code:

perl -pi -e "s/£/& # 163;/g" file_2_change

Or ...