Greetings! We are using Ranorex Studio 5.2 with excel to data-drive our applications. However, we now need to "convert" a powershell "text" file with data in a "sequential record by row" format (-FirstName Danny -LastName Smith -Address 3882 W Congress St -City Mobile -State AL) into data columns, for our excel spreadsheet module variable binding. Is there an easy (quick) way to format a PowerShell script text file into "excel-friendly" columns automatically? (Otherwise, we're doing this "manually", which is quite time-intensive.) Thank you, and Happy Holidays!
Steve
Working with a powershell script for data parameterization
Re: Working with a powershell script for data parameterization
You could create another powershell script that reads the first one and puts it in comma-separated-value format, which excel will read.
You would need to loop through the current file's lines and setup the CSV table with headers for the columns.
You would need to loop through the current file's lines and setup the CSV table with headers for the columns.
Shortcuts usually aren't...
Re: Working with a powershell script for data parameterization
krstcs,
Thank you for your reply. I appreciate your thoughts on creating a new powershell script, but as I don't have powershell installed, nor am I am developer, I found a fairly quick method of "manually" copy/pasting the test data into my existing excel data connector, which seems to work for our purposes.
Regards,
Stevelink
Thank you for your reply. I appreciate your thoughts on creating a new powershell script, but as I don't have powershell installed, nor am I am developer, I found a fairly quick method of "manually" copy/pasting the test data into my existing excel data connector, which seems to work for our purposes.
Regards,
Stevelink