Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery

Re^2: one liner?

by Anonymous Monk
on Aug 03, 2012 at 13:00 UTC ( #985227=note: print w/replies, xml ) Need Help??

in reply to Re: one liner?
in thread one liner?

I forgot about sprintf being able to do that. Thanks.

Though that solution won't work for a file with more columns.

Replies are listed 'Best First'.
Re^3: one liner?
by BrowserUk (Pope) on Aug 03, 2012 at 13:23 UTC
    Though that solution won't work for a file with more columns.

    This will:

    perl -F, -aple"$F[-1]=sprintf'%05d',$F[-1]; $_=join',',@F" in.csv

    With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'
    Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
    "Science is about questioning the status quo. Questioning authority".
    In the absence of evidence, opinion is indistinguishable from prejudice.

    The start of some sanity?

Re^3: one liner?
by CountZero (Bishop) on Aug 03, 2012 at 13:21 UTC
    perl -F, -aple"$_ = join ',', @F[0 .. $#F-1], sprintf '%05d',$F[-1]" in.csv

    This works even if each line has a different number of fields.


    A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

    My blog: Imperial Deltronics

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://985227]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (14)
As of 2018-03-22 14:34 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (276 votes). Check out past polls.