Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Script

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Script
# 1  
Old 02-10-2005
Script
Dear Friends,

In the filebelow, i have three fileds.
Code:
09C97          4 NAT'L GRP LIFE, DALLAS                                      
09C98          4 COMMERCIAL INS.                                             
09C99          4 COMMERCIAL INSURANCE                                        
09D00         99 D.O.C. 2000                                                 
09D07         99 D O C FULL COVD07                                           
09D20          2 DOC MEDOBS   D20                                            
09D30          2 D.O.C. MCARE B-OUTPATIENT 

I need something like this: 

09C97          4 NAT'L GRP LIFE, DALLAS                                      
09C98          4 COMMERCIAL INS.                                             
09C99          4 COMMERCIAL INSURANCE                                        
09D00          99D.O.C. 2000                                                 
09D07          99D O C FULL COVD07                                           
09D20          2 DOC MEDOBS   D20                                            
09D30          2 D.O.C. MCARE B-OUTPATIENT

look at the 4,5 records for the second and third fields
Last edited by Perderabo; 02-10-2005 at 05:00 PM.. Reason: add code tags for readability
# 2  
Old 02-10-2005
ok - I'm looking Smilie
Can you describe in words what you're trying to do?
# 3  
Old 02-10-2005
It looks like he removed the space between the 2nd and 3rd field...i. e. he wants fields 3 to always start in the exact same column.
# 4  
Old 02-10-2005
Quote:
Originally Posted by Perderabo
It looks like he removed the space between the 2nd and 3rd field...i. e. he wants fields 3 to always start in the exact same column.
or does he want to concatenate fields 2 and 3 IF field2=99 ?
# 5  
Old 02-10-2005
Quote:
Originally Posted by vgersh99
ok - I'm looking Smilie
Can you describe in words what you're trying to do?
This is a fixed width flatfile and im loading this into a table.and the positions are 1:15,16:17,18:77 ..but the file shows '99' starting at position 14 and so a part of it is coming into field one when loaded.i.e
Code:
09D07         9            9             D O C FULL COVD07    instead of

09D07                      99            D O C FULL COVD07

Last edited by Perderabo; 02-10-2005 at 05:02 PM.. Reason: add code tags for readability
# 6  
Old 02-10-2005
Are you okay with the following ?


Code:
$ cat file1 | tr -s " " | cut -d" " -f 1 > x1
$ cat file1 | tr -s " " | cut -d" " -f 2- > x2
$ paste x1 x2
09C97   4 NAT'L GRP LIFE, DALLAS 
09C98   4 COMMERCIAL INS. 
09C99   4 COMMERCIAL INSURANCE 
09D00   99 D.O.C. 2000 
09D07   99 D O C FULL COVD07 
09D20   2 DOC MEDOBS D20 
09D30   2 D.O.C. MCARE B-OUTPATIENT 
$


Code:
$ cat file1 | tr -s " " | tr " " "\t" | tr -s "\t" " "
09C97 4 NAT'L GRP LIFE, DALLAS 
09C98 4 COMMERCIAL INS. 
09C99 4 COMMERCIAL INSURANCE 
09D00 99 D.O.C. 2000 
09D07 99 D O C FULL COVD07 
09D20 2 DOC MEDOBS D20 
09D30 2 D.O.C. MCARE B-OUTPATIENT

# 7  
Old 02-10-2005
something closer:

nawk -f thumps.awk file
thumps.awk:
Code:
$2 > 9 {
  $1=sprintf("%-14s", $1)
  $2=(sprintf("%-2.2s", $2) $3);$3=""
}
1
Login or Register to Ask a Question

Previous Thread | Next Thread

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to block first bash script until second bash script script launches web server/site?

I'm new to utilities like socat and netcat and I'm not clear if they will do what I need. I have a "compileDeployStartWebServer.sh" script and a "StartBrowser.sh" script that are started by emacs/elisp at the same time in two different processes. I'm using Cygwin bash on Windows 10. My... (3 Replies)
Discussion started by: siegfried
3 Replies

2. Shell Programming and Scripting

Shell script works fine as a standalone script but not as part of a bigger script

Hello all, I am facing a weird issue while executing a code below - #!/bin/bash cd /wload/baot/home/baotasa0/sandboxes_finance/ext_ukba_bde/pset sh UKBA_publish.sh UKBA 28082015 3 if then echo "Param file conversion for all the areas are completed, please check in your home directory"... (2 Replies)
Discussion started by: ektubbe
2 Replies

3. UNIX for Dummies Questions & Answers

Calling a script from master script to get value from called script

I am trying to call a script(callingscript.sh) from a master script(masterscript.sh) to get string type value from calling script to master script. I have used scripts mentioned below. #masterscript.sh ./callingscript.sh echo $fileExist #callingscript.sh echo "The script is called"... (2 Replies)
Discussion started by: Raj Roy
2 Replies

4. Shell Programming and Scripting

Script will keep checking running status of another script and also restart called script at night

I am using blow script :-- #!/bin/bash FIND=$(ps -elf | grep "snmp_trap.sh" | grep -v grep) #check snmp_trap.sh is running or not if then # echo "process found" exit 0; else echo "process not found" exec /home/Ketan_r /snmp_trap.sh 2>&1 & disown -h ... (1 Reply)
Discussion started by: ketanraut
1 Replies

5. Shell Programming and Scripting

create a shell script that calls another script and and an awk script

Hi guys I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file. #!/bin/sh echo " $2 $3 $4 $5 $6 $7 isql -w400 -U$2 -S$5 -P$3 << xxx use $4 go print"**Changes to the table... (0 Replies)
Discussion started by: magikminox
0 Replies
Login or Register to Ask a Question