Support pipe (|) delimeter

[ColinHinesTHIG]

Prerequisites

• [ ] make sure you're are using the latest version by csvtk version
• [ ] Running version csvtk v0.25.0
• [ ] read the usage
• [ ] This has been read

Describe your issue

• [ ] describe the problem
• [ ] When running the following command "csvtk csv2xlsx test.txt -o test.xlsx", I receive the error of "[ERRO] record on line 3: wrong number of fields". I am using properly formatted text files that are delimited with a pipe symbol (|) instead of a comma, due to the nature of the data. Based on counting the number of commas and pipes on each line, it appears that csvtk is using the comma as the delimiter and not the pipe symbol. Is there any way to specify which delimiter to use?
• [ ]
• [ ] provide a reproducible example Example -- 4 lines (data scrubbed) below xxxxd|xxxxd|RxcxxptxDxtx|NxxxxNumbxr|PxlxcyxNumbxr|Rxxsxxxfxrxxrxxsxctxxx|PxlxcyxEffxctxvxxDxtx|PxlxcyxExpxrxtxxxxDxtx|Pxlxcyxxxrmxxxxmxxths|HOxxxxxd|xrxxsxctxxxxEffxctxvxxDxtx|LxstxNxmx;xxsurxdxNxmxxxrxxxmpxxyxNxmx|xxsurxd/xxmpxxyxMxxlxxgxStrxxtxxddrxss|xxsurxdxMxxlxxgxxxwx|xxsurxdxMxxlxxgxStxtx|xxsurxdxMxxlxxgxcxuxtry|xxsurxdxMxxlxxgxZxp|xxsurxdxLxcxtxxxxxddrxssx(xfxdxffxrxxt)|xxsurxdxLxcxtxxxxxxwx|xxsurxdxLxcxtxxxxStxtx|xxsurxdxLxcxtxxxxxxuxtry|xxsurxdxLxcxtxxxxZxp|LxgxlxDxscrxptxxx|LxxxhxldxrxNxmx|LxxxhxldxrxNxmxxlxxxx2|Lxxxhxldxrxxddrxss|Lxxxhxldxrxxxwx|LxxxhxldxrxStxtx|LxrxhxldxrxZxp|LxxxxxD|Mxrtgxgxxxypxx(xst,2xd,xtc)|xxvxrxgxxxxLxmxt|xxvxrxgxxBxLxmxt|Rxsxrvxd|Rxsxrvxd|xllxPxrxlsxDxductxblx|WxxdxDxductxblx|xxxcxllxtxxxxRxxsxx|xgxxcyxNxmx|xgxxcyxxxdx|xgxxcyxxddrxss|xgxxcyxxxwx|xgxxcyxStxtx|xgxxcyxxxuxtry|xgxxcyxZxp|xgxxcyxPhxxxxNumbxr|Exdxrsxmxxtsxx|ExdxrsxmxxtsxStxtxxx|Exdxrsxmxxtsx2|ExdxrsxmxxtsxStxtxx2|Exdxrsxmxxtsx3|ExdxrsxmxxtsxStxtxx3|Prxmxumxxmxuxt|xxcrxxsxdxPrxmxumxxmxuxt|Rxmxttxxcxxxddrxss|Rxmxttxxcxxxxwx|RxmxttxxcxxStxtx|RxmxttxxcxxZxp|Rxmxttxxcxxxxuxtry|RxmxttxxcxxPhxxx|SxxkhxlxxxxvxrxgxxExclusxxx?|WxxdxxxvxrxgxxExclusxxx?|xlxxdxxxvxrxgxxExclusxxx?|xxxxdx(#) x|L5x77|xxx92x23|x2538|Pxx29x3xx7|N|xx232x22|xx232x23|x2|HO|xxx82x23|MxSHOLY,HxxM|x3xxOLDxxxELDxRD|SExxUKEx|NY|USx|xx733x639|x24x4xxxSxxDExVxLLEYxLxNE|BOYNxONxBExxH|xL|USx|33473|x24x4xxxSxxDExVxLLEYxLxNE,BOYNxONxB|NEWREZxLLx.||POxBOXx7x5x|xROY|Mx|48xx7|xBx|xst|xx479xxx|xxxx958x|||xxxx|x.x2||xxwxxxxxtxrxxgxxcy|PxLR93xD|8784xBxyxtxxxBchxBlvdx#xx6|BxyxtxxxBxxch|xL|USx|33472|56x24477xx|||||||xxxxx.xx|xxxxx.xx|||||||||x|#x x|L5x77|xxx92x23|x2538|Pxx8282638|L|xx3x2x22|xx3x2x23|x2|HO|x23x2x22|WESx,BLxKE,J|6xx3xxWENxYxONExOxKSxDR|PENSxxOLx|xL|USx|32526||||||6xx3xxWENxYxONExOxKSxDR,PENSxxOLx|NxvyxxxdxrxlxxrxdxtxUxxxx||POxBOXxxxx598|xLORENxE|Sx|295x2x598|8x43575987|xst|xx29xxxx|xxxx58xx|||xxxx|x.x2|xxsurxdxRxquxstx-xxhxxgxdxxxsurxxcxxxxrr|xxsurxxcxxSxlutxxxsxxxxtxrxLLx|PxL6568D|44xxxBxyxuxBlvdxSuxtxxx8x|Pxxsxcxlx|xL|USx|325x3|85x4766399|||||||xxxxx.xx|xxxxx.xx|||||||||x|#x x|L5x77|xxx92x23|29x5x|9xx976898x|4|xxx92x22|xxx92x23|x2|HO|xxx62x23|Mxglxxrx,xhxmxs|x6444xWxNDSORxWxY|xLVx|xL|USx|3392x4644|x6444xWxNDSORxWxY|xLVx|xL|USx|3392x4644|x6444xWxNDSORxWxY,xLVx|Prxvxdxxtxxuxdxxgxxssxcxxtxs,xL.P.||P.O.xBOXx59x4|SxNxxxROSx|xx|954x259x4|4x22xxxxx6|xst|xx4xxxxx|xxxx82xx|||25xx|x.x2||Brxghtwxyxxxsurxxcx,xLLx|9xL6x2xD|866xxxxllxgxxPxrkwxyxSuxtxx3xx|xxrtxMyxrs|xL|USx|339x9|2394668x5x|||||||xxxxx.xx|xxxxx.xx|||||||||x|#x

Thank you

I'm grateful to users who have greatly helped to report bugs and suggested new features.

I may respond to issues or fix bugs quickly, but I usually implement new features periodically (two or more weeks).

[ColinHinesTHIG]

I'm leaving this comment here, because I missed it -- I thought I had read the documentation, and although I did, I didn't just read the output from running csvtk by itself. You can see that there is a -d option that allows the delimiter to be set.