UNIX for Advanced & Expert Users

can someone help me out with this please?...

First, you could read "man cut" to find out how the cut command is working and how to change it according to you data.

Second, just change the 8-40 to 10-40!!

Third!! your original command was:

Code:

cut -c8-40 file_log

so you should have added the sed at the end as:

Code:

cut -c8-40 file_log | sed ....

Not after 40!?!?!

THnaks for the reply.

The output of the script is

PBX TYPE:CC3 ,NSH

note the space between CC3 and ,NSH


I would want this to be :

CC3,NSH

My script is like this. Please reveiw.

##!/usr/bin/sh -x
##Initialising variables

FROM_DIR=/usr/local/Sandeep_test/santest; export FROM_DIR

PBX_TXT="****** PBX"; export PBX_TXT

echo "----------------------------LIST OF INCORRECT PBX/SWTICH TYPE FOUND--------------------------"

echo "----------------------------LIST The CORRECT PBX/SWTICH TYPE---------------------------------"
cd $FROM_DIR

for file in $FROM_DIR/LEE*.cc3

do

grep '^...... PBX' $file > file_log

cut -c10-40| sed 's/ PBX-id: /,/' file_log

done
exit 0

This is NOT the script that you're running!!!

The "cut" has STILL no File-Parameter and is piped to the "sed" which has the File-Parameter.

You should have missed ONE OF THE BLANKS in "/ PBX-id: /,/" !!!

##!/usr/bin/sh -x
##Initialising variables

FROM_DIR=/usr/local/Sandeep_test/santest; export FROM_DIR

PBX_TXT="****** PBX"; export PBX_TXT

cd $FROM_DIR

for file in $FROM_DIR/LEE*.cc3

do

grep '^...... PBX' LEECOUNTY.cc3 > file_log

cut -c8-40 > file_log1

sed 's/ PBX-id: /,/' file_log1 > file_log2


done
exit 0



This is the script and when i cat file_log2 the output is:

PBX TYPE:IDC4 ,L14
PBX TYPE:IDC3 ,L12
PBX TYPE:IDC5 ,L13

Note there is lot of space between IDC4 and ,L14

Desired output would be:
IDC4,L14
IDC3,L12
IDC5,L13

OK apparantly you have more than ONE BLANK around the text!!

Please use:

Code:

sed 's/ *PBX-id: */,/' file_log1 > file_log2

Note the '*' after each blank.