Newbie on arithmetic - help request on arithmetic operation

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

batuco9
Posts: 1
Joined: Sun Sep 14, 2003 4:03 am

Newbie on arithmetic - help request on arithmetic operation

Postby batuco9 » Sun Sep 14, 2003 4:11 am

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

User avatar
DataMystic Support
Site Admin
Posts: 2164
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Fri Oct 03, 2003 5:34 am

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.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Baidu [Spider] and 11 guests