Sponsored Content
Full Discussion: Split positional flat file.
Top Forums Shell Programming and Scripting Split positional flat file. Post 302340309 by meetmedude on Monday 3rd of August 2009 07:32:59 AM
Old 08-03-2009
Thanks panyam. This is working. Thanks alot.


Quote:
Originally Posted by panyam
An awk will do the work :

Code:
awk ' BEGIN { c=0 }
{
if(substr($0,34,3)=="410")
{
c++;
print >> "File_" c ; next ;
}
else
{
print >> "File_" c;
}
}'  input_file.txt

according to the Data you posted Position of "410" is at 34-36.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with a Flat File!!!

Hi All, I need a help with a shelll script program.I get a '|' separated file which sometime has a encrypted column.And this encryption sometime breaks the last column data into a new line and this is not picked by the ETL.So when i run a script,it should append back the broken new line data... (11 Replies)
Discussion started by: kumarsaravana_s
11 Replies

2. Shell Programming and Scripting

Perl : split flat line's to $

Hi, below is the software list of lines I have, MozillaSrc 1.7.8.00.00 Mozilla 1.78 Source Distribution NFS B.11.11 ONC/NFS; Network-File System,Information Services,Utilities NParProvider B.11.11.01.04.01.01 nPartition Provider NPartition ... (7 Replies)
Discussion started by: acomd2
7 Replies

3. UNIX for Dummies Questions & Answers

Split a file with no pattern -- Split, Csplit, Awk

I have gone through all the threads in the forum and tested out different things. I am trying to split a 3GB file into multiple files. Some files are even larger than this. For example: split -l 3000000 filename.txt This is very slow and it splits the file with 3 million records in each... (10 Replies)
Discussion started by: madhunk
10 Replies

4. Shell Programming and Scripting

Flat file

Hi I have a flat file looking this QWER 2:35 7044 00001 ROUT 1188 EA SS ASD 2:36 7044 00010 ROUT BSD 2:37 7044 00011 ROUT END QWER 3:35 7044 00011 ROUT 1088 EA SS ASD 3:36 7044 00010 ROUT BSD 3:37 7044 00011 ROUT... (9 Replies)
Discussion started by: Krishnaramjis
9 Replies

5. Programming

compare XML/flat file with UNIX file system structure

Before i start doing something, I wanted to know whether the approach to compare XML file with UNIX file system structure. I have a pre-configured file(contains a list of paths to executables) and i need to check against the UNIX directory structure. what are the various approches should i use ? I... (6 Replies)
Discussion started by: shafi2all
6 Replies

6. Shell Programming and Scripting

Get the positional value from first line of the file

Hi, I have one flat file with delimited field as pipe(|) symbol. The file contains header,detail lines. Header is the first line in the file. I want to read the value for the position from 15 to 18 in first line of the file. Pls help me to get the value from position 15 to 18 in... (3 Replies)
Discussion started by: praka
3 Replies

7. Shell Programming and Scripting

Searching for Log / Bad file and Reading and writing to a flat file

Need to develop a unix shell script for the below requirement and I need your assistance: 1) search for file.log and file.bad file in a directory and read them 2) pull out "Load_Start_Time", "Data_File_Name", "Error_Type" from log file 4) concatinate each row from bad file as... (3 Replies)
Discussion started by: mlpathir
3 Replies

8. UNIX for Dummies Questions & Answers

Remove lines in a positional file based on string value

Gurus, I am relatively new to Unix scripting and am struck with a problem in my script. I have positional input file which has a FLAG indicator in at position 11 in every record of the file. If the Flag has value =Y, then the record from the input needs to be written to a new file.However if... (3 Replies)
Discussion started by: gsam
3 Replies

9. Shell Programming and Scripting

Positional Update of XML File

Hello, I have a XML file and need to update the data for a specific XML Attribute in the file. I need a Perl or Awk command to look for <INTERCHANGE_CONTROL_NO>000000601</INTERCHANGE_CONTROL_NO> in the XML file and change the first two 0 of the value to 9. For instance ... (4 Replies)
Discussion started by: Praveenkulkarni
4 Replies

10. Shell Programming and Scripting

Parsing a file based on positional constraints

I have a list file1 like dog cow fox cat fish duck crowI want to classify the elements of file1 based on constrains applied on file2. Additionally the number of elements (words) in the each line of file2 is not fixed. This is my file2 cow cat fox dog cow fox dog fish crow fox dog cat ... (5 Replies)
Discussion started by: sammy777
5 Replies
getopt(1)						      General Commands Manual							 getopt(1)

Name
       getopt - parse command options

Syntax
       set - - getopt optstring $*

Description
       The  command  breaks  up  options in command lines for easy parsing by Shell procedures and checks for legal options.  The optstring option
       letters are recognized if a letter is followed by a colon, the option expects an argument which may or may not  be  separated  from  it	by
       white space.  For further information, see

       The special option, specified by two minus signs (- -), delimits the end of the options.  If the delimiters are used explicitly, recognizes
       it; otherwise, generates it.  In either case, places the delimiter at the end of the options.  The positional parameters ($1 $2 ...) of the
       shell  are reset so that each option is preceded by a single minus sign (-) and is in its own positional parameter; each option argument is
       also parsed into its own positional parameter.

Examples
       The following code fragment shows how you can process the arguments for a command that can take the options a or b, as well as  the  option
       o, which requires an argument:
       #!/bin/sh5
       set -- getopt abo: $*
       if [ $? != 0 ]
       then
	    echo $USAGE
	    exit 2
       fi
       for i in $*
       do
	    case $i in
	    -a | -b)  FLAG=$i; shift;;
	    -o)  OARG=$2; shift 2;;
	    --)  shift; break;;
	    esac
       done
       This code accepts any of the following as equivalent:
       cmd -aoarg file file
       cmd -a -o arg file file
       cmd -oarg -a file file
       cmd -a -oarg -- file file

Diagnostics
       The command prints an error message on the standard error when it encounters an option letter not included in optstring.

See Also
       sh5(1), getopt(3)

																	 getopt(1)
All times are GMT -4. The time now is 10:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy