dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start [2021/05/01 21:43] nick ↷ Page moved from dido:public:s_cli:05_contents:03_langconst:operations to dido:public:s_cli:05_contents:01_prt:03_langconst:operations |
dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start [2021/07/26 11:53] (current) murphy [UpperCase] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== 2.2.4 Operations ====== | + | ====== 3.4 Operations ====== |
| [[dido:public:s_cli:05_contents:01_prt:02_basics:start| Return to DIDO CLI Background]] | [[dido:public:s_cli:05_contents:01_prt:02_basics:start| Return to DIDO CLI Background]] | ||
| ===== CamelCase ===== | ===== CamelCase ===== | ||
| - | [[dido:public:s_cli:05_contents:03_langconst:operations| Return to Top]] | + | [[dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start| Return to Top]] |
| **CamelCase** strips leading and trailing blanks, converts multiple whitespace characters to a single space, converts the text to LowerCase and then Uppercases the first letter of each word. | **CamelCase** strips leading and trailing blanks, converts multiple whitespace characters to a single space, converts the text to LowerCase and then Uppercases the first letter of each word. | ||
| Line 22: | Line 22: | ||
| ===== camelCase ===== | ===== camelCase ===== | ||
| - | [[dido:public:s_cli:05_contents:03_langconst:operations| Return to Top]] | + | [[dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start| Return to Top]] |
| **camelCase** performs the **CamelCase** operation and then lowercases the first letter. | **camelCase** performs the **CamelCase** operation and then lowercases the first letter. | ||
| Line 40: | Line 40: | ||
| ===== CompressWhiteSpace ===== | ===== CompressWhiteSpace ===== | ||
| - | [[dido:public:s_cli:05_contents:03_langconst:operations| Return to Top]] | + | [[dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start| Return to Top]] |
| **CompressWhiteSpace** converts multiple spaces within the text to a single space. It does not remove leading or trailing spaces. | **CompressWhiteSpace** converts multiple spaces within the text to a single space. It does not remove leading or trailing spaces. | ||
| Line 59: | Line 59: | ||
| ===== CurrentDate ===== | ===== CurrentDate ===== | ||
| - | [[dido:public:s_cli:05_contents:03_langconst:operations| Return to Top]] | + | [[dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start| Return to Top]] |
| - | **CurrentDate** returns the current date from the system clock using [[dido:public:ra:xapend:xapend.b_stds:tech:iso:date_time_1]]. See [[dido:public:s_cli:05_contents:03_langconst:types#datetimevalue| DateTimeVAlue]] | + | **CurrentDate** returns the current date from the system clock using [[dido:public:ra:xapend:xapend.b_stds:tech:iso:date_time_1]]. See [[dido:public:s_cli:05_contents:01_prt:03_langconst:05_types:start#datetimevalue| DateTimeVAlue]] |
| <code> | <code> | ||
| Line 79: | Line 79: | ||
| ===== CurrentTime ===== | ===== CurrentTime ===== | ||
| - | [[dido:public:s_cli:05_contents:03_langconst:operations| Return to Top]] | + | [[dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start| Return to Top]] |
| - | **CurrentTime** returns the current time from the system clock. See [[dido:public:s_cli:05_contents:03_langconst:types#timestampvalue| TimestampValue]]. | + | **CurrentTime** returns the current time from the system clock. See [[dido:public:s_cli:05_contents:01_prt:03_langconst:05_types:start#timestampvalue| TimestampValue]]. |
| <code> | <code> | ||
| Line 97: | Line 97: | ||
| ===== IsNull ===== | ===== IsNull ===== | ||
| - | [[dido:public:s_cli:05_contents:03_langconst:operations| Return to Top]] | + | [[dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start| Return to Top]] |
| **IsNull** tests if the parameter passed is has no value (i.e., '''NULL'''). | **IsNull** tests if the parameter passed is has no value (i.e., '''NULL'''). | ||
| Line 124: | Line 124: | ||
| ===== Length ===== | ===== Length ===== | ||
| - | [[dido:public:s_cli:05_contents:03_langconst:operations| Return to Top]] | + | [[dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start| Return to Top]] |
| **Length** returns the number of characters in the TextValue. **Note:** if the TextValue is NULL, **Lenght** returns a minus 1 (i.e., ''-1''). | **Length** returns the number of characters in the TextValue. **Note:** if the TextValue is NULL, **Lenght** returns a minus 1 (i.e., ''-1''). | ||
| Line 150: | Line 150: | ||
| ===== LowerCase ===== | ===== LowerCase ===== | ||
| - | [[dido:public:s_cli:05_contents:03_langconst:operations| Return to Top]] | + | [[dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start| Return to Top]] |
| **LowerCase** converts the text to LowerCase, it does not modify the whitespace. | **LowerCase** converts the text to LowerCase, it does not modify the whitespace. | ||
| Line 170: | Line 170: | ||
| ===== PadC ===== | ===== PadC ===== | ||
| - | [[dido:public:s_cli:05_contents:03_langconst:operations| Return to Top]] | + | [[dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start| Return to Top]] |
| **PadC** centers the TextValue within the given padding length. If the length of the Text string is longer than the padding length, the left and right characters are trimmed equally until it fits. | **PadC** centers the TextValue within the given padding length. If the length of the Text string is longer than the padding length, the left and right characters are trimmed equally until it fits. | ||
| Line 191: | Line 191: | ||
| ===== NVL ===== | ===== NVL ===== | ||
| - | [[dido:public:s_cli:05_contents:03_langconst:operations| Return to Top]] | + | [[dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start| Return to Top]] |
| The **NVL** operations evaluates the two parameters passed to it. If the first value is NOT NULL, then the first value is returned. If the first value is NULL, then the second value is returned. | The **NVL** operations evaluates the two parameters passed to it. If the first value is NOT NULL, then the first value is returned. If the first value is NULL, then the second value is returned. | ||
| Line 211: | Line 211: | ||
| ===== PadL ===== | ===== PadL ===== | ||
| - | [[dido:public:s_cli:05_contents:03_langconst:operations| Return to Top]] | + | [[dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start| Return to Top]] |
| **PadL** pads the TextValue to the left until the padding length is met. If the padding length is smaller than the length of the TextValue, characters are trimmed on the left until it fits. | **PadL** pads the TextValue to the left until the padding length is met. If the padding length is smaller than the length of the TextValue, characters are trimmed on the left until it fits. | ||
| Line 231: | Line 231: | ||
| </code> | </code> | ||
| ===== PadR ===== | ===== PadR ===== | ||
| - | [[dido:public:s_cli:05_contents:03_langconst:operations| Return to Top]] | + | [[dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start| Return to Top]] |
| **PadR** pads the TextValue to the right until the padding length is met. If the padding length is smaller than the length of the TextValue, characters are trimmed on the right until it fits. | **PadR** pads the TextValue to the right until the padding length is met. If the padding length is smaller than the length of the TextValue, characters are trimmed on the right until it fits. | ||
| Line 251: | Line 251: | ||
| ===== TitleCase ===== | ===== TitleCase ===== | ||
| - | [[dido:public:s_cli:05_contents:03_langconst:operations| Return to Top]] | + | [[dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start| Return to Top]] |
| **TitleCase** converts the text to LowerCase, it does not modify the whitespace. | **TitleCase** converts the text to LowerCase, it does not modify the whitespace. | ||
| Line 271: | Line 271: | ||
| ===== Trim ===== | ===== Trim ===== | ||
| - | [[dido:public:s_cli:05_contents:03_langconst:operations| Return to Top]] | + | [[dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start| Return to Top]] |
| - | **Trim** trims all leading and trailing [[dido:public:s_cli:05_contents:03_langconst:constants#whitespace]] from the line. | + | **Trim** trims all leading and trailing [[dido:public:s_cli:05_contents:01_prt:03_langconst:06_constants:start#whitespace]] from the line. |
| <code> | <code> | ||
| Line 290: | Line 290: | ||
| ===== TrimL ===== | ===== TrimL ===== | ||
| - | [[dido:public:s_cli:05_contents:03_langconst:operations| Return to Top]] | + | [[dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start| Return to Top]] |
| - | Trims all leading (i.e., left side) [[dido:public:s_cli:05_contents:03_langconst:constants#whitespace]] from the line. | + | Trims all leading (i.e., left side) [[dido:public:s_cli:05_contents:01_prt:03_langconst:06_constants:start#whitespace]] from the line. |
| - | [[dido:public:s_cli:05_contents:03_langconst:operations| Return to Top]] | + | [[dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start| Return to Top]] |
| - | **TrimL** trims all leading [[dido:public:s_cli:05_contents:03_langconst:constants#whitespace]] from the line. | + | **TrimL** trims all leading [[dido:public:s_cli:05_contents:01_prt:03_langconst:06_constants:start#whitespace]] from the line. |
| Line 314: | Line 314: | ||
| </code> | </code> | ||
| ===== TrimR ===== | ===== TrimR ===== | ||
| - | [[dido:public:s_cli:05_contents:03_langconst:operations| Return to Top]] | + | [[dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start| Return to Top]] |
| - | **TrimR** trims all trailing [[dido:public:s_cli:05_contents:03_langconst:constants#whitespace]] from the line. | + | **TrimR** trims all trailing [[dido:public:s_cli:05_contents:01_prt:03_langconst:06_constants:start#whitespace]] from the line. |
| <code> | <code> | ||
| Line 323: | Line 323: | ||
| ===== UpperCase ===== | ===== UpperCase ===== | ||
| - | [[dido:public:s_cli:05_contents:03_langconst:operations| Return to Top]] | + | [[dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start| Return to Top]] |
| - | **UpperCase** converts all the ASCII characters to their Uppercase equivalents. | + | **UpperCase** converts all the [[dido:public:ra:xapend:xapend.a_glossary:a:ascii|ASCII]] characters to their Uppercase equivalents. |
| <code> | <code> | ||
| Line 341: | Line 341: | ||
| </code> | </code> | ||
| ===== WhiteSpaceToUnderscore ===== | ===== WhiteSpaceToUnderscore ===== | ||
| - | [[dido:public:s_cli:05_contents:03_langconst:operations| Return to Top]] | + | [[dido:public:s_cli:05_contents:01_prt:03_langconst:04_operations:start| Return to Top]] |
| **WhiteSpaceToUnderscore** converts all whitespace characters to underscores ('''_'''). | **WhiteSpaceToUnderscore** converts all whitespace characters to underscores ('''_'''). | ||
dido/public/s_cli/05_contents/01_prt/03_langconst/04_operations/start.1619919780.txt.gz · Last modified: 2021/05/01 21:43 by nick
