In that case how do I go about swapping two columns? I do not think a
gazzillion byte gui is required.
The file size is about 43Megs.
any ideas?
--
Regards,
Rajagopal
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
08-28-2012, 08:06 PM
Cut command behaviour - bug or feature
Rajagopal Swaminathan wrote:
> Greetings,
>
> I have a CSV file with three fields.
> eg.
>
> a1,b1,c1
> a2,b2,c2
> ....
>
> I wanted the output to be:
> b1,c1,a1
> b2,c2,a2
> ....
>
> the command
> cut -d, -f2,3,1 <file>
>
> returns
>
> a1,b1,c1
>
> cut -d, -f2,3 <file>
>
> works as advertised.
>
> Is it specific to linux?
>
> In that case how do I go about swapping two columns? I do not think a
> gazzillion byte gui is required.
>
> The file size is about 43Megs.
I've never been that good with cut. I'm going to see the author, Dave
Ihnat this weekend, who sometimes shows up here... but in the meantime,
you might use
awk 'BEGIN {FS=",";}{print $2 "," $3 "," $1;}' infile
mark
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
08-28-2012, 08:14 PM
Rajagopal Swaminathan
Cut command behaviour - bug or feature
Greetings,
On Wed, Aug 29, 2012 at 1:36 AM, <m.roth@5-cent.us> wrote:
>
> I've never been that good with cut. I'm going to see the author, Dave
> Ihnat this weekend, who sometimes shows up here... but in the meantime,
> you might use
> awk 'BEGIN {FS=",";}{print $2 "," $3 "," $1;}' infile
>
I tried it on an xp box with GnuWin32 binaries. It barked some error
showing the single quote.
I will try on a centos box later (<grin>which I am silently injecting
[installing] into that env after handwaving the xp</grin>).
--
Regards,
Rajagopal
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
Cut command behaviour - bug or feature
