Then IMO that awk does not work according to the POSIX Specification because newline should turn into a field separator no matter what the value of FS, as per the previous quote in #15. and further:
Quote:
The symbol $0 shall refer to the entire record; setting any other field causes the re-evaluation of $0
This accomplished by assigning $1 to $1. And by re-evaluating $0, the field separators are changed to OFS which is a single space.
Is there a nawk on AIX?
---------- Post updated at 00:18 ---------- Previous update was at 00:05 ----------
Quote:
Originally Posted by Chubler_XL
[..]
===Update===
Funny enough on AIX 5.3 this does work:
Hmm forcing into string context makes a difference with that AIX implementation. Perhaps that implementation has an 'optimization' that if you assign the same value is is wrongly assumed that nothing needs to be done and by adding the double quotes it is regarded as different? A bit fishy, no?
This User Gave Thanks to Scrutinizer For This Post:
I have in file these words:
@fraza1 = rw
@fraza2 = r
@fraza3 = r
@fraza4 = r
@fraza5 = r
@fraza1 = r
@fraza6 = r
@fraza7 = r
@fraza2 = r
@fraza8 = r
@fraza9 = r
...
I would like so that:
,rw,@fraza1
,r,@fraza2 (2 Replies)
Hi every one;
I have a file with 22 rows and 13 columns which includes floating numbers.
I want to parse the file so that every five columns in the row would be a new record (row). For example, the first line in the old file should be converted into three lines with first two lines contain 5... (6 Replies)
I have a script which converts rows to columns.
file_name=$1
mailid=$2
#CREATE BACKUP OF ORIGINAL FILE
#cp ${file_name}.xlsx ${file_name}_temp.xlsx
#tr '\t' '|' < ${file_name}_temp.xlsx > ${file_name}_temp.csv
#rm ${file_name}_temp.xlsx
pivot_row=`head -1 ${file_name}`
sed 1d... (3 Replies)
Hi,
I have a requirement to convert rows into columns. data looks like:
c1,c2,c3,..
r1,r2,r3,..
p1,p2,p3,..
and so on..
output shud be like this:
c1,r1,p1,..
c2,r2,p2,..
c3,r3,p3,..
Thanks in advance, (12 Replies)
Hi I'm a UNIX awk and sed novice at best. I'm trying to creat a .csv file so it can be graphed in Excel. Tried various xargs, awk, sed and paste but just can't seem to get the data to line up. Not sure if this is beyond for a question in these forums. Any help would greatly be appreciated.
Have... (4 Replies)
Hi All,
I would like to send below output in a tabular column ( xml or excel ) and send a mail.
vinay unix
anil sql
vamsee java
request to suggest a solution. (1 Reply)
Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns.
I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
hi all
I need a help ..I have a script that takes has command and its output is like below..
a b
a v v
a c
I am assigning the above outputs to a variable ..
<variable name> = <command output>
problem here is when I echo the variable ..it gives me output like " a b... (3 Replies)
I've spent the past hour trying different things and googling for this solution and cannot find the answer. Found variations of this, but not this exact thing.
I have the following text, which is the output from our mainframe. Each field is on a separate line, with a blank line between each... (7 Replies)