On 4/8/2006 8:55 PM, Rod Engelsman wrote:
Bob wrote:

That helped, thanks.


You're welcome!


Now the problem is how to use it. Again, no help, and I can't find anything at the sourceforge site. I assumed this macro would "parse" a line of text from one column into separate columns. Perhaps I was wrong about that.

Parsing text in a spreadsheet was a piece of cake in Lotus, which I used for years. I'm having difficulty adjusting to the differences in OOo Calc, so perhaps the ability to parse is already there, but I haven't found it.

Questions:
(1) Does Calc already contain the ability to parse a line of text in a column into multiple columns, i.e., citystatezip into city, state, zip?


It will do that in the process of importing a text file like a csv. A dialog will come up that allows you to specify the field delimiter, text delimiter, or fixed column lengths. The Text-to-column macro seems to use the same dialog.


(2) If not, does Text2Column accomplish that (based on the originally quoted material, I think it does), and how is it used to do it?


Just select the column you want to parse and go to Tools -> Add-Ons -> Text to Columns.

If you're wanting to do something more complex, like extract the city, state, and zip code from a field that looks like "Phillipsburg, KS 67661", then you will need to play with the text functions, left(), right(), mid(), find(), etc.

It works! Thanks again.

I did use Find and Replace to add commas (for a field delimiter) between city state zip where there weren't any, but that was easy and the result was three columns with city, state and zip in each column.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to