数据转换

zjso

从表里面导出数据，其中含有金额型字段，请大侠帮忙把金额型字段前的+0000去除，谢谢！
第三列为金额型数据，数据类型为DECIMAIL(16,2)
原始数据：
"6601010100000010","王一                ",+00000000000218.94,"001260676"
"6601010100000004","施一             ",+00000000009856.60,"001261000"
"6601010100000014","施一              ",+00000000000218.94,"001261000"
"6601010200000012","郭二              ",+00000000000218.94,"001264909"
"6601010200000003","王东              ",+00000000001889.40,"001265040"
"6601010200000013","王东              ",+00000000000218.94,"001265040"
转成：
"6601010100000010","王一                ",218.94,"001260676"
"6601010100000004","施一             ",9856.60,"001261000"
"6601010100000014","施一              ",218.94,"001261000"
"6601010200000012","郭二              ",218.94,"001264909"
"6601010200000003","王东              ",1889.40,"001265040"
"6601010200000013","王东              ",218.94,"001265040"

ly5066113

sed 's/+0*//'

zjso

谢谢！
匹配任意字母，后跟任意字母的 0次或多次重

[ 本帖最后由 zjso 于 2008-9-27 16:29 编辑 ]

timdcn

*  0个或多个