Wei Shen

> for join, supporting reading one of the files from stdin. ``` $ cat testdata/phones.csv \ | csvtk join -f 1 - testdata/region.csv \ | csvtk pretty username phone region...

`csvtk join`? or shell `paste`? I'm not sure whether the two files have the same number of rows or share common fields values.

> In my example they have the same number of rows and they not share any fields. > I want only to know if it's possible to do in csvtk...

> I had a similar problem last night which I could not solve using csvtk Again, let's use `transpose` ``` csvtk transpose f1.csv > f1.t.csv csvtk transpose f2.csv > f2.t.csv...

> In my example they have the same number of rows and they not share any fields. > I want only to know if it's possible to do in csvtk...

You can just use shell `paste` ``` $ paste -d , a.csv b.csv field1,field2,field3,field4 0,a,0,a 1,b,1,b 3,a,3,a ``` Or csvtk `transpose` + `concat` ``` $ csvtk concat -H

All data (as string matrix) are exported by `xlsx.GetRows(sheetName) [][]string` (supported by https://github.com/qax-os/excelize), and I also check the code, there's nothing I can do. But after I format the cells...

Or add a new command for formatting time and date. Gosh...

Added a new command `fmtdate`. - [csvtk_darwin_amd64.tar.gz](https://github.com/shenwei356/csvtk/files/7043417/csvtk_darwin_amd64.tar.gz) - [csvtk_linux_amd64.tar.gz](https://github.com/shenwei356/csvtk/files/7043420/csvtk_linux_amd64.tar.gz) - [csvtk_windows_amd64.exe.tar.gz](https://github.com/shenwei356/csvtk/files/7043421/csvtk_windows_amd64.exe.tar.gz) Example:  ``` $ csvtk xlsx2csv date.xlsx | csvtk pretty data value ------------------- ----- 2021-08-25 11:24:21 1 08/25/21 11:24...

Let's leave this to v0.25.0, after finishing #172