Im using values in a dataset to populate a sharepoint list.

I need to be able to query the dataset item value to determine if it is a number, and if not convert it to a zero or a blank value.

Is there a function that can easily do this?

I am using Automate 11.

Thanks a ton!

Charlie, I think you can use IsNumeric(variable)? You can use it in a if/else?


Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<AMENVVARS ACTIVITY="list" RESULTDATASET="myDataset" TYPE="user" /> <AMSHOWDIALOG>%IsNumeric(myDataset.CurrentRow)%</AMSHOWDIALOG> <AMSHOWDIALOG>%IsNumeric(myDataset(1).VarName)%</AMSHOWDIALOG>

-------------------------
Thank you for choosing AutoMate

Hamid Noorbakhsh | Senior Software Engineer
AutoMate | A Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700