Page 1 of 1

Find & Replace Wildcards?

PostPosted: Sun Aug 11, 2013 6:18 am
by elbraindead
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)

Re: Find & Replace Wildcards?

PostPosted: Sun Aug 11, 2013 10:52 am
by Hagar Delest
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.

Re: Find & Replace Wildcards?

PostPosted: Sun Aug 11, 2013 11:07 am
by RoryOF
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)?

Re: Find & Replace Wildcards?

PostPosted: Sun Aug 11, 2013 12:37 pm
by acknak
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.

Re: Find & Replace Wildcards?

PostPosted: Sun Aug 11, 2013 1:39 pm
by RoryOF
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.