Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked

Re^2: How is Perl for automation?

by Fletch (Chancellor)
on Dec 04, 2020 at 16:26 UTC ( #11124646=note: print w/replies, xml ) Need Help??

in reply to Re: How is Perl for automation?
in thread How is Perl for automation?

Very important point. Keep in mind that spreadsheets are widely seen as risky by auditors and their ilk. At $work (large US bank) we've had a big initiative put in place to catalogue and manage the inventory of spreadsheets used because of the inherent risks. You can't (as easily) put the logic in a spreadsheet under SCM or subject it to a test suite like you can perl (or python, or R, or ...) which generates the underlying CSV that's displayed.

The cake is a lie.
The cake is a lie.
The cake is a lie.

Replies are listed 'Best First'.
Re^3: How is Perl for automation?
by fidodido (Sexton) on Dec 05, 2020 at 12:26 UTC


    1) Thank you for making me aware of the risk issue. Another monk also offered solid advice on how to NOT use excel as source of data. You are all genuinely helpful folks.

    2) So, you are saying that Perl is used in a big bank? Even now? That is good!!

      So, you are saying that Perl is used in a big bank? Even now? That is good!!

      I've heard very scary stories about IT in banks. Lots of legacy software (COBOL and the like) dating back to 1960s or 1970s, emulators in emulators, and a lot of pre- and post-processing around that to keep things working. "Never change a running system" codified in expensive and time-consuming recertification processes.

      Don't expect better from other businesses. I know of medical lab equipment running in production environment way into the 2000s based on a CP/M system. And even worse, a MUMPS system running the main business, both medical and financial, hacked togeter since the 1980s by a few unskilled people, in the same company, also way into the 2000s.

      You will find Perl in a lot of unexpected places over time. It's called swiss army chainsaw for a reason. I've used Perl in all of my jobs over the last two decades, and I will continue to do so. It does not solve all problems, but it solves a lot of small problems with very little effort, and the bigger ones with reasonable effort.


      Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)


        Thanks again for the update. I was under the impression that the banks are in the process of replacing Perl with Python everywhere.....another internet generated FUD huh.

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (9)
As of 2021-04-22 17:28 GMT
Find Nodes?
    Voting Booth?

    No recent polls found