Open Office replace()

Question

does Open Office BASIC support function replace(string,search string, replace with)?

with these tags no one will ever notice this question. Try to add other tags — UnDiUdin, Oct 18 '11 at 10:44

score 0 · Answer 1 · answered Jun 18 '12 at 21:11

0

Yes, Open Office BASIC supports this function, but be aware it is not case sensitive.

answered Jun 18 '12 at 21:11

amens

125
1
11

bernard paulus · Answer 2 · 2022-12-01T21:07:05.297

Yes, the function is SUBSITUTE(input, search_text, replace_text[, occurrence])

Examples:

input                                         | result
----------------------------------------------+-----------------
=SUBSTITUTE("nyan cat cat","cat","nyan!")     | nyan nyan! nyan!
=SUBSTITUTE("nyan cat cat","cat","nyan!", 1)  | nyan nyan! cat
=SUBSTITUTE("nyan cat cat","cat","nyan!", 2)  | nyan cat nyan!

Here is the official documentation

score -1 · Answer 3 · edited Sep 25 '12 at 13:05

Replaces part of a text string with a different text string. Syntax:

REPLACE(originaltext; startposition; length; newtext)

in originaltext, removes length characters beginning at character startposition, replaces them with newtext, and returns the result.

startposition and length must be 1 or more.

Example:

REPLACE("mouse"; 2; 3; "ic")

returns mice. Beginning at character position 2, 3 characters (ous) are removed and replaced by ic.

Open Office replace()

3 Answers3