Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Re^2: Compare Inventory to Database and Vice-Versa

by Hellhound4 (Novice)
on Mar 22, 2012 at 00:22 UTC ( #960898=note: print w/replies, xml ) Need Help??

in reply to Re: Compare Inventory to Database and Vice-Versa
in thread Compare Inventory to Database and Vice-Versa

I have experience in C++ and (recently) VBA I've actually written the program in VBA but it only throws an error if there is something in the database and not the directory. But I would like to know if there is something hanging out in my directories that shouldn't be there as well. And I am reading the tutorials right now. Most of my questions are about syntax and perl specific issues. For example if I make this on my linux pc at home will I have to change anything other than directory name on the windows pc at work.
  • Comment on Re^2: Compare Inventory to Database and Vice-Versa

Replies are listed 'Best First'.
Re^3: Compare Inventory to Database and Vice-Versa
by GrandFather (Sage) on Mar 22, 2012 at 01:22 UTC

    If you've written it in VBA then rewriting in Perl should be a snap! Perl has much better, well everything really, than VBA, but especially string manipulation, control structures and data structures. You'll find Perl is much closer to C++ in many ways than to VBA.

    As I said earlier, hashes are the key. Think STL's map class.

    For standard sorts of stuff Perl is very portable. For what you have described so far you should be able to move your *nix script to a Windows box unchanged. Note that Perl will even "do the right thing" with native line endings so on *nix it uses line feeds and on Windows carriage return line feed pairs when reading and writing files by default. A \n used in regular expressions and string turns into the correct thing for the native OS.

    I suggest you whip up some code than come back for a little criticism. Oh, and always use strictures (use strict; use warnings; - see The strictures, according to Seuss) ;).

    True laziness is hard work
      I agree. I'm working on some right now. Can you point me toward some good references for syntax of loops. Hashes seem to be covered well in the tutorial section. Also I am new here so should I add a reply with code or update my original post? And how do I flag?

        I'd be inclined to post a new question with code and questions focused on that code.

        perlsyn is the place to look for control structure syntax. Don't be seduced into using C++'s for loop, use Perl's for my $element (@list) loop instead. 'next' and 'last' are 'continue' and 'break', but look at 'redo' too.

        Pay special attention to the Perl operators. Mostly they look familiar to a C++ user, but there are a few extra that are worth knowing about and some of them do special magic of a mind reading nature.

        If you have time take a look at map and grep. In any case you must at least skim perlretut. If you plan to stick with Perl for the long haul get a copy of the "Perl Pocket Reference". I wore my first copy out!

        True laziness is hard work
Re^3: Compare Inventory to Database and Vice-Versa
by Hellhound4 (Novice) on Mar 22, 2012 at 00:44 UTC
    On a different note... Is there a way to edit my own reply's? I see where to edit my post. But not my replys.

      If you click on the title of your reply (which is a link) you will get the same style edit page as you do for your original node.

      As a (related) aside, if you make substantive changes to any of your nodes please ensure that you flag the changes so it is clear the content has changed. And please avoid deleting stuff because that often renders replies meaningless.

      True laziness is hard work
        Ah! Thank you. So a serious Perl question. If I do make and test this on my linux machine what kind of headache am I looking at to deploy it on the windows machines at work. They'll be running Strawberry Perl.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://960898]
[erix]: hm zipfile-SQLite sounds useful, have you tried it already, Corion?
[erix]: and good morning (sorry :))

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (7)
As of 2018-01-24 08:52 GMT
Find Nodes?
    Voting Booth?
    How did you see in the new year?

    Results (256 votes). Check out past polls.