Recent content by sandeepmur

think i got it .. had to select just the columns needed.. thnx

I tried the sort option (though not sure if it would remove the blank lines) but I get an error message: "This operation requires the merged cells to be identically sized " any suggestions? thnx

Hi, How can I delete the blank lines in my excell sheet ? the blank lines appear inbetween the data.. Is there somehow I can delete all the blank lines at once ? thnx

Hi, How do I determine if a given number is an int value or not ? i.e if the value is not a positive int or zero I want to reject the value. thnx

hmm.. u r right bout the sample data.. thing is I am executing the cmd over a large config file which has the fwg structure.. ### ## comments data <--- blank line data <-- blank line *abc # comment executing the cmd over this file is not getting the desired results :(.. can I do this...

for ex. I executed the cmd sort -k 4,4 test over a file containing : adb asdfa bvv.tra SBL adb adsgh vbv.tra SBL adb yertert dfa.tra TIP adb bvxxcbcxb sdfasd.tra SBL|ttt adb ertwert adf.tra NL adb jfdjhsg...

I tried executing the command sort -k 4,4 components.cfg directly in shell. The cmd seems to be doing something since the file is formatted differently but the data is not being grouped together. not sure why...

No rules applicable.. The only requirement is that the data be grouped together.. it could be : TIP, NL , SBL or SBL,TIP,NL and so on... thnx

The file structure is: adb asdfa bvv.tra SBL adb adsgh vbv.tra SBL adb yertert dfa.tra TIP adb bvxxcbcxb sdfasd.tra SBL|ttt adb ertwert adf.tra NL adb jfdjhsg werw.tra SBL adb gfssfss gnf.tra NL adb nxbsfg rewr.tra NL I need to order all the data to...

Hi, I have a file with 5 columns of data in it and I need to group the data according to the 5th column not really sort.. The data in my 5th column reads something like: SAP SAP SBL TTT SBL SBL SBL SAP I want to obtain all the data but ordering them according to the 5th column.. I tried...

works great now.. thnx.. although I would appreciate if you can just explain the need for $(eval echo \${${i}}) . thnx again

A small problem here.. The first cmd (for i; do echo "'$i'"; done) works and prints all the parameters but I need the parameters starting the 7th parameter onwards (dont want the parameters 1 - 7). The 2nd soln using while works similar to the one I posted but both have a small problem.. The...

hi, I need to obtain all the variables sent to a shell script.. I am currently doing the fwg but it doesnt seem to be working very well.. tArgs=$# tArgs=`expr $tArgs + 1` i=7 while [ $i -lt $tArgs ] do echo $i eval echo \$$i i=`expr $i + 1` done can anyone pl provide a better soln ? thnx

unfortunately, its not getting the desired output.. I followed your suggestion and copied the files that I do not want to delete in to a temp dir, but executing the above cmd still deletes the files anyway..ie, the grep portion of the cmd is being ignored... thnx

Hi, I am deleting some old files in the fwg manner: touch 200506271823 /home/temp/tempdate.txt rm `find . ! -newer /home/temp/tempdate.txt -type f` The above works perfectly but I have a small problem.. There are some files in the current dir which I dont want to delete. How can I "exclude"...