mithandir1 Posted May 22, 2012 Share Posted May 22, 2012 I am work on a script that pulls data from a information screen that gives information in an Excel format. I can copy rows from this screen and it will paste to Excel and It is recognised as a row in Excel. What I ultimatly want to do is assign varibale based on the information in the rows. The following is a test script that I am using to try try to figure out how to split up the information. $data = "a C C N J K" ;copied from excel $vars = StringSplit($data, "{TAB}") MsgBox(1, "test", $data) MsgBox(1, "test1", $vars[0]) MsgBox(1, "test2", $vars[1]) MsgBox(1, "test3", $vars[2]) MsgBox(1, "test4", $vars[3]) MsgBox(1, "test5", $vars[4]) MsgBox(1, "test6", $vars[5]) I am not 100% that the seperator is a tab. Any help would be greatly appreciated. Link to comment Share on other sites More sharing options...
water Posted May 22, 2012 Share Posted May 22, 2012 Replace line$vars = StringSplit($data, "{TAB}")with$vars = StringSplit($data, @TAB)and give it a try. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
mithandir1 Posted May 23, 2012 Author Share Posted May 23, 2012 Thank you very much kind Sir. Link to comment Share on other sites More sharing options...
water Posted May 23, 2012 Share Posted May 23, 2012 My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now