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

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.

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

I do not understand what you are trying to do. Please explain better.