怎么去掉 shell脚本导出的txt文档里的空格

[woxiangdui]

如题
这里出现了几个问题，各位大神看看，有解不

导出的语句
db2 "EXPORT TO ${_pathaddss}/IACI.txt of DEL select TABLENAME,CLAIMSEQUENCENO,CONFIRMSEQUENCENO,RECOVERYCODE from ZBTABLE_PK"


下面 是 TXT 里的数据 ：
"A","50PICC370015001439865885172131","",""
"B","50PICC370015001439865885172131 ","02PICC370015001439865115632111 ",""
"C","50PICC370015001439865885172131 ","02PICC370015001439865115632111 ",""
"D","50PICC370015001439865885172131 ","",""
"E","50PICC370015001439865885172131 ","",""
"F","50PICC370015001439865885172131 ","",""
"D","50PICC370015001439865885172131 ","",""




数据还有重复的
脚本语句：
eecho '定核损车辆配件明细表'
_DINGCHEMINGNO=`db2 -x "select ClaimQueryNo from IALVEHICLEFITTING where ClaimQueryNo = '${j}'"`

db2 "insert into ZBTABLE_PK values ('IALVEHICLEFITTING','${_DINGCHEMINGNO}','','')"
db2 "insert into ZBTABLE_PK values ('IALVEHICLEFITTINGHis','${_DINGCHEMINGNO}','','')"

导出的txt 数据 ：

"IALVEHICLEFITTING","50PICC370018001516156153150100 50PICC370018001516156153150100 ","",""


希望大神指点下啊

[焊工0531]

方法1：在Select语句字段前添加 trim(字段)，去除空格；使用distinct 字段，去除重复。 方法2：使用UE或 NotePad++ 等富文本编辑器处理文本，使用匹配空格+后引号替换去除空格；使用编辑>行操作>排序，再去除重复。 编辑器不同，个别菜单名称也大同小异，具体工具再百度，这里提供一个思路。

[lingbaole]

导出IACI.txt后，cat IACI.txt | sed -e "s/ //g">IACI_1.txt。IACI.txt 是源文件，IACI_1.txt 是去空后的重定向文件。 cat 这句直接加在导出语句db2那句后面，放shell里，一起执行即可