Bulk file unix

Test your command before you use it on thousands of files! Remove the '. Remove the extension if you want to put something after it find. Sign up to join this community. The best answers are voted up and rise to the top.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Bulk rename, change prefix Ask Question. Asked 9 years, 4 months ago. Active 9 months ago. Viewed k times. How can I bulk replace the prefix for many files? Improve this question. Gilles 'SO- stop being evil' k gold badges silver badges bronze badges. Add a comment. Active Oldest Votes. There are two common versions of this command so check its man page to find which one you have: rename from Perl common in Debian systems -- Ubuntu, Mint, Improve this answer.

A caveat: multiple versions of rename exist in the wild. Check your local rename documentation to figure out how to use yours. Thx, i got this right now by myself too. Hence, its often easier to run the file through unix2dos first. But as you said in you original question, you don't want to do this I'll assume there is a good reason why you can't.

Probably because when the SQL code is being parsed, it is not replacing the char 10 with the LF character because it's already encased in single-quotes. Or perhaps its being interpreted as:.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 12 years, 11 months ago. Active 10 years, 2 months ago. Viewed 28k times. Improve this question. Cade Roux John Oxley John Oxley Add a comment. Active Oldest Votes. Hope this helps someone. Improve this answer. Randy J Randy J 1, 1 1 gold badge 8 8 silver badges 3 3 bronze badges.

Thanks Randy J. Changed the accepted answer because this is a better solution. Unfortunately this didn't work for my unix file which is terminated with LF but the dynamic SQL solution did work! Thank you! I only wasted about 10 minutes screwing around with the rowterminator before I found this post. Could have been much worse Login fails. En that is not possible in my case. Because I get de. Rudyx - the Doctor. The reason I ask is that may be the solution to your issue. I have seen processes modified such as you are doing in order to make things work when in fact no modification but the data transfer type may be needed.

As an example if your file was ftp'd using as binary instead of text this could be the cause of all of your woes. It is worth a look. You must be logged in to reply to this topic. Login to reply. September 7, at am The statement has been terminated. Dear David, I used two Hex editor tools: xvi32 and HxDBetafi both telling my that '' is the actual column delimiter's.

Cees, you need to use format file. Unix files use only LF to end lines. So, you can process UNIX files without any problems.