Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

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.


Comment on Re^2: one liner?
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.

    CountZero

    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
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?

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://985227]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (8)
As of 2014-12-21 18:14 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (106 votes), past polls