10-29-2018
Quote:
Originally Posted by
jim mcnamara
What Rudi & Corona are saying: UNIX text files have different carriage control characters from windows text files - like tab delimited Excel output.
cleanup windows files == dos2unix command:
carriage control for
UNIX: ASCII 10 written "\n", called a newline character.
Windows: ASCII 13 and ASCII 10 - "\r\n", called return and newline.
awk will misbehave on windows text files. Most decent editors let you change UNIX <-> Windows at will. The UNIX dos2unix command does what you need when the file got onto the Linux box with bad carriage control. unix2dos goes the other way for you. Windows does not like UNIX carriage control, either Tit for tat, I guess.
That did the trick. One of the text files sent to me must have been processed with a windows machine...
This User Gave Thanks to Geneanalyst For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
HI guys,
I have created a script to read 1 column in a csv file and then place it in text file.
However, when i checked out the text file, it is not in a column format...
Example:
CSV file contains
name,age
aa,11
bb,22
cc,33
After using awk to get first column
TXT file... (1 Reply)
Discussion started by: mdap
1 Replies
2. Shell Programming and Scripting
I am using the following command:
nawk -F"," 'NR==FNR {a=$1;next} a {print a,$1,$2,$3}' file1 file2
I am getting 40 records output.
But when i import file1 and file2 in MS Access i get 140 records.
And i know 140 is correct count.
Appreciate your help on correcting the above script (5 Replies)
Discussion started by: pinnacle
5 Replies
3. Shell Programming and Scripting
Hi,
I would like:
FastEthernet0/0 is up, line protocol is up
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
0 output errors, 0 collisions, 0 interface resets
Serial1/0:0 is up, line protocol is up
0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored, 0 abort
0... (14 Replies)
Discussion started by: mv652
14 Replies
4. Shell Programming and Scripting
I have a number of unix text files containing fixed-length records (normal unix linefeed terminator) where I need to find odd records which are an incorrect length.
The data is not validated and records can contain odd backslash characters and control characters which makes them awkward to process... (2 Replies)
Discussion started by: methyl
2 Replies
5. Shell Programming and Scripting
Hi Experts,
I am adding a column of numbers with awk , however not getting correct output:
# awk '{sum+=$1} END {print sum}' datafile
2.15291e+06
How can I getthe output like : 2152910
Thank you..
# awk '{sum+=$1} END {print sum}' datafile
2.15079e+06 (3 Replies)
Discussion started by: rveri
3 Replies
6. Shell Programming and Scripting
Hello friends,
I searched in forums for similar threads but what I want is to have a single awk code to perform followings;
I have a big log file going like this;
...
7450494 1724465 -47 003A98B710C0
7450492 1724461 -69 003A98B710C0
7450488 1724459 001DA1915B70 trafo_14:3
7450482... (5 Replies)
Discussion started by: enes71
5 Replies
7. Shell Programming and Scripting
I want to extract a web page to a temporary file as a source document. I tried: wget $webPgURL > /tmp/tmpfil
but it says I have a missing URL. I have echoed $webPgURL just prior to the wget command and it is correct. If I use: firefox $webPbURL it brings up firefox with the correct page. Can... (3 Replies)
Discussion started by: slak0
3 Replies
8. Shell Programming and Scripting
cat T|awk -v format=$format '{ SUM += $1} END { printf format,SUM}'
the file T has below data
usghrt45tf:hrguat:/home/hrguat $ cat T
-1363000.00123456789
-95000.00789456123
-986000.0045612378
-594000.0015978
-368939.54159753258415
-310259.0578945612
-133197.37123456789... (4 Replies)
Discussion started by: zulfi123786
4 Replies
9. Shell Programming and Scripting
Running solaris 9, on issuing the follwing command
df -h | awk '$5 > 45 {print}'
Filesystems with utilisation > 45% are being displayed as well as those between
5 and-9%!!! (3 Replies)
Discussion started by: squrcles
3 Replies
10. Shell Programming and Scripting
Hi All,
I am looking to filter out filesystems which are greter than a specific value.
I use the command
df -h | awk '$4 >=70.00 {print $4,$5}'
But this results out as below, which also gives for lower values.
9% /u01
86% /home
8% /u01/data
82% /install
70% /u01/app
Looks... (3 Replies)
Discussion started by: jjoy
3 Replies
ASA(1) BSD General Commands Manual ASA(1)
NAME
asa -- interpret carriage-control characters.
SYNOPSIS
asa [file ...]
DESCRIPTION
The asa utility reads files sequentially, mapping FORTRAN carriage-control characters to line-printer control sequences, and writes them to
the standard output.
The first character of each line is interpreted as a carriage-control character. The following characters are interpreted as follows:
<space> Output the rest of the line without change.
0 Output a <newline> character before printing the rest of the line.
1 Output a <formfeed> character before printing the rest of the line.
+ The trailing <newline> of the previous line is replaced by a <carriage-return> before printing the rest of the line.
Lines beginning with characters other than the above are treated as if they begin with <space>.
EXAMPLES
To view a file containing the output of a FORTRAN program:
asa file
To format the output of a FORTRAN program and redirect it to a line-printer.
a.out | asa | lpr
DIAGNOSTICS
The asa utility exit 0 on success, and >0 if an error occurs.
SEE ALSO
f77(1)
STANDARDS
The asa utility conforms to IEEE Std 1003.2-1992 (``POSIX.2'').
AUTHORS
J.T. Conklin, Winning Strategies, Inc.
BSD
September 23, 1993 BSD