Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I convert numeric from 123.45- to -123.45 1
- Thread starter Tison
- Start date
-
1
- #2
KenCunningham
Technical User
This script works:
sed -f changeminus minus > newfile
for number in `cat newfile`
do
echo '-'$number >> newfile1
done
'changeminus' is a sed script containing the following line:
sed -f changeminus minus > newfile
for number in `cat newfile`
do
echo '-'$number >> newfile1
done
'changeminus' is a sed script containing the following line:
KenCunningham
Technical User
Oops sorry - touch of premature submitting there!
:~/
Anyway, to continue. The sed script consists of one line as follows:
s/-//g
The word 'minus' should be replaced by your real filename.
Hope this helps. No doubt there's a far easier way to do this in awk, and no doubt someone will be along soon to explain how! Cheers.
:~/
Anyway, to continue. The sed script consists of one line as follows:
s/-//g
The word 'minus' should be replaced by your real filename.
Hope this helps. No doubt there's a far easier way to do this in awk, and no doubt someone will be along soon to explain how! Cheers.
- Thread starter
- #4
KenCunningham
Technical User
Ah, now you didn't say that did you ;-)? Are the positives in a similar format at the moment (ie nnnn.nn+) or do they have no sign at all? Regards.
- Thread starter
- #6
They have no sign
AND
they are not the only column in each record.
What do you think of this ;
while read CD CRN FUND AMT
do
if ( echo $AMT | grep -c "-" > /dev/null )
then
AMT=`echo $AMT | sed s/-// `
AMT=`echo "-"$AMT`
fi
echo "$CD \t $CRN \t $FUND \t $AMT" >> outfile
done < infile
AND
they are not the only column in each record.
What do you think of this ;
while read CD CRN FUND AMT
do
if ( echo $AMT | grep -c "-" > /dev/null )
then
AMT=`echo $AMT | sed s/-// `
AMT=`echo "-"$AMT`
fi
echo "$CD \t $CRN \t $FUND \t $AMT" >> outfile
done < infile
Very quickly - I created a data file called x which contains
FIELD1 123.45- 123
abdc 12.45 123
abcd 1.20- 123
I created the following file called x.sh
while read -r f1 f2 f3
do
echo $f1"\t\c"
LENGTH=`expr $f2 : ".*"`
LENGTH1=`expr $LENGTH - 1 `
SEP=`echo $f2 | cut -c$LENGTH`
if [ "$SEP" = "-" ]
then
REST=`echo $f2 | cut -c1-$LENGTH1`
echo $SEP$REST"\t\c"
else
echo $f2"\t\c"
fi
echo $f3 "\n"
done < x
execute x.sh , which reads a line at a time form the input file and checks the length of field 2 - see's if the last char is a -, if so print the - then the rest of the string - otherwise just print the string.
I'll put something together in awk also
FIELD1 123.45- 123
abdc 12.45 123
abcd 1.20- 123
I created the following file called x.sh
while read -r f1 f2 f3
do
echo $f1"\t\c"
LENGTH=`expr $f2 : ".*"`
LENGTH1=`expr $LENGTH - 1 `
SEP=`echo $f2 | cut -c$LENGTH`
if [ "$SEP" = "-" ]
then
REST=`echo $f2 | cut -c1-$LENGTH1`
echo $SEP$REST"\t\c"
else
echo $f2"\t\c"
fi
echo $f3 "\n"
done < x
execute x.sh , which reads a line at a time form the input file and checks the length of field 2 - see's if the last char is a -, if so print the - then the rest of the string - otherwise just print the string.
I'll put something together in awk also
- Thread starter
- #8
- Status