Performing mathematical operations

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

jmbarnet
Posts: 3
Joined: Thu May 11, 2006 2:11 am

Performing mathematical operations

Postby jmbarnet » Thu May 11, 2006 10:03 pm

I need to alter some values in a CSV table when certain conditions are met. I tried using the character math filter and that just put out strange symbols in front of the number I was trying to change. I was thinking about using JScript to do it but I don't know how to reference the value being read. Anyone with experience on this that can help me out?

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

Postby DataMystic Support » Fri May 19, 2006 10:03 am

Character maths performs changes to character's ASCII values - it's not what you need.

Use a VBScript inside a restriction to a particular CSV or Tab field to perform the calculations - ensure you set the flags to remove the quotes and delimiters first.

To identify the lines, you could use a restriction to identify the field, and add a special marker like ##FOUND##, then restrict the VBScript above to only operate on lines matching ##FOUND##, and inside this, restricting to a particular delimited field.
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], Bing [Bot] and 1 guest