change-column-case
Convert the case of text values in a column (e.g. UPPERCASE, lowercase, camelCase, hyphen-case, etc)
Last updated
Convert the case of text values in a column (e.g. UPPERCASE, lowercase, camelCase, hyphen-case, etc)
Last updated
For a column in a datatable, change the case to one of the supported case patterns. The changed text can either overwrite the original text in the column OR be placed in a different column.
data
: The input datatable
column
: The column with text you want to convert to a different case
case
: The case pattern you want for your converted text (see options in "Supported case patterns" below)
target
: The name of the column to contain the converted case (if you want the output to be in a separate column from the source noted in the "column" argument)
output
: datatable with converted case (either in the same column it came from or a new target column)
This table shows available case options.
Case | Example | Description |
---|---|---|
camel | thisIsCamelCase | first letter of each word is uppercase except very first letter |
constant | THIS_IS_CONSTANT_CASE | upper case string with an underscore between words. |
dot | this.is.dot.case | lower case string with a period between words |
hyphen | this-is-hyphen-case | same as kebab |
header | This-Is-Header-Case | like kebab and hyphen but with uppercase first letters |
kebab | this-is-kebab-case | same as hyphen |
lower | thisislowercase | all lowercase |
lowerfirst | HELLO becomes hELLO | changes the first character to lowercase |
no | this is no case | lowercase with spaces between words |
param | version 1.2.10 becomes version-1-2-10 | lower case string with a hyphen between words |
pascal | ThisIsPascalCase | first letter of each word is uppercase |
path | this/is/path/case | lowercase with slash between words |
sentence | This is sentence case | only the first letter is uppercase |
snake | this_is___snake_case | lowercase string with underscores between words |
swap | SWAPcase becomes swapCASE | uppercase become lowercase and lowercase become uppercase |
title | This Is the Way Titlecase Looks | most words have uppercase first letter |
upper | THISISUPPERCASE | all uppercase |
upperfirst | hello becomes Hello | changes the first character to uppercase |
Standardizing values in a column as a harmonization step (e.g. change "uk" to be "UK")
Making text values easier to read.