Solved

Switch columns 3 & 4 using perl or shell scripts

Posted on 2011-02-10

2 solutions

Medium Priority

437 Views

Last Modified: 2012-05-11

If I have a file that looks like this. The date may also be 01/01/11 format and column 3 & 4 may contain whole numbers as well like 2, 3, 4 rounded to the whole number. How would I switch column 3 & 4 while leaving everything else alone?

01-24-2011 14:15:01 0.00 0.00
01-25-2011 02:15:02 0.00 0.00
01-25-2011 14:15:02 0.00 0.00
01-26-2011 02:15:02 0.00 0.00
01-26-2011 14:15:01 0.00 0.00
01-27-2011 02:15:01 0.00 0.00
01-27-2011 14:15:01 0.00 0.00
01-28-2011 02:15:01 0.00 0.00
01-28-2011 14:15:01 0.00 0.00
01-29-2011 02:15:01 0.00 0.00
01-29-2011 14:15:01 0.00 0.00
01-30-2011 02:15:01 0.01 0.00
01-30-2011 14:15:01 0.01 0.01
01-31-2011 02:15:01 0.00 0.00
01-31-2011 14:15:01 0.00 0.00
02-01-2011 02:15:01 0.00 0.00
02-01-2011 14:15:01 0.00 0.00
02-02-2011 02:15:01 0.00 0.00
02-02-2011 14:15:01 0.00 0.00
02-03-2011 02:15:01 0.00 0.00

Comment

Question by:libertyforall2

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

3 Comments

LVL 9

Accepted Solution

by:sshah254

sshah254 earned 1000 total points

ID: 348677702011-02-10

In perl, read the line, use the split function (split at spaces) to split the line into array. Print the line back
with elements 2 & 3 reversed (elements will be 0, 1, 2, and 3 ... 4 elements).

Ss

LVL 84

Assisted Solution

by:ozo

ozo earned 1000 total points

ID: 348677812011-02-10

perl -lane 'print "@F[0,1,3,2]"'

Author Closing Comment

by:libertyforall2

ID: 348683462011-02-10

works great!

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Invest in Future Developers and UX Designers

Article by: Lexie

Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …

4 Ways to Get the Most out of Courses

Article by: Gene

Make the most of your online learning experience.

Xpdf - PDFfonts - Command Line Utility to List Fonts Used in a PDF File

Video by: Joe

In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…