Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - Finding & changing paragraph marks to tabs in a macro
Finding & changing paragraph marks to tabs in a macro
 
   NeoOffice Forum Index -> OpenOffice.org MacOS X X11 Support
View previous topic :: View next topic  
Author Message
blooper
Guest





PostPosted: Tue Mar 21, 2006 10:21 am    Post subject: Finding & changing paragraph marks to tabs in a macro

Hello Group,

I need help in creating a macro which would be able to convert (invisible) paragraph marks (lf) into tab marks so I can import the file into a database (FMP).

Using Tiger 10.4.5 on an iBook G4 & the latest version of NeoOffice with the latest patch.

Thanks for any assistance.

Blooper
Back to top
ovvldc
Captain Naiobi


Joined: Sep 13, 2004
Posts: 2352
Location: Zürich, CH

PostPosted: Tue Mar 21, 2006 10:36 am    Post subject: Re: Finding & changing paragraph marks to tabs in a macr

blooper wrote:
I need help in creating a macro which would be able to convert (invisible) paragraph marks (lf) into tab marks so I can import the file into a database (FMP).


Blooper, can you show us what you've got so far or is this a 'can someone please write me a macro' question?

It helps knowing where you are stuck.

Thanks,
Oscar

_________________
"What do you think of Western Civilization?"
"I think it would be a good idea!"
- Mohandas Karamchand Gandhi
Back to top
blooper
Red Pill


Joined: Mar 21, 2006
Posts: 5

PostPosted: Tue Mar 21, 2006 10:46 am    Post subject:

Oscar,

Thanks for your rapid response.

I'm completely new to NeoOffice.

I haven't yet tried to make a macro because I don't yet know how to find "invisible characters" - hope that's what they're called. My main problem is that Appleworks got rid of Macros in the upgrade needed for the osx & my classic environment keeps trashing.

Blooper
Back to top
jakeOSX
Ninja
Ninja


Joined: Aug 12, 2003
Posts: 1373

PostPosted: Tue Mar 21, 2006 11:45 am    Post subject:

if you want to poke through someone's code, the 'reveal codes' macro may be of some help.

also, there are macro writers who hang out in the oooforums.org

i did a quick look around (sorry no time for a long look) on the oo.o website, i think there should be info there (at least there _should_ be)
Back to top
yoxi
Cipher


Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon

PostPosted: Tue Mar 21, 2006 12:41 pm    Post subject:

Save yourself some time (unless you want to learn to macro) and use Iannz's Find & Replace - this extended find/replace macro allows you to find using regular expressions (including finding the various different flavours of line break you might find in an OOo doc), and replace them with tabs or whatever you like. It's good stuff, and recently updated.

- yoxi
Back to top
Guest






PostPosted: Tue Mar 21, 2006 12:57 pm    Post subject:

blooper, download and install the macro from
http://homepages.paradise.net.nz/hillview/OOo/

That should do the trick.
Back to top
blooper
Red Pill


Joined: Mar 21, 2006
Posts: 5

PostPosted: Wed Mar 22, 2006 8:04 am    Post subject:

Thanks everybody for your help.

I didn't realize that such a task would prove to be so difficult.

- Isn't there any way to simply find & replace the invisible characters (paragraph return & tab) through a micro like in Appleworks 6 or in Word ?

- If not, is there a way to do it manually, without a micro ?

Thanks again for your replies,

Bloop.
Back to top
Glenner
Oracle


Joined: Feb 03, 2004
Posts: 241
Location: Scotland

PostPosted: Wed Mar 22, 2006 8:36 am    Post subject:

yoxi wrote:
Save yourself some time (unless you want to learn to macro) and use Iannz's Find & Replace - this extended find/replace macro allows you to find using regular expressions (including finding the various different flavours of line break you might find in an OOo doc), and replace them with tabs or whatever you like. It's good stuff, and recently updated.

- yoxi


Did you try to use the above macro? It is in fact very straightforward to use and takes about 20 sec to install.

Without the macro there is no other way I know of to do what you want to do in NeoOffice. The reason is that this is not part of the underlying OpenOffice code. The next version of NeoOffice has extended features and functionality but I am not certain if the find and replace function is one of the them.
Back to top
yoxi
Cipher


Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon

PostPosted: Wed Mar 22, 2006 11:57 am    Post subject:

In case it's not clear what you need to do:
Click on the link above (mine or guest's, they're the same...) and scroll down the page that opens until you find Iannz's Find & Replace macro. Then you download that e.g. to your desktop, and you've got a doc called IannzFindReplace.sxw - open that doc in OOo and when it asks if you want to run the macro, say Yes.
This doc contains the macro, and is also the instructions on how to install it and use it. The installation instructions are on the last page. Note that there's a mistake in his instructions for installing it as a menu item - where he says:

3.In the category list box: Click the + next to “OpenOffice.org BASIC Macros” (towards bottom of list), the plus next to “IannzFindReplace”, then click “modIannzFindReplace”.
4.In the function list box: Click “IannzFindReplace”

what I've put in bold corrects the instructions.

- yoxi
Back to top
blooper
Red Pill


Joined: Mar 21, 2006
Posts: 5

PostPosted: Thu Mar 23, 2006 7:02 am    Post subject:

Thanks for the new responsers ...

I'd still like to know if there is a way to do manually what I need done.

If we forget the macro, is there a way I can find a tab & change it into a line feed (carriage return) ?

Thanks again,

Blooper
Back to top
Glenner
Oracle


Joined: Feb 03, 2004
Posts: 241
Location: Scotland

PostPosted: Thu Mar 23, 2006 7:47 am    Post subject:

Sorry, blooper. I may be missing something here. Initially you asked for help to put a macro together. Now that there is a macro readily available you do not want to use it. I don't want to be facetious but can you tell me what this is about?
Back to top
blooper
Red Pill


Joined: Mar 21, 2006
Posts: 5

PostPosted: Thu Mar 23, 2006 8:19 am    Post subject: Macro Confusion

Glenner wrote:
Sorry, blooper. I may be missing something here. Initially you asked for help to put a macro together. Now that there is a macro readily available you do not want to use it. I don't want to be facetious but can you tell me what this is about?


I'm sorry also, Glenner - thanks for your rapid response.

I don't want to install any new applications for the moment. All I want to do is to replace some invisible characters. I'm still trying to determine if I should use Neo Office; the answer to my question to the group will help me. In addition, I am losing precious time in getting this job done.

Hope this clears up the confusion.

Blooper.
Back to top
jakeOSX
Ninja
Ninja


Joined: Aug 12, 2003
Posts: 1373

PostPosted: Thu Mar 23, 2006 10:21 am    Post subject:

what kind of files are these?

if they are oo.o files, then the easiest thing to do will be to install the macro.

or, like i did with 'a mid summer's night dream' just do it manually.

if they are text, i could wip up a perl program to do it, but you'd need to know how to use a command line program.
Back to top
yoxi
Cipher


Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon

PostPosted: Thu Mar 23, 2006 10:25 am    Post subject:

Okay, all this talk of macros threw us all off the scent, I think. So you've got a text doc open in Writer which consists of

text lf text lf text etc. and you want to end up with
text tab text tab text etc.?

Yes, you can do that with OOo 2 straight out of the box:

• select the text to be searched (ctrl-A to select all of it)
• call up the Find & Replace dialogue - ctrl-F
• click on the More Options button, and then check the Regular Expressions box
• in the Search For field, put a $ (OOo regular expression-speak for para break)
• in the Replace With field, put a \t (OOo regular expression-speak for tab)
• hit the Replace All button and it's done

I hope this answers your deeper question, macros notwithstanding...

- yoxi
Back to top
blooper
Red Pill


Joined: Mar 21, 2006
Posts: 5

PostPosted: Thu Mar 23, 2006 10:45 am    Post subject:

Thanks, Guys - I'm going to try to do it manually, as suggested.

Sorry, again for the confusion but there are reasons why I opted for this method; I didn't want to bore all of you with my "personal" problems concerning adding applications. I'll certainly try the other suggestions when the situation permits it.

Blooper.
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> OpenOffice.org MacOS X X11 Support All times are GMT - 7 Hours
Goto page 1, 2  Next
Page 1 of 2

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.