`goodcolname(X)`

Returns a boolean value indicating whether a given string would be a valid/recommended column name. (Available as of version 11.25)

Syntax

goodcolname(X)

Input

Argument	Type	Description
`X`	text	The string on which to apply the function A scalar value or the name of a column

Return Value

Returns a boolean value indicating whether X would be a valid/recommended column name (i.e., begins with a lowercase letter; contains only lowercase letters, digits, and/or underscores; and does not end with an underscore).

Note that X is not checked as to whether it actually refers to any existing object. See Object functions for functions that can be used to check the existence, type, and accessibility of objects on the 1010data Insights Platform.

Example

In the following example, the column good_col_bad_col shows the results of goodcolname(X) applied to the column names in the inline <table>.

<table cols="names">
  good_col;
  BAD_COL;
  thisisNOTvalid;
  000000h_no;
  thisoneisakeeper;
</table>
<col name="names" format="width:20"/>
<willbe name="good_col_bad_col" value="goodcolname(names)"/>