Use text styles to define typographic scale within your designs. Styles allows you to define a set of properties that can be reused across your team or organizations's files and projects. Anyone with at least can view access to a library can use styles from that library. String: replicate, charindex, leftstr, rightstr, ltrim, rtrim, trim, replace, reverse, proper, padl, padr, padc, strfilter.Anyone with can edit access to a file can create and edit styles.Math: acos, asin, atan, atn2, atan2, acosh, asinh, atanh, difference, degrees, radians, cos, sin, tan, cot, cosh, sinh, tanh, coth, exp, log, log10, power, sign, sqrt, square, ceil, floor, pi.Just follow the install directions at go-sqlite3-extension-functions and textql will automatically load this library. Print version and exit I want stdev, average, other functions Output delimiter character between fields -output-dlm=tab for tab, -dlm=0x# to specify a character code in hex (default ", ")įilename to write output to, if empty no output is written (default "stdout ") Treat input files as having the first row as a header row Input delimiter character between fields -dlm=tab for tab, -dlm=0x# to specify a character code in hex (default ", ") Textql Īfter all statements are run, open SQLite3 REPL with this data textql leverages the sqlite in-memory database feature as much as possible and only touches disk if asked.textql supports quote-escaped delimiters, sqlite does not.sqlite import will not accept stdin, breaking unix pipes.Key differences between textql and sqlite importing Writing to a directory no longer fails silently.Removed '-source', any files / paths at the end of the command are used, as well as piped-in data.This makes less sense after the automatic tablename generation based on filename, joins, and shorter SQL syntax changes. Dropped the ability to override table names.The flag '-outputHeader' was renamed to '-output-header'.This means the v1 command textql -sql "select * from tbl" -source some_file.csv can be shortened to textql -sql "*" some_file.csv.For simple selects, the SELECT keyword can be dropped from the query.For the case of a single table, the FROM can be dropped from the query.Added flag '-output-dlm' to modify the output delimiter.Added flag '-output-file' to save output directly to a file.You can list as many files / directories as you like.Directories are read by reading each file inside, and this is non-recursive.Added join support! Multiple files / directories can be loaded by listing them at the end of the command.See Time Strings for a list for accepted formats, and how to convert from other formats. Date / Time / DateTime values are automatically recognized in reasonable formats.Numeric values are automatically recognized in more cases. There've also been additional performance tweaks and added functionality, but this comes at the cost of breaking the original command-line flags and changing the install command. In the time since the initial release of textql, I've made some improvements as well as made the project much more modular. Allows you to easily execute SQL against structured text like CSV or TSV.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |