Hello, I have a table from an application which i am reading. I cannot use any screen scraping methods.
Let’s say you have a column that looks like the column below (City is the header):
After copying this column to the clipboard I output it with the name string_Variable
If i use the below code, the first item is City but I want the 1st item to be Miami
item = split(string_Variable,Environment.NewLine)
What addition do i need to make to the code to get Miami as the 1st item?