Recent content by viclap

Million Thanks Olaf, Good suggestion to create a log for errors or something to track what going on COPY To. I think i didn't hit the 16 MB string limit. Also, very nice suggestion to try the low level file functions of VFP which is tremendously very fast..... Vic

Hi All, I'm wandering this odd behaviour of VFP on how to solve this problem of mine. When the code below runs on the VFP IDE environment it works fine and generates an output of csv file. When the app was an exe file already, it hangs on the code of FiletoSr and StrToFile, it doesn't...

Hi All, I'm very new in python and trying to experiment on learning to process csv files and its contents. My main problem is that, it runs without an error but it only execute once meaning it process only one csv file containing in an array list. Upon checking the directory where the csv...

Thanks for the help. Have tried this solution through awk and it really works. awk -F ',' '{print $4/10'}' InputFile > OutputFile Tyvm.

I'd rather use awk if that would be the solution to my problem.... Thanks.

Hi to all, I'm new to sed and would like to know what would be the correct syntax on how to divide the a decimal number by 10 (2nd and 4th column) then the result would be on another file. Sample Data: John, 123 ,xxx, 100 David, 223, yyy, 145 Smith, 178, ccc , 240...

hi Feherke, Thanks once again. solution 1 and 2 really works . Great!!!

Hi to all, i have this kind of data: 60 , 70 , 90 , 27,345 , 10 30 , 40 , 100 , 38,900 , 12 41 , 23 , 98 , 21,200 , 09 I've wanted to remove the comma in 4th position to be able to come up with below output using perl: 60 , 70 , 90 , 27345 , 10 30 , 40 , 100 , 38900...

Sir feherke, Million Thanks for such a good advice. Now, the correct code would be: /usr/bin/perl -plaF\; -e '$_=join";",@F[0,3,4,5]' $INFLE > $OUTFLE Regards Vic

Hi All, Just a follow on this, I'm wondering why the above perl code doesn't work when the delimeter of the file is ; (semicolon)? It works well previously when the values in the file is seperated by ~ (tilde). Have tried to escape the ; but still it has no effect in the file. Is there...

Yup Got it...Thanks Feherke. Nice solution.

Hi Sir, It works with the above mentioned data but when I tried to execute it on the actual data, nothing happens, same output as with actual data. Sample contents of the actual data: LCNUTAG022_1/4/8~130~23288000~No...

million thanks feherke.

Hi All! I trying to execute this perl script to extract a particular field in a text file, luckily it works. But, right now I would to extract 3 more fields in the text file but couldnt get right syntax on how to do it. command is: perl -pe '$_ = (split(/[ \n]/)) [0] . "\n"' TestDoc.txt...

Thank you very much. This such a big help for me.