Sponsored Content
Top Forums Shell Programming and Scripting Split a fixed length file bases on last occurence of string Post 302833793 by Neelkanth on Wednesday 17th of July 2013 11:35:03 PM
Old 07-18-2013
Question Split a fixed length file bases on last occurence of string

Hi,

I need to split a file based on last occurece of a string. PFB the explanation
I have a file in following format
Code:
aaaaaaaaaaaaaaaaaaaaaaaaaaa
bbbbbbbbbbbbbbbbbbbbbbbbbbb
ccccccccccccccccccccccccccc
ddddddddddddddddddddddddddd
3186rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr
aaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaa
3186ppppppppppppppppppppppp
fffffffffffffffffffffffffffffffffffffffffff
fffffffffffffffffffffffffffffffffffffffffff
9876ttttttttttttttttttttttttttttttt
kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
ppppppppppppppppppppppppppp
yyyyyyyyyyyyyyyyyyyyyyyyyyy
9876vvvvvvvvvvvvvvvvvvvvvvv

Now i need to split this file such that all the lines before the last occurence of 3186 goes to one file and all the line after that till last occurence of 9876 should go to second file. so there should be two files one with following data:
Code:
aaaaaaaaaaaaaaaaaaaaaaaaaaa
bbbbbbbbbbbbbbbbbbbbbbbbbbb
ccccccccccccccccccccccccccc
ddddddddddddddddddddddddddd
3186rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr
aaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaa
3186ppppppppppppppppppppppp

and second file should contain:
Code:
fffffffffffffffffffffffffffffffffffffffffff
fffffffffffffffffffffffffffffffffffffffffff
9876ttttttttttttttttttttttttttttttt
kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
ppppppppppppppppppppppppppp
yyyyyyyyyyyyyyyyyyyyyyyyyyy
9876vvvvvvvvvvvvvvvvvvvvvvv

Kindly help in acheiving this.

Last edited by Scrutinizer; 07-18-2013 at 12:40 AM.. Reason: code tags
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

creating a fixed length output from a variable length input

Is there a command that sets a variable length? I have a input of a variable length field but my output for that field needs to be set to 32 char. Is there such a command? I am on a sun box running ksh Thanks (2 Replies)
Discussion started by: r1500
2 Replies

2. Shell Programming and Scripting

convert fixed length file to CSV

Newbie Looking for a script to convert my input file to delimited text file. Not familier with AWK or shell programing. Below is sample record in my input file and the expected output format. My OS is HPUX 11.23. Thanks in advance for your assistance. tbtbs input file:... (12 Replies)
Discussion started by: tbtbs
12 Replies

3. Shell Programming and Scripting

How to print string on screen according the fixed length?

Problem: entry_name="joke:hello:yellow:blue:default" print("%d %-12s\t%-10s\t%-5s\n", $i, $entry_name....); I just want to print the output like this index entry value .... 1 joke:hello:y 0 123 567 ellow:blue:d ... (1 Reply)
Discussion started by: a2156z
1 Replies

4. UNIX for Dummies Questions & Answers

What the command to find out the record length of a fixed length file?

I want to find out the record length of a fixed length file? I forgot the command. Any body know? (9 Replies)
Discussion started by: tranq01
9 Replies

5. UNIX for Dummies Questions & Answers

Convert a tab delimited/variable length file to fixed length file

Hi, all. I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file: 10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783 19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657 And this is the expected... (2 Replies)
Discussion started by: Everton_Silveir
2 Replies

6. Shell Programming and Scripting

Splitting fixed length file using awk

Hi, I need to split a fixed length file of 160 characters based on value of a column. Example: ABC 456780001 DGDG SDFSF BCD 444440002 SSSS TTTTT ABC 777750003 HHHH UUUUU THH 888880001 FFFF LLLLLL HHH 999990002 GGGG OOOOO I need to split this file on basis of column from... (7 Replies)
Discussion started by: Neelkanth
7 Replies

7. UNIX for Dummies Questions & Answers

Length of a fixed width file

I have a fixed width file of length 53. when is try to get the lengh of the record of that file i get 2 different answers. awk '{print length;exit}' <File_name> The above code gives me length 50. wc -L <File_name> The above code gives me length 53. Please clarify on... (2 Replies)
Discussion started by: Amrutha24
2 Replies

8. Shell Programming and Scripting

Break one long string into multiple fixed length lines

This is actually a KSH under Unix System Services (Z/OS), but hoping I can get a standard AIX/KSH solution to work... I have a very large, single line file in Windows, that we download via FTP, with the "SITE WRAP" option, into a Z/OS file with an LRECL of 200. This essentially breaks the single... (4 Replies)
Discussion started by: bubbawuzhere
4 Replies

9. Shell Programming and Scripting

Generate fixed length txt file

hi, i am using below query to generate the fixed length txt file. this sql is being called from shell script. This is supposed to be a fixed record file with the below definitions. There must be 2 byte filler after the CAT_ID AND each line should have total of 270 bytes. field ... (1 Reply)
Discussion started by: itzkashi
1 Replies
TRAYER(1)						      General Commands Manual							 TRAYER(1)

NAME
trayer - a lightweight GTK2-based systray for UNIX desktop SYNOPSIS
trayer -h trayer -v trayer [--edge left|right|top|bottom|none] [--align left|right|center] [--margin <size>] [--widthtype request|pixel|percent ] [--width <size>] [--heighttype <pixel>] [--height <size>] [--SetDockType true|false] [--SetPartialStrut true|false] [--transparent true|false] [--alpha <value>] [--tint <color>] [--distance <length>] [--distancefrom left|right|top|bottom|none] [--expand true|false] [--padding <size>] DESCRIPTION
trayer is a small program designed to provide system tray similar to these in GNOME / KDE desktop environments for window managers which does not support that function. It is similar to other applications such as peksystray and docker. System tray is a place, where many applications put their icons, so they are always visible. Such icons may present status of an applica- tion and allow user to control the program. trayer's code was extracted from fbpanel application, you can find more about it on its homepage: http://fbpanel.sourceforge.net/. OPTIONS
This programs follow the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options is included below. --help -h Show summary of options and exit. --version -v Show version of program and exit. --edge left|right|top|bottom|none Specifies a screen edge to use. --align left|center|right Specifies an align of the icons. --margin <size> Specifies length of margin (in pixels) --widthtype request|pixel|percent Specifies method of calculating trayer's window width: request Follow application icons' size, so trayer may shrink or expand dynamically. pixel Set a fixed size, given with --width option in pixels. percent Set a fixed size, given with --width option in percentage of a length of screen edge. --width <size> Width of trayer's window. Ignored when --widthtype is set to request. --heighttype request|pixel|percent Specifies method of calculating trayer's window height: request Follow application icons' size, so trayer may shrink or expand dynamically. pixel Set a fixed size, given with --height option in pixels. percent Set a fixed size, given with --height option in percentage of a length of screen edge. --height <size> Height of trayer's window. Ignored when --heighttype is set to request. --SetDockType true|false Identify panel window type as dock. --SetPartialStrut true|false Reserve panel space so that it will not be covered by maximized windows. --transparent true|false Use transparency. --alpha <value> Percentage of transparency (0 - nontransparent, 255 - fully transparent) --tint <color> Color used to tint transparent background. Color is given as a 24-bit C hexadecimal integer, for example: 0xff0000 is red, 0xff8800 is orange and 0x00ff00 is green. --distance <length> Specifies distance between trayer's window and screen edge (in pixels) --distancefrom <edge> Specifies which edge to calculate distance from, see above. --expand true|false Specifies whether trayer may accommodate extra space when there is too much icons. --padding <size> Extra space between icons and trayer window's border. --monitor NUM|STRING Define the monitor on which you like trayer to appear, number of zero to number of monitors minus one, or the string "primary" are valid. The default value is 0. SEE ALSO
fbpanel(1) AUTHORS
Anatoly Asviyan <aanatoly@users.sf.net> - fbpanel Rafal Bisingier <ravbc@man.poznan.pl> Maciej Delmanowski <harnir@users.berlios.de> Grzegorz Nieweglowski <hoppke@dobremiasto.net> Thomas Rydzynski This manual page was written by Tomasz Melcer <liori@interia.pl>. FVWM-Crystal Feb 14, 2005 TRAYER(1)
All times are GMT -4. The time now is 11:43 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy