why ^M in my file? Post: 302274359

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers why ^M in my file? Post 302274359 by awk on Wednesday 7th of January 2009 12:27:48 PM

01-07-2009

Registered User

Quote:

Originally Posted by redlotus72

I have downloaded one csv file from my AIX box and edited using Text Pad, and uploaded thru SecureFX, If I see the file using vi command I can see ^M in end of the line, if open again in text pad there are lot of new lines. How to fix this issue? where is the problem? Text pad or SecureFX?

Sadly, my AIX box does not have dos2ux <sigh> - which I have used successfully on other systems.

The problem comes up that dos/windows uses two characters to indicate end-of-line. Unix uses one. What you are seeing in UNIX is the extraneous (at least to it) character.

Try transmitting the file in TEXT mode. that should convert between the two systems.

Else, find a way to use sed to get rid of the extra character.

awk

View Public Profile for awk

Find all posts by awk

3 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Match list of strings in File A and compare with File B, C and write to a output file in CSV format

Hi Friends, I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving... File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy...

2. Shell Programming and Scripting

Compare 2 text file with 1 column in each file and write mismatch data to 3rd file

Hi, I need to compare 2 text files with around 60000 rows and 1 column. I need to compare these and write the mismatch data to 3rd file. File1 - file2 = file3 wc -l file1.txt 58112 wc -l file2.txt 55260 head -5 file1.txt 101214200123 101214700300 101250030067 101214100500...

3. Shell Programming and Scripting

Shell script (sh file) logic to compare contents of one file with another file and output to file

Shell script logic Hi I have 2 input files like with file 1 content as (file1) "BRGTEST-242" a.txt "BRGTEST-240" a.txt "BRGTEST-219" e.txt File 2 contents as fle(2) "BRGTEST-244" a.txt "BRGTEST-244" b.txt "BRGTEST-231" c.txt "BRGTEST-231" d.txt "BRGTEST-221" e.txt I want to get...

LEARN ABOUT PLAN9

cr

cr(1)							      General Commands Manual							     cr(1)

NAME

       cr - converts text files between nix EOL and dos EOL

SYNOPSIS

       cr  - | +  <input file> <output file>

DESCRIPTION

       Text  files,  such  as tle files, that come from a dos source usualy have the ^M symbol at the end of every line. Cr converts files between
       the dos newline format and the normal *nix newline format by stripping the ^M to convert dos to *nix, using the '-' option, or adding ^M to
       a *nix file to create the proper dos file when the '+' option is used.

       Although this extra character is not often a problem, programs like seesat5, which are data driven will encounter parsing problems when the
       extra character is present. It is these problems that cr is intended to repair.

   Options
       - | +  One or the other of these options is required. The '-' option is used to remove ^M from all newlines found in the dos file. The  '+'
	      option is used to add ^M to every newline found in a *nix file.

       input file
	      Fully delineated path to the input file. As this program is used in the dos environment as well, standard input is not used.

       output file
	      Fully delineated path to the output file. As this program is used in the dos environment as well, standart output is not used.

SEE ALSO

       seesat5(1), seesat5(7), SEESAT5.INI(5), tle(5)

BUGS

       Cr  is  not an inteligent program. It methodicaly replaces/removes the offending character when it finds it in the correct context. Newline
       sequences found in contexts other than 'newline' will be replaced/removed just like those found in the proper  context.	Passing  a  binary
       file through cr is not advised, for this reason. Send all inqueries to Dale Scheetz <dwarf@polaris.net>.

Debian Linux							    2 April 96								     cr(1)