Page 1 of 1

Newbie on arithmetic - help request on arithmetic operation

Posted: Sun Sep 14, 2003 4:11 am
by batuco9
Is there any way to take a field and do arithmetic operaitons on it? Specifically, I want to take the inverse (1/x) of number in a given field.

Since one of the filters indicates that external programs may be invoked, can Window's "calc.exe" program somehow be invoked to calculate the inverse? Do the java or visual basic scripts allow for such a possiblity? If so, how could it be done?

By the way, I already got the formats down to csv.

Many thanks,
batuco9

Posted: Fri Oct 03, 2003 5:34 am
by DataMystic Support
Hi there,

Use a 'restrict to CSV field' to choose the data field first.

Then add a VBScript subfilter to calculate 1/x of the data and output it.

Have a look at the VBScript help and samples to see how this works.