« How to specify fieldname Not Equal To fieldname in an OpenOffice.org Base query | Main | How to get the "Do you want to print a form letter" checkbox back in OpenOffice.org Writer »

December 15, 2008

Comments

I cannot get it ~! Can you give a more detailed information?

Very useful, thank you.
I've just tried it out, and it works, but I've found a simpler way:

you can avoid replacing ", " with ",", and instead use ", " as separator in the Text to Columns (choose "Other" separator and type ", ", then check the "merge delimiters" box)

Very useful, thank you.
I've just tried it out, and it works, but I've found a simpler way:

you can avoid replacing ", " with ",", and instead use ", " as separator in the Text to Columns (choose "Other" separator and type ", ", then check the "merge delimiters" box)

Sorry for the duplicate

Maybe off-topic, but I thourght I would show a far more advanced way of 'find and replace'. I have used this technique a few times, for renaming hundreds of pictures: http://www.labnol.org/software/tutorials/rename-multiple-files-bulk-excel-googl-docs/2481/

This proposal of Andrea works properly only if the original text is perfectly formatted, if some records don't have the space they will be ignored and if others have double space, a single space will remain in front of the text. Best use the replace all, records with missing space will be ignored, run 'replace all' a second time, a third time to be sure, then convert.

This tip came at an appropriate time where I had a immediate need to utilize this instruction. Everything worked as directed. Thanks!!

Thanks for pointing out such a wonderful tool! I used the tedious method of copying the column, then deleting first names, individually, in the one column, then repeating for the next column. It was tedious with 125 names, but I was NOT going to do it for a 1600-name list!

What a time-saver! Thanks for being on top of this, and contributing.

Great tip. Cheers!

cheep wow goldworld of warcrft gold.

good, I like it.


I like the gold.

But you can buy AO credits

Without thinking I buy some game gold

Have you heared about a game which you need use Atlantica online Gold to play,

Do you know dofus kama?

good

i think it is good

Do you know the fiesta Gold, in the game you need the
fiesta money. It can help you increase your level. My friends always asked me how to
buy fiesta Gold, and I do not know he spend how much money to buy the
fiesta online gold, when I see him in order to play the game and search which the place can buy the
fiesta online money. I am happy with him.
Do you know the Darkfall Gold, in the game you need the Darkfall money. It can help you increase your level. My friends always asked me how to buy Darkfall Gold, and I do not know he spend how much money to buy the Darkfall Gold, when I see him in order to play the game and search which the place can buy the
cheap Darkfall gold. I am happy with him.

It is what I want to find out, thanks.

But the logical end case of that thought is that secondlife money about technology is never appropriate.

As a new player , you may need some game guides or information to enhance yourself.

Very good information about this post. The perfect custom written papers and the chance to buy essays about this topic is suggested by custom writing service.

The comments to this entry are closed.

GetOpenOffice Consulting

Get Book Resources

Search This Blog