#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2012
    Posts
    1
    Rep Power
    0

    New to perl and have questions


    Hi all,

    I have to run a perl script by converting from sql 2005 to sql 2000. The connection is "use win32: : odbc". Is there a method for me to run the perl script out of sql 2005 versus having to revert it to sql 2000. Any ideas on working around odbc? I don't believe going to DBI is an option as I am dealing with tables in sql that holds a lot of information to image paths. Pardon me if my question sounds stupid as I am really new to sql.

    thanks in advance,
    Phineas
  2. #2
  3. !~ /m$/
    Devshed Specialist (4000 - 4499 posts)

    Join Date
    May 2004
    Location
    Reno, NV
    Posts
    4,221
    Rep Power
    1809
    There's an ODBC driver for DBI, so that isn't a problem.

    DBD::ODBC

    I'm not sure what you mean by converting from SQL 2005 to SQL 2000. On the perl side, you only need to make the connection. If the database schema is different, then you'll obviously need to make adjustments to the script to match the new table and field names.

    It's pretty easy to query the database though with a script and receive the new schema.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2012
    Posts
    1
    Rep Power
    0

    Perl script


    I have an excel file that has 912266312249,66312250/23451985
    in a single cell i need to separate these files to separate cells and some files have +91 22 264 23801,26428804 same way i have to separate them.. and add the missing data from the previous field to the second one like +91 22 missing in the 2nd field how do i do this using perl or is their any easy way to do this
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Jun 2012
    Posts
    776
    Rep Power
    495
    I do not understand what you are trying to do. Please explain better.

IMN logo majestic logo threadwatch logo seochat tools logo