<COMMENT Value="Assumes a new, blank 'spreadsheet like' file is open, with text cursor at the start of the top line."/>
<COMMENT Value="For this demo it is the file 'C:\\1\\Gordy.xlsx'"/>
<COMMENT Value="Now get each line of source.txt into the ARRAY variable %Line%"/>
<COMMENT Value="And copy each line into the spreadsheet. So the first variable will be %Line[1]%, followed by %Line[2]%, etc."/>
<VARIABLE SET INTEGER Option="\x00" Destination="%x%" Value="1"/>
<TEXT FILE BEGIN PROCESS Filename="C:\\1\\source.txt" Start_Record="1" Process_All="TRUE" Records="5" Variable="%Line[]%"/>
<WINDOW ACTIVATE Title="Gordy" Exact_Match="FALSE" Wildcards="FALSE" _IGNORE="0x0006"/>
<DELAY Flags="\x01" Time="0.2"/>
<TEXT TYPE Action="0" Text="%Line[%x%]%<ENTER>"/>
<VARIABLE MODIFY INTEGER Option="\x07" Destination="%x%"/>
<TEXT TYPE Action="0" Text="<ARROW DOWN>"/>
<DELAY Flags="\x01" Time="0.1"/>
<TEXT FILE END PROCESS/>
unfortunately, I cannot cut n paste directly to the end application. It is excel like, that is a grid, but the data must be entered one cell at a time and then navigate (arrow down) to the next cell.
When I am manually entering the data, the sequence is
1. enter or double click
2. type data ( 4 to 6 digit number OR 8 to 16 character string)
3.enter or click ok
4. arrow down
repeat
my csv file has one entry per line, 99 lines deep - i need to copy those to a spreadsheet like program - once the variables are loaded, the data will be entered one at a time then <ENTER>, then <ARROW DOWN>, then repeat - - - - i cant even get the first one to copy, all i get is %T1%