Functions
Useful functions for the Dashkit Excel add-in
by Dashkit
- Version 0.4.0
This SQLite extension enhances the Dashkit Excel add-in by adding general-purpose functions designed to streamline common tasks, such as standardizing country codes and names, and converting currencies using historical exchange rates.
Functions 9
Turn a clear boolean string, such as
true or yes, into
numeric boolean flag of 1 for true and 0 for false.
Returns null when value is not recognized.
-- From boolean name
select dash_bool_flag('true');
⭢ 1
-- From boolean string
select dash_bool_flag('no');
⭢ 0
dash_bool_name( string text ) ⭢ string
Turn string into boolean name
Turn a boolean flag or string, such as
1 or yes, into
boolean name true or false. Returns null when value is
not recognized.
-- From boolean flag
select dash_bool_name('1');
⭢ true
-- From shorthand for false
select dash_bool_name('f');
⭢ false
dash_continent_name( string text ) ⭢ string
Turn string into continent name
Turn a string, such as country name or code, into a
continent name. Returns
null when value is not recognized.
-- From country name
select dash_continent_name('Finland');
⭢ Europe
-- From country code
select dash_continent_name('FI');
⭢ Europe
dash_country_code( string text ) ⭢ string
Turn string into ISO 3166-1 alpha-3 country code
Turn a string, usually a country name, into a country code.
Returns
null when value is not recognized.
-- From country name
select dash_country_code('Finland');
⭢ FIN
dash_country_name( string text ) ⭢ string
Turn string into a country name
Turn a string, usually a country name or code, into a country name.
Returns
null when value is not recognized.
-- From alpha-3 country code
select dash_country_name('FIN');
⭢ Finland
-- From alpha-2 country code
select dash_country_name('FI');
⭢ Finland
-- From different naming
select dash_country_name('United States of America');
⭢ United States
dash_currency_code( string text ) ⭢ string
Turn string into ISO 4217 currency code
Turn a string, usually a country name or code, into a ISO 4217
currency code. Returns
null when value is not recognized.
-- From country name
select dash_currency_code('Finland');
⭢ EUR
dash_currency_rate( string text ) ⭢ float
Get historical foreign currency exchange rateGet historical foreign currency exchange rates for specified ISO 4217 currency symbols and target dates using a freeform search. The returned value is the historical End Of Day (EOD) exchange rate.
Supports conversion for 32 base currencies and 172 target currencies, with data available for up to 180 days in the past, up to yesterday.
Returns null when no data is found. Raises an error when
search string could not be parsed.
-- From USD to EUR
select dash_currency_rate('usd to eur 2025-07-16');
⭢ 0.859449
-- From shorter syntax
select dash_currency_rate('usd eur 2025-07-16');
⭢ 0.859449
-- For column value
select dash_currency_rate('usd eur ' || date);
⭢ 0.859449
dash_date( string text ) ⭢ string
Turn string into date
Turn a string into a date. Raises an error when
search string could not be parsed.
-- From keyword
select dash_date('yesterday');
⭢ 2025-08-21
-- From relative time
select dash_date('last of the month');
⭢ 2025-08-31
dash_dates( string start , string stop ) ⭢ [string]
Turn strings into date series
Turn date strings into date series for data joining. Raises
an error when either date string could not be parsed.
-- From relative range
select * from dash_dates('first of month', 'today');
┌────────────┐
│ value │
├────────────┤
│ 2025-09-01 │
│ 2025-09-02 │
│ 2025-09-03 │
└────────────┘
FAQ
For any questions, support, or feedback regarding this extension, please let us know.
Where do the currency exchange rates come from?
We retrieve foreign exchange rates daily from
fixer.io as historical End of Day (EOD)
rates, available after 00:05 UTC.