Performing mathematical operations

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

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

Performing mathematical operations

Post by jmbarnet »

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

Post by DataMystic Support »

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