| Shell command question [message #97989] |
Wed, 03 September 2003 12:45  |
MM
Messages: 27
Registered: July 2002
|
Junior Member |
|
|
|
When i am converting a excel file as a csv(comma delimited file) and putting into UNIX as a flat file, at the end of each line i'm getting ^M. How do i get rid of it in the flat file
|
|
|
|
|
|
| Re: Shell command question [message #97991 is a reply to message #97989] |
Mon, 15 September 2003 14:20  |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
Here is the trick:
1. FTP the file to UNIX.
2. vi the file and do this
shift-colon
%
s
/
control-v
control-m
/
/
enter
You should see something like this at the last line inside vi
:%s/^M//
You should be done.
Good luck
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
