Need help with a manual task


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need help with a manual task
# 1  
Old 10-22-2008
Need help with a manual task

I have an ASCII file that I receive on a monthly bases that is fixed length. I break the file into separate files based on a 5 character numerical sequence. I have 20 different sequences I have to find.

the input file looks something like this
xy-ins 2008yuthnrlsinrthsntwilgrha33260001 sslh12 0000000000000
xy-ins 2008yuthnrlsinrthsntwilgrha33270001 sslh12 0000000000000
xy-ins 2008yuthnrlsinrthsntwilgrha33277001 sslh12 0000000000000

I want to copy every line that contains that sequence in that same position to a new file retaining the same format.

I'm not looking for someone to hand me a script but would be the best way of doing this. I do prefer using bash as my shell and thinking about using awk and a some type of loop. However, I have not used awk and would consider my skillset in this arena as a "noobie"...

thanks in advance for your suggestions.
# 2  
Old 10-22-2008
Code:
awk '{print > substr($0,35,5)}' file

# 3  
Old 10-22-2008
Hammer & Screwdriver Here is a first step

Code:
> cat file295
xy-ins 2008yuthnrlsinrthsntwilgrha33260001 sslh12 0000000000000
xy-ins 2008yuthnrlsinrthsntwilgrha33270001 sslh12 0000000000000
xy-ins 2008yuthnrlsinrthsntwilgrha33277001 sslh12 0000000000000
> cat file295 | cut -c36-40 | sort -u
32600
32700
32770

This second command will give you a sorted listing of all entries at that character position. Maybe you will pipe it into the next command, or perhaps just write that output to a work file.

From that list, you want to 'grep' or 'awk' records based on those values to separate into your respective files.

Try to build on this, and respond back if stuck again.
# 4  
Old 10-23-2008
Thanks for the idea's... got me in the right direction. So this is what I'm playing with

nawk '/33260/ == substr($0,37,5) && /33260/ == substr($0,1,5){print $0 > "file"}' 76138.txt

bailing out at source line 1 is the error I get.

I'm trying to tell it to match that pattern in only those locations.
# 5  
Old 10-24-2008
Nevermind I think I can go with this instead...

nawk '/33260[01]0[01]+ /{print $0 > "file"}'

thanks again for your help.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Automation of manual process

my problem step by step... 1.I have 5 files at the location (/usr/abc) for example file1, file2, file3, file4 and fe.ok 2. I have to transfer 2 of the above files from which one is fixed file (fe.ok) for example file1 and fe.ok to usr/dob using cp command. 3.After transferring i will... (2 Replies)
Discussion started by: j_panky
2 Replies

2. Shell Programming and Scripting

No Manual Entry

Hi, While executing the following command i am getting output as command not found. iostat output: command not found Also, man iostat is displaying "NO Manual Entry" Why is it so? (5 Replies)
Discussion started by: salil2012
5 Replies

3. Shell Programming and Scripting

Exiting a manual

I'm sure it's really easy, but I have searched on Google and on the forums and haven't found anything. For instance, if I open the grep manual (man grep), I can't close it. I've tried ctrl+c, ctrl+x, scrolling to the bottom of the manual. How can I exit the manual without closing the shell? ... (8 Replies)
Discussion started by: dennis89
8 Replies

4. Shell Programming and Scripting

Parse an XML task list to create each task.xml file

I have an task definition listing xml file that contains a list of tasks such as <TASKLIST <TASK definition="Completion date" id="Taskname1" Some other <CODE name="Code12" <Parameter pname="Dog" input="5.6" units="feet" etc /Parameter> <Parameter... (3 Replies)
Discussion started by: MissI
3 Replies

5. Shell Programming and Scripting

NDM manual

Hi, Can any of you tell me how to get this ndm manual stuff? I need it to know specific error ids and descriptions Thanks, Vinodhini (1 Reply)
Discussion started by: vinodhini4
1 Replies

6. Shell Programming and Scripting

comment and Uncomment single task out of multiple task

I have a file contains TASK gsnmpproxy { CommandLine = $SMCHOME/bin/gsnmpProxy.exe } TASK gsnmpdbgui { CommandLine = $SMCHOME/bin/gsnmpdbgui.exe I would like to comment and than uncomment specific task eg TASK gsnmpproxy Pls suggest how to do in shell script (9 Replies)
Discussion started by: madhusmita
9 Replies

7. Shell Programming and Scripting

unix manual needed :)

hi guys... am new 2 dis unix world... am in need of a unix manual... cud sum1 pls post sum links 2 download it?>?>? :confused: Danks in advance... ;) ;) ;) (1 Reply)
Discussion started by: sundar_shankar
1 Replies

8. Shell Programming and Scripting

Shell Programming Manual

Hi How are you every body? Could you please send me a link to shell programming manual on sun solaris 5.8 Thanks (4 Replies)
Discussion started by: so_friendly
4 Replies

9. UNIX for Dummies Questions & Answers

No manual entry for

I don't seem to be able to get man pages up for any command. When I try the "No manual entry for..." message is displayed. When checking my $MANPATH variable I get the following /opt/SUNconn/man: However, when I check this directory it doesn't exist. Searching for any man directories results... (3 Replies)
Discussion started by: FattyLumpkin
3 Replies
Login or Register to Ask a Question