Network Automation Software
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
Topic Title: Check Dataset Value, if not a number change value to 0
Topic Summary:
Created On: 06/19/2018 11:57 AM
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
 06/19/2018 11:57 AM
User is offline View Users Profile Print this message

Author Icon
n00b (>6 posts)

Posts: 3
Joined: 07/06/2016

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!
 06/19/2018 03:51 PM
User is offline View Users Profile Print this message

Author Icon
Hamid Noorbakhsh

Posts: 454
Joined: 07/29/2008

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)

Thank you for choosing AutoMate

Hamid Noorbakhsh | Senior Software Engineer
AutoMate | A Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700
18257 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 6686 on 11/01/2020 at 01:24 AM.
There are currently 1032 guests browsing this forum, which makes a total of 1032 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2021 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog