需求:查询ORACLE数据写入TXT文件,列分隔符为^A(ASCII码为0x01);行分隔符为换行符(ASCII码0x0A),数据项中不能出现ASCII码为0x00-0x1F、0x7F的各类控制字符和非打印字符,若有则统一替换为空格符(ASCII码0x20)
使用shell脚本应该如何实现,以下脚本分隔符感觉不对,并且汉字后面会出现一大串空格,请大佬帮忙
#!/bin/bash
tablename=PLAN_PERIOD_TBL
attributes=P,FULL_NAME,ABBR_NAME,DESCRIPTION
BXJGJRXKZ='123456'
sqlplus /@wallet_jihe <<EOF >/app/shell/jihe_test/datafile/TMP_$tablename
set trimspool on
set pages 0
set feed off
set heading off
set feedback off
set verify off
set linesize 1000
set colsep '^A'
select $attributes,$BXJGJRXKZ from $tablename;
EOF