Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Awk - more than 99 fields?
Top Forums UNIX for Dummies Questions & Answers Awk - more than 99 fields? Post 858 by DaveM on Tuesday 23rd of January 2001 10:39:20 AM
Old 01-23-2001
Data
Just written a great little script that analyses a flat ASCII CSV file and reports for any discrepancies with field counts per record etc.

Works fine on all the flat files except one, which has 113 fields per line. AWK can only seemingly cope with up to 99 fields.

Is there any way around this? It will be a pain to check manually as there are more than 100,000 records in this file!

Cheers

Dave
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

combining fields in awk

I am using: ps -A -o command,%cpu to get process and cpu usage figures. I want to use awk to split up the columns it returns. If I use: awk '{print "Process: "$1"\nCPU Usage: "$NF"\n"}' the $NF will get me the value in the last column, but if there is more than one word in the... (2 Replies)
Discussion started by: json4639
2 Replies

2. Shell Programming and Scripting

Specifying and replacing fields with awk

#cat BATCH007.TXT 01,661060052,061000104,081118,0915,07,80,1,2/ 99,,,2/ I have this file called BATCH007.TXT. I am trying to change fields 2 and 3 on line 2 to have zeroes. Like this: 01,661060052,061000104,081118,0915,07,80,1,2/ 99,0,0,2/ I can use these commands to print identify the... (2 Replies)
Discussion started by: ddurden7
2 Replies

3. Shell Programming and Scripting

awk sed cut? to rearrange random number of fields into 3 fields

I'm working on formatting some attendance data to meet a vendors requirements to upload to their system. With some help on the forums here, I have the data close. But they've since changed what they want. The vendor wants me to submit three fields to them. Field 1 is the studentid field,... (4 Replies)
Discussion started by: axo959
4 Replies

4. Shell Programming and Scripting

edit fields awk

Hi there, i need some help please... I have this text, it's name data.txt that contains the following information: Mark Owen: 6999999888 6999999888 +302310999999 2310999999 Steve Blade Pit: +30691111222 2310888777 6999999888 John Rose: 2310777555 310544565 +302310999999 Mary Stuart:... (7 Replies)
Discussion started by: Mark_orig
7 Replies

5. UNIX for Dummies Questions & Answers

fields in AWK

I feel like a real leech now, 3 questions in 3 days, but hopefully when I get my head around all of this I can contribute back to this community! Anyway, so a couple of you guys have gotten me onto AWK and I've been researching it a little over the last couple of hours, now I'm somewhat sure I... (2 Replies)
Discussion started by: Aussiemick
2 Replies

6. Shell Programming and Scripting

No. of Fields using Awk

Hi, Could someone please let me know me how i can use an awk command to print the No. of fields of each file present in a Directory?Suppose the Directory has 5 text files in which the first record in each file contains fields separated by a '|'. I need to use a awk command to display the No... (8 Replies)
Discussion started by: pchegoor
8 Replies

7. Shell Programming and Scripting

Join fields comparing 4 fields using awk

Hi All, I am looking for an awk script to do the following Join the fields together only if the first 4 fields are same. Can it be done with join function in awk?? a,b,c,d,8,,, a,b,c,d,,7,, a,b,c,d,,,9, a,b,p,e,8,,, a.b,p,e,,9,, a,b,p,z,,,,9 a,b,p,z,,8,, desired output: ... (1 Reply)
Discussion started by: aksijain
1 Replies

8. Shell Programming and Scripting

How to print 1st field and last 2 fields together and the rest of the fields after it using awk?

Hi experts, I need to print the first field first then last two fields should come next and then i need to print rest of the fields. Input : a1,abc,jsd,fhf,fkk,b1,b2 a2,acb,dfg,ghj,b3,c4 a3,djf,wdjg,fkg,dff,ggk,d4,d5 Expected output: a1,b1,b2,abc,jsd,fhf,fkk... (6 Replies)
Discussion started by: 100bees
6 Replies

9. Shell Programming and Scripting

awk - compare 1st 15 fields of record with 20 fields

I'm trying to compare 2 files for differences in a selct number of fields. When differnces are found it will write the whole record of the second file including appending '|C' out to a delta file. Each record will have 20 fields, but only want to do comparison of 1st 15 fields. The 1st field of... (7 Replies)
Discussion started by: sljnk
7 Replies

10. Shell Programming and Scripting

awk sort based on difference of fields and print all fields

Hi I have a file as below <field1> <field2> <field3> ... <field_num1> <field_num2> Trying to sort based on difference of <field_num1> and <field_num2> in desceding order and print all fields. I tried this and it doesn't sort on the difference field .. Appreciate your help. cat... (9 Replies)
Discussion started by: newstart
9 Replies

LEARN ABOUT SUNOS

praudit

praudit(1M)						  System Administration Commands					       praudit(1M)

NAME

       praudit - print contents of an audit trail file

SYNOPSIS

       praudit [-lrsx] [-ddel] [filename...]

DESCRIPTION

       praudit	reads  the  listed  filenames  (or  standard input, if no filename is specified) and interprets the data as audit trail records as
       defined in audit.log(4). By default, times, user and group IDs (UIDs and GIDs, respectively) are converted to their  ASCII  representation.
       Record  type  and  event  fields  are converted to their ASCII representation. A maximum of 100 audit files can be specified on the command
       line.

OPTIONS

       The following options are supported:

       -ddel	Use del as the field delimiter instead of the default delimiter, which is the comma. If del has special meaning for the shell,	it
		must  be  quoted. The maximum size of a delimiter is three characters. The delimiter is not meaningful and is not used when the -x
		option is specified.

       -l	Print one line per record.

       -r	Print records in their raw form. Times, UIDs, GIDs, record types, and events are displayed as integers. This  option  and  the	-s
		option are exclusive. If both are used, a format usage error message is output.

       -s	Print  records	in  their short form. All numeric fields are converted to ASCII and displayed. The short ASCII representations for
		the record type and event fields are used. This option and the -r option are exclusive. If both are used,  a  format  usage  error
		message is output.

       -x	Print records in XML form. Tags are included in the output to identify tokens and fields within tokens. Output begins with a valid
		XML prolog, which includes identification of the DTD which can be used to parse the XML.

FILES

       /etc/security/audit_event       Audit event definition and class mappings.

       /etc/security/audit_class       Audit class definitions.

       /usr/share/lib/xml/dtd	       Directory containing the verisioned DTD file referenced in XML output, for example, adt_record.dtd.1.

       /usr/share/lib/xml/style        Directory containing the versioned XSL file referenced in XML output, for example, adt_record.xsl.1.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |See below 		   |
       +-----------------------------+-----------------------------+

       The command stability is evolving. The output format is unstable.

SEE ALSO

       bsmconv(1M), audit(2), getauditflags(3BSM), audit.log(4), audit_class(4), audit_event(4), group(4), passwd(4), attributes(5)

NOTES

       This functionality is available only if the Basic Security Module (BSM) has been enabled. See bsmconv(1M) for more information.

SunOS 5.10							    6 Jan 2003							       praudit(1M)
All times are GMT -4. The time now is 07:41 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy