AutoHotkey Community

[edu]

Hello I am trying to copy and paste some text from several html files to an ms excel file.
The text is copied to the clipboard like this:
NEW NAME
UC 900-640-O Light Blue
UC 900-645-O Peacock Blue
UC 900-650-O Powder Blue
OLD NAME
A9540-O Light Blue
A9545-O Peacock Blue
A9550-O Powder Blue
I want to be able to paste NEW NAME and data below in one column and the OLD NAME in the next column. Basically I wish to transform the data into this:
NEW NAME{TAB}OLD NAME
One of the approaches I thought of was: create a variable to hold the contents of "NEW NAME", paste it in column 1; insert everything from OLD NAME on into a new variable and paste it in column 2.
Another approach could be generating a tab delimited file.
Then I got stuck in the loop construct...
This was what I started trying:

[evan]

is the data lines always equal?

[[VxE]]

[edu]

Thank You, [VxE]! I never thought the stringsplit would do the job!

Edu
_________________
The best things of life are free.