Datenschutz

mmi consult - tipps und tricks blog

Äquivalent zu Makroformeln

 5.0 

@ReplaceSubstring in LotusScript

Michael Siegrist  14 Dezember 2001 16:45:30

Function searchReplace(startString As String, searchString As String, replaceString As String) As String 'just in case a non-string value was passed On Error Resume Next .. mehr

 5.0 

R5 LotusScipt - @Formel äquivalenzen

Admin Siegrist  29 September 2001 13:17:12

Formelsprache LotusScript @Trim(Array) FullTrim(Array) @Trim(String) FullTrim(String) ("A" = "B":"A") (StrGetIndex(L,S)=Null) @Left("ABC";"B") STRLeft @Right("ABC";"B") STRRight .. mehr

 4.x 

Ersatz von @Explode

Manfred Meise  4 April 2001 12:52:21

Function explode (Byval inString As String, OutList() As String, delim As String) 'This function takes a text field and splits the values into members of an array, based on the value passed as de .. mehr

 4.x 

Ersatz von @Left

Manfred Meise  4 April 2001 12:52:21

Function Left (sourceString As String, searchString As String) As String pos% = Instr(sourceString, searchString) If pos% 0 Then pos% = pos% -1 Left = Left(sourceString, p .. mehr

 4.x 

Ersatz von @LeftBack

Manfred Meise  4 April 2001 12:52:21

Function LeftBack (sourceString As String, searchString As String) As String For i% = Len(sourceString) To 1 Step -1 sourceStringBack$=sourceStringBack$ & Mid(sourceString, i%, .. mehr

 4.x 

Ersatz von @Right

Manfred Meise  4 April 2001 12:52:21

Function Right (sourceString As String, searchString As String) As String pos% = Instr(sourceString, searchString) length% = Len(sourceString) start% = length% - pos% .. mehr

 4.x 

Ersatz von @RightBack

Manfred Meise  4 April 2001 12:52:21

Function RightBack (sourceString As String, searchString As String) As String For i% = Len(sourceString) To 1 Step -1 sourceStringBack$=sourceStringBack$ & Mid(sourceString, i%, .. mehr

 4.x 

Ersatz von @Word

Manfred Meise  4 April 2001 12:52:21

Function Word (sourceString As String, separator As String, number As Integer) As String searchString$=SourceString & separator ' add one separator to catch also the last substring .. mehr

 4.x 

Konvertieren Array zu Zeichenkette (vergl. @Implode)

Manfred Meise  4 April 2001 12:52:21

Function Implode( valueToImplode, Seperator As String) As String '=== Returns the value of the list or array imploded into a single string using separator '--- If not array or list then quit .. mehr

 4.x 

Konvertieren Zeichenketten zu Arrays(vergl. @Explode)

Manfred Meise  4 April 2001 12:52:21

Function Explode( valueToExplode As String, Seperator As String) As Variant '=== Gets the ValueToAdd and uses the Seperator as the '=== delimiter to populate the Strings Array Dim Strings .. mehr