`goodname(X)`

Returns a boolean value indicating whether a given string would be a valid name for a table, folder, or query. (Available as of version 10.23)

Syntax

goodname(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 name for a table, folder, or query (i.e., begins with a letter and contains only letters, digits, and/or underscores).

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_name_bad_name shows the results of goodname(X) applied to the column names in the inline <table>.

<table cols="names">
  good_name;
  ALSO_GOOD;
  thisIS*not*valid;
  000000h_no;
  thisoneisakeeper;
</table>
<col name="names" format="width:20"/>
<willbe name="good_name_bad_name" value="goodname(names)"/>