UNIX for Advanced & Expert Users

###----------------------TEST FOR $ Value------------------------
sort $RTF 2>>$LOG | nawk -F\| '\
{
for( i=1; i<=NF; ) {
if( i == NF )
{
amt=substr($i,1,1) #$ value
if (amt == /^ *[0-9] /)
printf( "$%s\n", $i );
else
printf( "%s\n", $i );
}
else
printf( "%s|", $i );
i++;
}
}' >$RFF 2>>$LOG
###---------------------------------------------------------------

I need an actual $ symbol in front of the value that is stored in NF (last value after the pipe. I tried both awk & nawk & it would not give me the result.

it's somewhat difficult what you're trying to do - seems that you already have '$' in the last field.

Could you post a sample input and a desired output, pls!
pls use vB Codes when posting samples.

ITEM67|WFLX|39.99
ITEM68|WGEN|new
ITEM72|WGEN|new
ITEM73|WGEN|new
ITEM75|WGEN|new
ITEM76|WGEN|new
ITEM78|WFLX|39.99
ITEM80|WGEN|new
ITEM83|WGEN|new
ITEM84|WFLX|44.99
ITEM85|WFLX|39.99

so if there is only a 39.99 or 44.99 I want it to have a '$' sign in front.

Once again, post a sample input anda desired output.

nawk -F'|' -v OFS='|' -f sd.awk myFile.txt

sd.awk:

Code:

$NF ~ "^[0-9.][0-9.]*$" { $NF = "$" $NF }
1

Thanks a lot. That worked.