Search Results

hi all,

I have oracle table which has like below example in col7 & col8 there will be values seperated , in one column it is kind of horizontal pivoting but the data is in 1 column seprated , ...

When I am trying it is not working the error it is giving is
$ nawk -F, '$8=sprintf("%.2f", $8)' OFS=, teat.txt
nawk: can't open file teat.txt
source line number 1
$

If i use this code
sed -e 's/, *0*\./,0./' -e 's/, *0.*\([1-9]\)/,\1/' sample.txt
00125
0245
If i use this code
nawk -F, '$8=sprintf("%.2f", $8)' OFS=, sample.txt
00125,,,,,,,0.00...

removing leading zeros for a decimal column in a file which has string & decimal values

,,,,,6630140,XXXXXXXXXXXXXXX, 0020.00,USA
,,,,,6630150,XXXXXXXXXXXXXXXL (xyz, 0010.00,USA...

#! /usr/bin/ksh
cd /local/apps/Datastage/projects/HCP_Sharp_Tst/RejectFiles/
wc -m Reject_UK_VAT.txt

it is returning ***8 Reject_UK_VAT.txt***

value 8 then file name
but i need only value 8...

I am haveing one file I need to check whether the file size > 0 or not? any one could share ideas

thanks for your answer I got wat I need thanks for your help:):):):)

I am haveing one script haveing one issue with this could any one can reply soon it is very urgent.
:p
if ssh hcp_ftp@$1 'ls '$2/stop.txt' 1>&2 2>/dev/null'; then exit 1;
else
scp -p...