Support shell text utilities for string functions

[amitbha]

The sqlite string functions are not powerful. How about provide a function to use shell utilities like grep, awk, sed etc.? ex. trdsql -ih -oh "select shell(grep -oP '[[:digit:]]{5}', c1) as num from d.csv"

[noborus]

Thank you for your suggestion.

The sqlite string functions are not powerful.

I agree, the sqlite3 function may be inconvenient. However, I think it's hard to implement a shell call for every column. I thought shell call was possible instead of a table.

[amitbha]

U r right. I find some shell tools for manipulating csv data. Trdsql should focus on query csv. https://github.com/shenwei356/csvtk https://github.com/johnkerl/miller http://csvfix.byethost5.com/csvfix.htm