Hello!
Please, what is happening in this function? (what is the result?)
Dim MyString As String
MyString = "This was my text"
Mid(MyString, 6, 3, "is")
Many thanks!
I tried to write it in sub in writer, but got error, so I dont’t know what is wrong…
I tried as mahfiaz said before I piosted it, but got error…
Karolus, I appologise, had some technical problems in a hurry! Hope I managetd it now!
You just let the MID() function calculate the new value, but then you do nothing with it: Mid(MyString, 6, 3, "is")
To see the value or use it somewhere you need to assign it to a variable, e.g MyString = MID(...) and MsgBox(MyString)
Hello!
I wrote:
sub x
Dim Mystring As String
Mystring="This was my text"
print Mid(Mystring, 6, 3, "is")
end sub
Please, tell me if it is marked as code correctly, I clicked 101 010, but have some problems on the screen
Hey, you finally convinced me to try it out. Looks like MID() statement (as wiki puts it, Mid Function, Mid Statement [Runtime] - LibreOffice Help) does not work and returns empty string. Please write a bug report about this and post a link here as well. In the meantime you could do:
Mystring = "This was my text"
Mystring = Left(Mystring, 5) & "is" & Right(Mystring, Len(Mystring) - 6 - 2)