Splitting records in a text file based on delimiter Post: 302783187

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

splitting file with more than one delimiter

Hi, I just wandering how to split a record which has more than one delimiter, i have a file which contains pattern as group separtor and ~ as field separtor, Ultimately I need consider even the groups as a field, So i need to make this multi-delimited file into ~ delimited file. My record...

2. Shell Programming and Scripting

splitting files based on text in the file

I need to split a file based on certain context inside the file. Is there a unix command that can do this? I have looked into split and csplit but it does not seem like those would work because I need to split this file based on certain text. The file has multiple records and I need to split this...

3. Shell Programming and Scripting

Formatting a text file based on newline and delimiter characters

Hi Everybody, I need some help on formatting the files coming into unix box on the fly. I get a file some thing like this in a single line. ISA^M00^M ^M00^M ^M14^M006929681900 ^M01^M095449419 ...

4. Shell Programming and Scripting

Splitting a file based on the records in another file

All, We receive a file with a large no of records (records can vary) and we have to split it into two files based on another file. e.g. File1: UHDR 2008112 "25187","00000022","00",21-APR-1991,"" ,"D",-000000519,+0000000000,"C", ,+000000000,+000000000,000000000,"2","" ...

5. Shell Programming and Scripting

Substring based on delimiter, finding last delimiter

Hi, I have a string like ABC.123.XYZ-A1-B2-P1-C4. I want to delimit the string based on "-" and then get result as only two strings. One with string till last hyphen and other with value after last hyphen... For this case, it would be something like first string as "ABC.123.XYZ-A1-B2-P1" and...

6. Shell Programming and Scripting

awk - splitting 1 large file into multiple based on same key records

Hello gurus, I am new to "awk" and trying to break a large file having 4 million records into several output files each having half million but at the same time I want to keep the similar key records in the same output file, not to exist accross the files. e.g. my data is like: Row_Num,...

7. Shell Programming and Scripting

Shell script to put delimiter for a no delimiter variable length text file

Hi, I have a No Delimiter variable length text file with following schema - Column Name Data length Firstname 5 Lastname 5 age 3 phoneno1 10 phoneno2 10 phoneno3 10 sample data - ...

8. UNIX for Dummies Questions & Answers

Delete records based on a text file from a text file

Hi Folks, I am a novice and need to build a script in bash. I have 2 text files data.txt file is big file, column 2 is the we need to search and delete in the output. The filter file contains the rows to be deleted. Data.txt state city zone Alabama Huntsville 4 California SanDiego 3...

9. UNIX for Dummies Questions & Answers

Splitting strings based on delimiter

i have a snippet from server log delimited by forward slash. /a/b/c/d/filename i need to cut until last delimiter. So desired output should look like: /a/b/c/d can you please help? Thanks in advance.

10. Shell Programming and Scripting

Script for splitting file of records into multiple files

Hello I have a file of following format HDR 1234 abc qwerty abc def ghi jkl HDR 4567 xyz qwerty abc def ghi jkl HDR 890 mno qwerty abc def ghi jkl HDR 1234 abc qwerty abc def ghi jkl HDR 1234 abc qwerty abc def ghi jkl -Need to split this into multiple files based on tag...

LEARN ABOUT PLAN9

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)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

splitting file with more than one delimiter

Discussion started by: braindrain

2. Shell Programming and Scripting

splitting files based on text in the file

Discussion started by: matrix1067

3. Shell Programming and Scripting

Formatting a text file based on newline and delimiter characters

Discussion started by: ntekupal

4. Shell Programming and Scripting

Splitting a file based on the records in another file

Discussion started by: er_ashu