TOP

Kebab Case Function for LibreOffice Calc

KEBABCASE() Description

The KEBABCASE() function is designed to combine words using a hyphen, i.e. a single word is returned as a result, e.g. «kebab-case-function» .

Kebab Case splits a string of words separated by spaces, hyphens, underscores, or case changes, then converts those words to lowercase and joins them with a hyphen separator ("-").

The KEBABCASE() function can be useful in programming to convert variable names according to accepted code writing conventions (coding conventions) .


StarBASIC code for function Kebab Case

Here is the macro code to create a custom function that can convert text to individual words separated by hyphens (Kebab Case) in LibreOffice Calc.

Open the menu Tools - Macros - Edit Macros..., select Module1 and copy the following text into the module:

Function KebabCase(ByVal str As String) As String  
  'moonexcel.com.ua
  Dim words As Variant  
  Dim FCalc As Object
  
  FCalc = CreateUnoService("com.sun.star.sheet.FunctionAccess")
  
  str = Replace(str,"-"," ")
  str = Replace(str,"_"," ")  
  str = FCalc.callFunction("TRIM", Array(str))  
  str = FCalc.callFunction("REGEX", Array(str,"([:lower:])([:upper:])","$1 $2","g"))
      
  str   = LCase(str)  
  words = Split(str," ")              
      
  KebabCase = Join(words,"-")  
End Function

Then close Macro Editor, return to LibreOffice Calc and use our new function in any cell.

Using the extension

You can also use the feature KEBABCASE() by installing the free extension YouLibreCalc.oxt or its full-featured version YLC_Utilities.oxt .

After that, this function will be available in all files that will be opened in LibreOffice Calc.