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
CharliePrice
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
HelpSystems

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
Statistics
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 748 guests browsing this forum, which makes a total of 748 users using this forum.

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

Sitemap Network Automation Software Blog