4 releases (2 breaking)
| 0.3.0 | Aug 27, 2023 |
|---|---|
| 0.2.0 | Aug 19, 2023 |
| 0.1.1 | Jul 25, 2023 |
| 0.1.0 | Jul 25, 2023 |
#4 in #false
34KB
676 lines
Dala Formula Language
The Dala Formula Language is a light weight language, that is heavily inspired by Excel and Google Sheets formulas, for example: SUM(1, 2, 3, 4, 5) will yield 15.
It is currently a work in progress.
Primitives
These primitive values are used as arguments and as return values from functions.
| Primitive | Description | Syntax |
|---|---|---|
Str |
A string of characters enclosed by double quotes | "Hello World" |
Num |
A number | 1, 2.5, 3.1415 |
Boolean |
A boolean value | TRUE, FALSE |
EQ(a, b) -> Boolean
Description
Returns TRUE if the arguments are equal, otherwise returns FALSE.
Arguments
| Name | Description | Type |
|---|---|---|
| a | The first argument to compare | Str or Num or Boolean |
| b | The second argument to compare | Str or Num or Boolean |
Return Value
| Type | Description |
|---|---|
Boolean |
The comparison result |
Example
EQ(1,1) -> TRUE
NEQ(a, b) -> Boolean
Description
Returns TRUE if the arguments are different, otherwise returns FALSE.
Arguments
| Name | Description | Type |
|---|---|---|
| a | The first argument to compare | Str or Num or Boolean |
| b | The second argument to compare | Str or Num or Boolean |
Return Value
| Type | Description |
|---|---|
Boolean |
The comparison result |
Example
EQ(1,1) -> FALSE
CONCAT(a, b, c, ...) -> Str
Description
Concatenates all the arguments together into a single string.
Arguments
This function takes one or more arguments.
Non Str arguments will be implictly converted to Str, before being concatenated.
| Name | Description | Type |
|---|---|---|
| a | The first string to concat | Str or Num or Boolean |
| b | The second string to concat (optional) | Str or Num or Boolean |
| ... | The rest of the strings (optional) | Str or Num or Boolean |
Return Value
| Type | Description |
|---|---|
Str |
All arguments concatenated as a single string |
Example
CONCAT("Hello", " ", "World") -> "Hello World"
DIVIDE(a, b) -> Num
Description
Divide the first argument by the second one.
Arguments
| Name | Description | Type |
|---|---|---|
| a | The dividend | Num |
| b | The divisor | Num |
Return Value
| Type | Description |
|---|---|
Num |
The division result |
Example
DIVIDE(10, 2) -> 5
IF(condition, if_true, if_false) -> Literal
Description
If the condition is true, evaluates the if_true, otherwise evaluates the if_false.
Arguments
This function takes one or more arguments.
Non Str arguments will be implictly converted to Str, before being concatenated.
| Name | Description | Type |
|---|---|---|
| condition | Boolean or function that returns a boolean | Boolean |
| if_true | Evaluated if condition is TRUE |
Str or Num or Boolean |
| if_false | Evaluated if condition is FALSE |
Str or Num or Boolean |
Return Value
| Type | Description |
|---|---|
Str or Num or Boolean |
The result of evaluating the contents of either if_true or if_false |
Example
`IF(TRUE, "Hello", "World") -> "World"`
MULTIPLY(a, b) -> Num
Description
Multiplies the arguments.
Arguments
| Name | Description | Type |
|---|---|---|
| a | The first argument | Num |
| b | The second argument | Num |
Return Value
| Type | Description |
|---|---|
Num |
The multiplication result |
Example
MULTIPLY(5, 2) -> 10
SUBTRACT(a, b) -> Num
Description
Subtract the second argument from the first one.
Arguments
This function takes one or more arguments.
| Name | Description | Type |
|---|---|---|
| a | The first argument | Num |
| b | The second argument | Num |
Return Value
| Type | Description |
|---|---|
Num |
The subtraction result |
Example
SUBTRACT(1, 2) -> -1
SUM(a, b, c, ...) -> Num
Description
Sums all the arguments together.
Arguments
This function takes one or more arguments.
| Name | Description | Type |
|---|---|---|
| a | The first number to sum | Num |
| b | The second number to sum (optional) | Num |
| ... | The rest of the numbers to sum (option) | Num |
Return Value
| Type | Description |
|---|---|
Num |
All arguments summed up |
Example
SUM(1, 2, 3, 4, 5) -> 15
UPPER(a) -> Str
Description
Converts the string to upper case.
Arguments
Non Str arguments will be implictly converted to Str, before being concatenated.
| Name | Description | Type |
|---|---|---|
| a | The string to upper | Str or Num or Boolean |
Return Value
| Type | Description |
|---|---|
Str |
The upper case str |
Example
UPPER("Hello World") -> "HELLO WORLD"
Dependencies
~2–2.8MB
~56K SLoC