 |
 |
it makes sense now. Thanks Andreas and Joseph. 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 7:29 PM Joseph Andrew Koivisto <[log in to unmask]> wrote: > This might help. Pretty clear explication of what is going on here: > > https://unix.stackexchange.com/questions/181141/rename-multiple-files-with-mv-to-change-the-extension > > On Wed, Apr 8, 2020 at 9:57 AM Andreas Orphanides <[log in to unmask]> > wrote: > > > 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 > > > > > > > ----------------------------------------------------------------------- > > > > > > > > > > > > > > > > > -- > > *Joseph A. Koivisto* > > > *Systems Librarian* > *Consortial Library Applications Support* > *University of Maryland* > *McKeldin Library, Room B0238* > *7649 Library Ln., College Park, MD 20742-7011* > *[log in to unmask] <[log in to unmask]>* > *301-314-4812**[image: ORCID iD icon]orcid.org/0000-0002-7515-2522* > <https://orcid.org/0000-0002-7515-2522> >