[Solved] Function SUBSTITUTE not working

[philipps]

Dear All,

trying the SUBSTITUTE function gives me an error, although i got it from the docu (https://wiki.openoffice.org/wiki/Docume ... E_function)

The error messages says: "Your placement of parentheses is wrong"

As you can see I use OpenOffice calc 4.1.5. on MAC.

Thanks in advance for any help

[FJCC]

SUBSTITUTE is a spreadsheet function, not an OpenOffice Basic function. Can you explain more about what you are trying to do?

[philipps]

Oh, that's too bad.

I wanna replace all the spaces inside a string. Whilst Trim () removes spaces vom beginning and end, i need to remove all the spaces inside the string:

"how are you" -> "howareyou"

any basic function for that?

[philipps]

The function is called REPLACE with same arguements in Basic. Sorry for bothering.

[Zizi64]

Otherwise you can call the Cell functions from the Basic:

Code: Select all

Function MySubstitute2(sText1 as string, sText2 as string, sText3 as string) as string

	FuncAcc = createunoservice("com.sun.star.sheet.FunctionAccess")
	sResult=FuncAcc.callFunction("SUBSTITUTE", array(sText1,sText2,sText3))
	
 MySubstitute2 = sResult
End function