Shell Programming and Scripting

Please help

Need a script which will do the following :

Search on fixed width file , go to position (25,2) which means 25th and 26th position, Find if there are any char in lower case:

For example 25,2 can be (9T) or (9w) or (Ww) or (wW)....The two positions can be numeric or alpha...no special char,

Then should get converted to upper case, 9T, WW or IT.

So the output should be entire line where 25,26 positions are in upper case.

_string="this is A Test scRipt fhefihgrewhio ewrfjoip";
change_start=25;
no=2;
change_end=$((change_start + no - 1))
str1=`echo ${_string} | cut -c1-$((change_start - 1))`
str2=`echo ${_string} | cut -c${change_start}-${change_end} | tr "[a-z]" "[A-Z]"`
str3=`echo ${_string} | cut -c$((change_end + 1))-`
echo "$str1$str2$str3"


try this...Im sure there might be simpler ways...

this would work fine on single record...i have 400 million rows on which this should work

Try it with awk:

Code:

awk '{print substr($0,1,24)toupper(substr($0,25,2))substr($0,27)}' file > newfile

Regards

if you have PHP

Code:

<?php
$filename="file";
if ( $handle = fopen($filename,"r") ){
    while( ! feof($handle) ){
        $line = fgets($handle,4096);
        $toreplace = strtoupper(substr($line,24,2));        
        echo substr_replace($line,$toreplace,24,2);
    }   
    fclose($handle);
}
?>

awk '{print substr($0,1,30)toupper(substr($0,31,2))substr($0,33)}' /tmp/test.dat > /tmp/abc.dat

tried on the below sting

10001da 20080925LHR BAH gf 0006V 20080818001SSA9122278L4NB 20250510 LHR

gave back the same....any mistake in the way i have changed code

If the spaces in that example are correct, the substring at offset 31 is 6V which is already uppercase.