Find & Replace Wildcards?

Not sure where to post? Post here!

Find & Replace Wildcards?

Postby elbraindead » Sun Aug 11, 2013 6:18 am

I need to find & replace a number (ej: 100004) for a consecutive ascending sequence figure (ej: 100004 / 100005 / 100006 and so on).
I found that i can find any sequence of numbers with 6 digits (or more, but i need fixing a 6 digit) in the "find" slot by typing "[0-9][0-9][0-9][0-9][0-9][0-9]" but i cant seem to fill the "REPLACE" slot correctly so that the program replaces the 6 digit number for an ascending consecutive sequence.
Can anyone help me with this?

(sorry for my poor english its not my first language)
OpenOffice 3.4 on Windows 7
elbraindead
 
Posts: 1
Joined: Sun Aug 11, 2013 6:07 am

Re: Find & Replace Wildcards?

Postby Hagar Delest » Sun Aug 11, 2013 10:52 am

Hi and welcome to the forum!

You've posted in the Beginner section, it may help to know if you're working with Writer or Calc.
AOO 4.1.7 on Xubuntu 19.10 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28679
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Find & Replace Wildcards?

Postby RoryOF » Sun Aug 11, 2013 11:07 am

Also, do you wish to find and change the sequence into a different sequence (i.e., from 100004, 100005.... 100008 to say 876001, 876002... 876005)?
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 30406
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Find & Replace Wildcards?

Postby acknak » Sun Aug 11, 2013 12:37 pm

elbraindead wrote:... i cant seem to fill the "REPLACE" slot correctly so that the program replaces the 6 digit number for an ascending consecutive sequence. ...

Sorry, this is not possible with Find & Replace in OO. You would need to use an arithmetic expression in the replacement, and that is not supported.

If you are working in a Calc spreadsheet, you can do it easily, just not by Find & Replace. In Writer, not so easily--maybe by replacing the numbers with a "number range" field.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Find & Replace Wildcards?

Postby RoryOF » Sun Aug 11, 2013 1:39 pm

If you wish to replace a sequence, provided the last digits are the same, you could find the first digits and replace them, leaving the last.
So 100004 could replace to 876004 etc.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 30406
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland


Return to Beginners

Who is online

Users browsing this forum: No registered users and 4 guests