#formula #arguments #language #light-weight #string #boolean #false

dala

Dalia is a light weight formula language

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

#5 in #false

MIT license

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
~57K SLoC