Re: Text file in two columns, how to seperate?

[Rubywand <rubywand@swbell.net>]

The Apple II Mail Group writes ...
>
> <Rubywand wrote:> 
> >Press Control-@ (Control plus the 2/@ key shifted) to end recording of the
> >"T"
> 
> This complicated keypress is no longer necessary to end the macro. In newer
> versions of UltraMacros, Ctrl-X is a toggle, and can be used to both
> begin and end a recorded macro.
>

     Have been using Ultra Macros (occasionally) for years on the IIgs with
Awks 5 and never noticed that!

 
> Here's another scenario to separate two columns into one:
> 
> Starting at the first letter of column 2, record this macro:
> 
> Tab down OA-left

     One thing about this macro ... it does assume that the beginning of each
entry in column two will not have a space inside the length of the Tab. For
example something like A. Ants  could require two OA-lefts. (A workaround is to
set a Tab stop one character to the right of the start of column two.) 

> 
> Repeat the macro all the way down column 2. Now you have a TAB on each line
> between the two columns.
> 
> COPY the entire  text to the clipboard, and create a new spreadsheet.
> Copy the data into the spreadsheet. Because of the TAB, the two columns
> will come in as separate columns.
> 
> Use the spreadsheet's Block Move function to move column 2 to the foot of
> column 1. Sort (arrange) alphabetically if necessary.
> 
 ....

     Yes; this idea works better. Once you see that the principle is to convert
the Text into stuff that gets separated into columns on a spreadsheet, it's
easy to come up with variations suited to a particular rearrangement task.
Thanks for the idea!



Rubywand