Prev: PING: HUMMINGBIRD
Next: alt.comp.freeware links at Mon Nov 30 21:20:02 2009
From: JD on 30 Nov 2009 15:03
JD wrote:
> Bill Day wrote:
>> On Sun, 29 Nov 2009 22:38:13 -0800, JD <JD(a)NoDen.con> wrote:
>>
>>> Hi Experts,
>>>
>>> I am using Jarte to set up pairs of words and need to convert rows
>>> into columns - one at a time is ok. I don't see any way to do that in
>>> Jarte. Can it be done? If not, I guess I could set up and try Open
>>> Office.
>>>
>>> Thoughts?
>>>
>>> TIA
>> 'Columnizer'
>> http://www.aplusfreeware.com/misc/Columnizer/Columnizer.html
>>
>> does many tricks that are hard in other programs.
>
> My thanks to everyone who responded.
>
> I should have been more specific. At present I have 2 rows and n columns
> and I
> want to rotate them by 90 degrees into 2 columns and n rows.
>
> Will try your Columnizer Bill. Thanks for the suggestion.

It appears to be a useful program but there are NO
instructions available.
I first tried to Insert a Column and I was able to
paste the row into the slot
"Insert this column of data - - - - - - - - - -
at column position 1" It copied the row from the
slot and pasted it into the first row in the area
underneath where the data are supposed to be
assembled. I tried several other possibilities and
can find no way to rotate that row into a column.
From: B. R. 'BeAr' Ederson on 30 Nov 2009 15:21
On Mon, 30 Nov 2009 10:51:44 -0800, JD wrote:

> I should have been more specific. At present I
> have 2 rows and n columns and I
> want to rotate them by 90 degrees into 2 columns
> and n rows.

Although this can be scripted by command line text editing tools, it
will be easier for you to just use OpenOffice Calc.
1. Insert the text the way it is, at the moment
2. Select it and "Cut" it to the clipboard
3. Clear the selection and place cursor to the upper left target cell
4. Use "Transpose" from "Edit > Paste Special" menu
Done.

You also can use the Notepad++ editor:
1. Insert the text the way it is, at the moment
2. Replace all tabs (or whatever delimiter char your text has) with
line feeds (Use "Extended" mode inside the Replace dialog and search
for "\t" and replace by "\n" - without quotation marks, of course)
3. Scroll down to the lower half of the text and select all rows that
shall go to the second column in Box mode (select with dragging left
mouse key while Alt key is pressed; be careful to make the selection
wide enough, e.g. select enough characters to fit the longest row)
4. Cut the selection to clipboard
5. Append enough whitespace to the first row, that the cursor is at
least one column more to the right than the longest text from the
*real* first column of your text
6. Paste text
7. Delete superfluous rows from end of the file
8. If you want separated rather then fixed width columns, fire up the
special Find/Replace dialog (Strg+r)
9. Set column to one that is in-between both text columns, e.g. "24-24",
if 24 is the column you would like to use
10. Search for a space char and replace by whatever separator you like
11. Use whatever method you like to kill unnecessary whitespace
(Notepad++ provides several...)
Done.

HTH.
BeAr
--
===========================================================================
= What do you mean with: "Perfection is always an illusion"? =
===============================================================--(Oops!)===
From: B. R. 'BeAr' Ederson on 30 Nov 2009 16:42
Following myself up:

> On Mon, 30 Nov 2009 10:51:44 -0800, JD wrote:
>
>> I should have been more specific. At present I
>> have 2 rows and n columns and I
>> want to rotate them by 90 degrees into 2 columns
>> and n rows.
>
> Although this can be scripted by command line text editing tools
[Snip]

Just in case someone wants to try, a quick and dirty sed/sort variant:

2 Rows to 2 columns (from a.txt to c.txt; b.txt can be deleted):
| sed "s/\t/\n/g;q" a.txt | sed = | sed "N; s/^/ /; s/ *\(.\{3,\}\)\n/\1a /" > b.txt
| sed -e "/./!d" -e "1d;s/\t/\n/g" a.txt | sed = | sed "N; s/^/ /; s/ *\(.\{3,\}\)\n/\1b /" >> b.txt
| sort b.txt | sed "s/^.\{5\}//" | sed "/$/N;s/\n/\t/" > c.txt

And back again (from c.txt to d.txt):
| sed -e :a -e "s/\t[^\t]\{1,\}$//;/$/N;s/\n/\t/;ta" c.txt > d.txt
| sed -e :a -e "s/[^\t]\{1,\}\t\([^\t]\{1,\}\)$/\1/;/$/N;s/\n/\t/;ta" c.txt >> d.txt

Have fun! ;-)
BeAr
--
===========================================================================
= What do you mean with: "Perfection is always an illusion"? =
===============================================================--(Oops!)===
From: JD on 30 Nov 2009 23:29
hummingbird wrote:
> 'JD' wrote thus:
>> It appears to be a useful program but there are NO
>> instructions available.
>> I first tried to Insert a Column and I was able to
>> paste the row into the slot
>> "Insert this column of data - - - - - - - - - -
>> at column position 1" It copied the row from the
>> slot and pasted it into the first row in the area
>> underneath where the data are supposed to be
>> assembled. I tried several other possibilities and
>> can find no way to rotate that row into a column.
>
> Try the download page, it has an explanation of each function
> and what each button means/does.

Good try H but:

I looked at all the diagrams and there is none
that shows a row
being rotated into a column
From: JD on 1 Dec 2009 02:06
B. R. 'BeAr' Ederson wrote:
> On Mon, 30 Nov 2009 10:51:44 -0800, JD wrote:
>
>> I should have been more specific. At present I
>> have 2 rows and n columns and I
>> want to rotate them by 90 degrees into 2 columns
>> and n rows.

Thank you B.R. for your efforts.
I managed to get it done for a row but the
disadvantage is that I have
to write every word in one of the columns to start
with. My big task has
the words in column format in a text file and I
need to take some of them
a few hundred at a time. Do you know of any method
for forcing the
words into a Calc column?

On the other hand, I could rotate the text column
to a row, translate it to another
language and then rotate the pair back to the
vertical again. When they are back
to a text file again, a comma needs to separate
the words in the two columns.

I hope you can make more sense of this than I can
right now :-)

Thanks again for your help.

> Although this can be scripted by command line text editing tools, it
> will be easier for you to just use OpenOffice Calc.
> 1. Insert the text the way it is, at the moment
> 2. Select it and "Cut" it to the clipboard
> 3. Clear the selection and place cursor to the upper left target cell
> 4. Use "Transpose" from "Edit > Paste Special" menu
> Done.
>
> You also can use the Notepad++ editor:
> 1. Insert the text the way it is, at the moment
> 2. Replace all tabs (or whatever delimiter char your text has) with
> line feeds (Use "Extended" mode inside the Replace dialog and search
> for "\t" and replace by "\n" - without quotation marks, of course)
> 3. Scroll down to the lower half of the text and select all rows that
> shall go to the second column in Box mode (select with dragging left
> mouse key while Alt key is pressed; be careful to make the selection
> wide enough, e.g. select enough characters to fit the longest row)
> 4. Cut the selection to clipboard
> 5. Append enough whitespace to the first row, that the cursor is at
> least one column more to the right than the longest text from the
> *real* first column of your text
> 6. Paste text
> 7. Delete superfluous rows from end of the file
> 8. If you want separated rather then fixed width columns, fire up the
> special Find/Replace dialog (Strg+r)
> 9. Set column to one that is in-between both text columns, e.g. "24-24",
> if 24 is the column you would like to use
> 10. Search for a space char and replace by whatever separator you like
> 11. Use whatever method you like to kill unnecessary whitespace
> (Notepad++ provides several...)
> Done.
>
> HTH.
> BeAr
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: PING: HUMMINGBIRD
Next: alt.comp.freeware links at Mon Nov 30 21:20:02 2009