Program to convert a row of words into a column? - with Jarte?
in [Freeware]
|
From: B. R. 'BeAr' Ederson on 1 Dec 2009 02:42 On Mon, 30 Nov 2009 23:06:17 -0800, JD wrote: > 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? I don't think, that I really understand the format of your source data from the above. (An example would probably help.) But the Calc menu "Data -> Text to Columns" is probably, what you're looking for. 1. Select the text *column* (single row) that contains the text, that shall go into columns. (2.) If the text is at the moment one row, but different columns, you need to use "Copy" + "Paste Special -> Transpose", before the next step. 3. Use "Data -> Text to Columns" and apply either "Separated by" with "Space" or "Fixed width" (whichever applies to your data). For the "Fixed width" data you have to click into the ruler of the preview box to define the separating points Done. There might be better ways to go. But I'd need some sample data, to understand your needs. As a sidenote: The other ways (Notepad++, Sed&Sort) I showed in my postings could probably also be adjusted, easily. If "Space" and not "Tab" is the separator, you'd need to adjust all occurrences of the separator char in both methods. > 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. If I understand that right, you'd might be better off, using the Calc VLOOKUP function, from the beginning... BeAr -- =========================================================================== = What do you mean with: "Perfection is always an illusion"? = ===============================================================--(Oops!)===
From: Johnw on 1 Dec 2009 03:54 JD formulated the question : > 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? Maybe one these will do the job. AlphaSort http://www.freewarefiles.com/program_8_154_25290.html Crimson Editor http://www.softpedia.com/get/Office-tools/Text-editors/Crimson-Editor.shtml http://www.softpedia.com/progScreenshots/Crimson-Editor-Screenshot-2977.html http://www.crimsoneditor.com/ - switch between column mode and line mode. (Alt+C) Metapad http://www.softpedia.com/get/Office-tools/Text-editors/metapad.shtml http://www.softpedia.com/progScreenshots/metapad-Screenshot-222.html http://www.liquidninja.com/metapad/ FAQ http://www.liquidninja.com/metapad/faq.html#Q28 * Go to Line/Column ConTEXT http://www.context.cx/ * normal and columnar text selection TED Notepad http://www.softpedia.com/get/Office-tools/Text-editors/TED-Notepad.shtml http://www.softpedia.com/progScreenshots/TED-Notepad-Screenshot-33407.html http://jsimlo.sk/notepad/ http://jsimlo.sk/notepad/manual/wiki/index.php/All_in_One/Tools TED Notepad Manual http://jsimlo.sk/notepad/manual/ * An ultimate text Sorting tool will help you to sort by anything. Sort by a specific column within a wide comma-separated list, or just sort lines simply as they are. Sort alphabetically or even as numbers. mEdit2007 http://www.softpedia.com/get/Office-tools/Text-editors/mEdit-by-macer.shtml http://www.softpedia.com/progScreenshots/mEdit-by-macer-Screenshot-83720.html One can also find worksheets matching specific meta data. The worksheets can be displayed in tab, column, or list style. In tab style, there are tabs at the lower part of the screen that allow switching between worksheets. In column style, a screen is divided into two, with the name of worksheets on the left-hand-side, and text editing area on the right. Subpad http://www.xtort.net/xtort/subpad.php column selection mode RJ TextEd http://www.softpedia.com/get/Programming/File-Editors/RJ-TextEd.shtml http://www.softpedia.com/progScreenshots/RJ-TextEd-Screenshot-30959.html http://www.rj-texted.se/index.html Portable RJ TextEd http://www.softpedia.com/get/PORTABLE-SOFTWARE/Office/Suites-editors/Portable-RJ-TextEd.shtml http://www.softpedia.com/progScreenshots/Portable-RJ-TextEd-Screenshot-113487.html Advanced column mode * Column mode: Column editing. Some wizards are available. Pipelines http://www.softpedia.com/get/Office-tools/Text-editors/Pipelines.shtml http://www.softpedia.com/progScreenshots/Pipelines-Screenshot-92016.html http://tenfiftytwo.co.uk/pipelines/ You can specify that only certain sections of a file are to be changed; you can confine those changes to a column, word or field range, translate words and phrases, discard or insert new lines of text. You can perform a whole range of operations on a file or files, using only a simple set of commands.
From: rich on 1 Dec 2009 08:14 On Tue, 01 Dec 2009 08:42:28 +0100, B. R. 'BeAr' Ederson wrote: > On Mon, 30 Nov 2009 23:06:17 -0800, JD wrote: > >> 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? > > I don't think, that I really understand the format of your source data > from the above. (An example would probably help.) But the Calc menu > "Data -> Text to Columns" is probably, what you're looking for. 1. > Select the text *column* (single row) that contains the text, that > shall go into columns. > (2.) If the text is at the moment one row, but different columns, you > need to use "Copy" + "Paste Special -> Transpose", before the next > step. > 3. Use "Data -> Text to Columns" and apply either "Separated by" with > "Space" or "Fixed width" (whichever applies to your data). For the > "Fixed width" data you have to click into the ruler of the preview > box to define the separating points > Done. > > There might be better ways to go. But I'd need some sample data, to > understand your needs. > As stated, difficult to advise when the format (tabs, table, commas, 'nothing') is unknown. I do not know Jarte but their web page says it exports in html. Easy to import in OoCalc. - 'Insert' -> 'Sheet from file' choose the .html file. Otherwise, is it possible to have both Jarte and OoCalc open and do a bit of copy and paste from one to the other? There is an option when pasting in OoCalc to choose 'space' as the separator. That would put each selection of word-pairs into separate columns. Providing something works, do the copy -> paste special -> transpose thing. Then export as an html file. If you open this html in OoWriter it should open as a table. Now use Table -> 'table to text' to lose the formating. Save as .rtf for Jarte. -- rich
From: Cousin Stanley on 1 Dec 2009 11:53 > .... > At present I have 2 rows and n columns > and I want to rotate them by 90 degrees > into 2 columns and n rows. I have a small python program that might be useful for this task .... python latff.py /path/to/some_file.txt Original .... now is the time for all good men to gobble up large quanties of HUGE Macs super sized with extra fries and tetse flies Transpose .... now to super is gobble sized the up with time large extra for quanties fries all of and good HUGE tetse men Macs flies # ------------------------------------------------------- The Original output above has been edited to compress some spaces for convenience posting here and is currently formatted for a nice display of words no longer than 8 characters each but that length can be easily changed to fit the max size of the items in the Original data set .... # ------------------------------------------------------- How it works .... Read a space separated list of items from a file into a list array, e.g. a python list of lists Transpose the rows and columns of the array Every row should have the same number of columns but the number of rows and columns do not have to be equal ... # ------------------------------------------------------ If you're interested, post a few rows of your data and I will test it locally here before uploading the program .... -- Stanley C. Kitching Human Being Phoenix, Arizona
From: JD on 2 Dec 2009 23:09 Johnw wrote: > JD formulated the question : >> 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? > > Maybe one these will do the job. > > AlphaSort > http://www.freewarefiles.com/program_8_154_25290.html > > Crimson Editor > http://www.softpedia.com/get/Office-tools/Text-editors/Crimson-Editor.shtml > http://www.softpedia.com/progScreenshots/Crimson-Editor-Screenshot-2977.html > > http://www.crimsoneditor.com/ > - switch between column mode and line mode. (Alt+C) > > Metapad > http://www.softpedia.com/get/Office-tools/Text-editors/metapad.shtml > http://www.softpedia.com/progScreenshots/metapad-Screenshot-222.html > http://www.liquidninja.com/metapad/ > FAQ > http://www.liquidninja.com/metapad/faq.html#Q28 > * Go to Line/Column > > ConTEXT > http://www.context.cx/ > * normal and columnar text selection > > TED Notepad > http://www.softpedia.com/get/Office-tools/Text-editors/TED-Notepad.shtml > http://www.softpedia.com/progScreenshots/TED-Notepad-Screenshot-33407.html > http://jsimlo.sk/notepad/ > http://jsimlo.sk/notepad/manual/wiki/index.php/All_in_One/Tools > TED Notepad Manual > http://jsimlo.sk/notepad/manual/ > * An ultimate text Sorting tool will help you to sort by anything. Sort > by a specific column within a wide comma-separated list, or just sort > lines simply as they are. Sort alphabetically or even as numbers. > > mEdit2007 > http://www.softpedia.com/get/Office-tools/Text-editors/mEdit-by-macer.shtml > http://www.softpedia.com/progScreenshots/mEdit-by-macer-Screenshot-83720.html > > One can also find worksheets matching specific meta data. The worksheets > can be displayed in tab, column, or list style. In tab style, there are > tabs at the lower part of the screen that allow switching between > worksheets. In column style, a screen is divided into two, with the name > of worksheets on the left-hand-side, and text editing area on the right. > > Subpad > http://www.xtort.net/xtort/subpad.php > column selection mode > > RJ TextEd > http://www.softpedia.com/get/Programming/File-Editors/RJ-TextEd.shtml > http://www.softpedia.com/progScreenshots/RJ-TextEd-Screenshot-30959.html > http://www.rj-texted.se/index.html > Portable RJ TextEd > http://www.softpedia.com/get/PORTABLE-SOFTWARE/Office/Suites-editors/Portable-RJ-TextEd.shtml > > http://www.softpedia.com/progScreenshots/Portable-RJ-TextEd-Screenshot-113487.html > > Advanced column mode * Column mode: Column editing. Some wizards are > available. > > Pipelines > http://www.softpedia.com/get/Office-tools/Text-editors/Pipelines.shtml > http://www.softpedia.com/progScreenshots/Pipelines-Screenshot-92016.html > http://tenfiftytwo.co.uk/pipelines/ > You can specify that only certain sections of a file are to be changed; > you can confine those changes to a column, word or field range, > translate words and phrases, discard or insert new lines of text. You > can perform a whole range of operations on a file or files, using only a > simple set of commands. Huge thanks everyone. This info is enough to swamp me for a week at least :-) Jarte is supposed to support rotating rows or columns but it complained about needing a certain dll file related to WordPad. I managed to find one but it was not acceptable to the program - possibly too old.
First
|
Prev
|
Pages: 1 2 3 Prev: PING: HUMMINGBIRD Next: alt.comp.freeware links at Mon Nov 30 21:20:02 2009 |