 |
 |
Dear Tim your solution worked like a charm. Thanks a lot. ----------------------------------------------------------------------- Dr. Parthasarathi Mukhopadhyay Professor, Department of Library and Information Science, University of Kalyani, Kalyani - 741 235 (WB), India ----------------------------------------------------------------------- On Wed, Apr 8, 2020 at 9:46 PM Parthasarathi Mukhopadhyay < [log in to unmask]> wrote: > 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> >> >