 |
 |
I don't think that *NIX commands are really set up to expect batch inputs for the most part, which is why the Stack Overflow script requires the use of "for" and "sed". I'll let an expert correct/clarify for me.... On Wed, Apr 8, 2020 at 9:51 AM Parthasarathi Mukhopadhyay < [log in to unmask]> wrote: > Thanks Andreas Orphanide > > It was a mere issue with file extension (.txt). Now the downstream program > is behaving perfectly well. > I performed with small set of 100 files and it worked well. I have gone > through the stackoverflow post but wondering why > > mv *.csv *.txt is not working (I tried but failed). > > Thanks and regards > > > > > ----------------------------------------------------------------------- > Dr. Parthasarathi Mukhopadhyay > Professor, Department of Library and Information Science, > University of Kalyani, Kalyani - 741 235 (WB), India > ----------------------------------------------------------------------- > > > On Wed, Apr 8, 2020 at 5:11 PM Andreas Orphanides <[log in to unmask]> > wrote: > > > Unless there's something I am not understanding about this problem, > > converting CSV to TXT should just be a matter of changing the file > > extension from ".csv" to ".txt", and even this isn't strictly speaking a > > requirement. CSV is just a text file with a specific layout to the text > to > > define columns -- try to open a .csv file using your favorite text editor > > and you should not have any issues whatsoever (unless there's a character > > encoding issue, but then you'd see the problem whether the file was CSV > or > > TXT). > > > > If the file name is important for some other part of the workflow (a > > downstream program that would refuse the file unless it's .txt), here's a > > Stack Overflow post > > < > > > https://stackoverflow.com/questions/9590935/change-extension-of-file-using-shell-script > > > > > with a *NIX script command to change the file extension. Similar methods > > exist in Windows > > < > > > https://www.addictivetips.com/windows-tips/batch-change-rename-file-extensions-in-windows/ > > > > > . > > > > If there's something else about the underlying problem, please do share! > > > > > > On Wed, Apr 8, 2020 at 7:30 AM Parthasarathi Mukhopadhyay < > > [log in to unmask]> wrote: > > > > > Could you plz guide me in finding an ONLINE tool for the following > > > workflow? > > > > > > 1. A large csv file with 40K+ rows split into number of csv files (one > > file > > > per row). > > > This step is done. > > > > > > 2. These large number of csv files need to be converted into text files > > > before further processing and I wish to do it in the following way: > > > 2.1 make zip file for all csv files > > > 2.2 upload csv.zip file (as a single file) to online converter > > > 2.3 convert all csv files (in the single zip file) into txt files > > > (UTF-8 encoding is preferred but not necessary at this stage) > > > 2.4 download the converted text files preferably as a zip file. > > > > > > I was/am searching such a tool/converter for last seven days but what I > > > found are tools like docspal.com which can take only csv files as > input > > > and > > > that 5 at a time at the best. > > > > > > Waiting eagerly for guidance. If no such online tool available, you may > > > please direct me to available scripts/software in solving the issue at > > > hand. > > > > > > Thanks and regards > > > ----------------------------------------------------------------------- > > > Parthasarathi Mukhopadhyay > > > Professor, Department of Library and Information Science, > > > University of Kalyani, Kalyani - 741 235 (WB), India > > > ----------------------------------------------------------------------- > > > > > >