Performing mathematical operations

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Post Reply
Posts: 3
Joined: Thu May 11, 2006 2:11 am

Performing mathematical operations

Post by 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: 2237
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Post by 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.

Simon Carter, - Insulin dose calculator for Type 1 diabetes - 250,000 free software downloads

Post Reply