|
|
|
|
|
|
| Author |
Message |
drain *nix forums beginner
Joined: 10 Jul 2006
Posts: 2
|
Posted: Mon Jul 10, 2006 3:47 pm Post subject:
Script for changing a csv separator for all file into .zip archive....
|
|
|
Hi, i need to make a sh script that find all .zip files in all
subdirectories of a path, modify the .csv files inside the zip file,
change the ',' separator into ';' and then save all files .csv and
overwrite .zip files...any suggestions?
many thanks |
|
| Back to top |
|
 |
all mail refused *nix forums beginner
Joined: 21 Feb 2005
Posts: 38
|
Posted: Mon Jul 10, 2006 5:29 pm Post subject:
Re: Script for changing a csv separator for all file into .zip archive....
|
|
|
On 2006-07-10, drain <spremuta@gmail.com> wrote:
| Quote: | Hi, i need to make a sh script that find all .zip files in all
subdirectories of a path, modify the .csv files inside the zip file,
change the ',' separator into ';' and then save all files .csv and
overwrite .zip files...any suggestions?
many thanks
|
Not really a HP question.
If you've got the bottle you could post this to two competing language
groups asking which is better for the task and if you're lucky someone
will provide working code as an attempt at proving superiority.
Don't forget to say whether quoted commas need to be handled too (i.e.
left unchanged) and pre-existing semis need to be quoted. Have an answer
ready for the people who say that the new files should be called .ssv
instead of .csv .
--
Elvis Notargiacomo master AT barefaced DOT cheek
http://www.notatla.org.uk/goen/
One of my other 11 computers runs Minix. |
|
| Back to top |
|
 |
drain *nix forums beginner
Joined: 10 Jul 2006
Posts: 2
|
Posted: Mon Jul 10, 2006 5:52 pm Post subject:
Re: Script for changing a csv separator for all file into .zip archive....
|
|
|
all mail refused ha scritto:
| Quote: |
Not really a HP question.
If you've got the bottle you could post this to two competing language
groups asking which is better for the task and if you're lucky someone
will provide working code as an attempt at proving superiority.
Don't forget to say whether quoted commas need to be handled too (i.e.
left unchanged) and pre-existing semis need to be quoted. Have an answer
ready for the people who say that the new files should be called .ssv
instead of .csv .
|
You'right, i thought to post here because the script should be run on
an hp ux system, thanks for you're suggestions
Regards |
|
| Back to top |
|
 |
Dennis Handly *nix forums beginner
Joined: 28 Jun 2005
Posts: 38
|
Posted: Sat Jul 15, 2006 8:30 am Post subject:
Re: Script for changing a csv separator for all file into .zip archive....
|
|
|
elvis-85383@notatla.org.uk wrote:
: > i need to make a sh script that find all .zip files in all
: > subdirectories of a path, modify the .csv files inside the zip file,
: > change the ',' separator into ';' and then save all files .csv and
: > overwrite .zip files...any suggestions?
: > many thanks
: Not really a HP question.
Right. I would suggest using find, (with read or a for loop depending on
how many) then unzip, then a for loop with either
sed or awk, then zip.
If you want some perl gurus, you ask on one ITRC forum:
http://forums1.itrc.hp.com/service/forums/categoryhome.do?admit=-682735245+1152948032760+28353475&categoryId=150 |
|
| Back to top |
|
 |
Google
|
|
| Back to top |
|
 |
|
|
The time now is Mon Dec 01, 2008 10:39 pm | All times are GMT
|
|
Loans | Cheap Loan | Buy Anything On eBay | Loans | Home Loan
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|