04.025 Is there a way to convert two-column Text to one column?
Description
This article is from the Apple II Csa2 FAQ, by Jeff Hurlburt with numerous contributions by others.
04.025 Is there a way to convert two-column Text to one column?
Yes. AppleWorks version 3.0 with TimeOut TextTools will do this.
First you have to install TimeOut. Then you copy the TimeOut accessories to the
TimeOut directory. The one you want is TimeOut CopyBlock. To copy only column
two, press OA-C (OpenApple-C) to highlight and copy the block of text on the
right. Then scroll down to the end and paste it there.
Unfortunately this is only a copy. It is not a move and the second columns
stays where it was. You can delete it by pressing OA-Y at the end of each line
of the first section.
Here's another scenario to separate two columns into one on a IIgs under Awks 5
with Ultra Macros:
Starting at the first letter of column 2, press OA-X and select a key for the
macro to begin recording. Do a Tab, then down, and OA-left. Press OA-X to end
recording.
Use the new 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. Copy the block and paste
it back on your word processor documant.
By: David Empson
Related FAQs Resources: R032MMAP128.TXT (Text file)
Continue to:
My Books
