...
| Excerpt | ||||
|---|---|---|---|---|
Returns
|
...
Output: Returns true if the first three letters of the FullName column value are "Mr.".
example:d-s-itemlang item pattern
| D lang syntax | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
startswith(CustId,`{alpha-numeric}{6}`) |
Output: Returns true if the CustId column begins with a six-digit alpha-numeric sequence. Otherwise, the value is set to false.
Regular expression pattern exampleexpression example:
| D lang syntax | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
if(startswith(phone,/^(\+0?1\s)?\(?\d{3}\)?[\s.-]\d{3}[\s.-]\d{4}$/),'phone - ok','phone - error') |
...
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | Column reference | myColumn |
pattern
| d-s-itemlang | ||
|---|---|---|
|
...
