如何利用awk将输出的的顺序进行置换

jiajuzh

需要处理的文件如下
awk -F "," '{print $0}' test.txt
0633,010083002028,yourname,9456.41,200906,311111160000

希望输出列的顺序为 $1,$2,$3,$6,$5,$4  
执行如下命令没有达到预期效果
awk -F "," '{OFS=",";print $1,$2,$3,$6,$5,$4}'  test.txt
,200906,9456.4128,yourname,311111160000

请指教错误在哪里,应该如何实现

yy_galois

我这试了没问题。是不是你的不是gawk。

如果不是gawk，还是使用最标准的写法
awk 'BEGIN{FS=",";OFS=","}{print $1, $2, $3, $6, $5, $4}' test.txt
试试。

因为 -F "," 我猜测，是不是会把F后面的空格解释为FS。

jiajuzh

百思不得其解，看样子不是分割符的问题
awk 'BEGIN{FS=",";OFS=","}{print $1,$2,$3,$6,$5,$4}' test.txt
,200906,9456.4128,yourname,311111160000

怎么知道awk的版本？

sandljj

awk -F "," '{OFS=",";print $1,$2,$3,$6,$5,$4}'  test.txt
awk 'BEGIN{FS=",";OFS=","}{print $1, $2, $3, $6, $5, $4}' test.txt

都没有问题啊。。。

$awk --v
GNU Awk 3.1.5
Copyright (C) 1989, 1991-2005 Free Software Foundation.

This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.

jiajuzh

我是装的
Red Hat Enterprise Linux AS release 4 (Nahant Update 7)
默认的awk版本是
awk --v
GNU Awk 3.1.3

yy_galois

应该不是awk本身的问题。

要不是显示终端的问题。

jiajuzh

找到原因了，原来是第六列换行符被带到了现在第4列的位置
0633,010083002028,yourname,311111160000^M,200906,9456.41

请问如何避免出现这个问题呢

yy_galois

dos2unix test.txt

awk 'BEGIN{FS=",";OFS=","}{print $1,$2,$3,$6,$5,$4}' test.txt

jiajuzh

结案，多谢yy

blackold

awk --version

是什么环境？