Obsidian CSV Table Fork

I really like the obsidian-csv-table plugin and have added another option for my purposes where the source option can also include any markdown tables in any markdown files in the vault.

I do the following

• the source option can refer to any markdown file in the vault eg. My Table Data.md
• the keyword tableheading defines which table to use in the source markdown file
  • Each column name of the markdown table is listed separated by commas eg. Product Name,Product No,Qty
  • Note All column names must be listed
• all other options work as expected eg filter, sortBy, columns etc.
• rather than use the code block identifier csvtable I have used ad-table-query.
  • In this way you can use this forked version of the plugin in parallel with the original obsidian-csv-table plugin.

Example

The table in page Tests/test-ad-table-query

Product	No	Description
Pear	203	Similar to Apple but not round
Apple	100	Round fruit with pips
Orange		Also round
Grapes	10050	Has pips be careful
Lime	7081	Simlar to a lemon but green
Avocado	9034	Nice in Sandwiches

```ad-table-query
source: Tests/test-ad-table-query.md
tableheading: "Product,No,Description"
columns:
- Product
- No
- Description
sortBy: Description
filter: No != ""
```

will render the following table

Product	No	Description
Grapes	10050	Has pips be careful
Avocado	9034	Nice in Sandwiches
Apple	100	Round fruit with pips
Pear	203	Similar to Apple but not round
Lime	7081	Simlar to a lemon but green

Method used by this fork

• Markdown tables are automatically converted to csv internally and then passed through to the original csv handling of obsidian-csv-table plugin.
• tables that are created and updated by the Advanced Tables plugin are supported as the conversion to csv strips leading and trailing spaces from table cells

Original obsidian-csv-table README

Have data in a CSV file that you'd like to render as a table in Obsidian? Now you can.

Quickstart

Imagine you have the following CSV file named countries.csv:

name,capitol,population
United States of America,"Washington, DC",328200000
Colombia,Bogota,50340000
Russia,Moscow,144400000

The following code block:

```csvtable
source: countries.csv
```

will render a table like:

name	capitol	population
United States of America	Washington, DC	328200000
Colombia	Bogota	50340000
Russia	Moscow	144400000

Options

• source: (Required) Path (relative to your vault's root) to the csv file to render within your notes.
• csvOptions: Options to use for decoding the referenced CSV file; see https://csv.js.org/parse/options/ for available options.
• columns: A list of columns to render. Each item may be either the name of a field to display or an expression (see "Expressions" below), and can be re-named. If unspecified, all columns in the referenced CSV will be rendered. See "Selecting particular columns" below for details.
• filter: A list of filter expressions (see "Expressions" below) or a single filter expression to use for limiting which rows of the referenced CSV will be displayed. If unspecified, all rows of the referenced CSV will be rendered taking into account the value specified for maxRows below. See "Filtering displayed rows" for details.
• sortBy: A list of sort expressions (see "Expressions" below) or a single sort expression to use for sorting the displayed rows. If unspecified, rows will be displayed in the order they appear in the referenced CSV. See "Sorting Rows" for details.
• columnVariables: A mapping of variable name to column name allowing you to set a name for use in filter or columns above to reference the value of a field that is not a valid variable name.
• maxRows: The maximum number of rows to display. If unspecified, all unfiltered rows of the referenced CSV will be displayed.

Expressions

This library uses filtrex for expression evaluation; see their documentation to see more information about the expression syntax and what functions are available: https://github.com/m93a/filtrex#expressions.

See "Filtering displayed rows" for an example of a filter expression in action, but realistically they work exactly as you'd probably expect.

Selecting particular columns

You can use the columns field to control which columns of your CSV file to render, e.g:

```csvtable
columns:
- name
- population
source: my_csv_file.csv
```

name	population
United States of America	328200000
Colombia	50340000
Russia	144400000

It's also possible for you to set better names for your columns or use expressions:

```csvtable
columns:
- expression: name
  name: Country Name
- expression: population  / 1000000
  name: Population (Millions)
source: my_csv_file.csv
```

Country Name	Population (Millions)
United States of America	328.2
Colombia	50.34
Russia	144.4

Filtering displayed rows

Maybe you would like to display only a subset of the rows of your CSV? If so, you can provide a filter expression to limit which rows are shown:

```csvtable
source: my_csv_file.csv
filter: population < 100000000
```

name	population
Colombia	50340000

By default, the parser will attempt to cast the values of each field to an integer, boolean, or date object where appropriate for use in your filter expressions. Also, note that your filter expression can also be provided as a list; those expressions will be and-ed together, e.g.:

```csvtable
source: my_csv_file.csv
filter:
- population < 100000000
- name == "Colombia"
```

Note that the filtering language requires that you use double-quoted strings in comparisons -- if you had entered name == 'Colombia' above, the filter would not have returned results.

Sorting Rows

If you would like to sort the rows of your displayed CSV, you can provide a sort expression:

```csvtable
source: my_csv_file.csv
sortBy: name
```

name	population
Colombia	50340000
Russia	144400000
United States of America	328200000

Additionally, you can specify your sortBy expression as a list; the document will be sorted by all specified fields in rank order:

```csvtable
source: my_csv_file.csv
sortBy:
- columnOne
- columnTwo
```

It's also possible for you to sort your displayed data in reverse order if you specify your sortBy expression using an extended format allowing you to specify both the expression and direction of sort:

```csvtable
source: my_csv_file.csv
sortBy:
- expression: name
  reversed: true
```

name	population
United States of America	328200000
Russia	144400000
Colombia	50340000