Network Automation Software We are currently migrating this forum
over to our HelpSystems domain. Please
post all new threads in our new
HelpSystems Community Portal.
Post to the HelpSystems Forum
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: Task help:If Text Contains
Topic Summary:
Created On: 07/20/2018 08:12 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.
 07/20/2018 08:12 AM
User is offline View Users Profile Print this message

Author Icon
StephenHenderson
n00b (>6 posts)

Posts: 2
Joined: 07/20/2018

I'm trying to scan text files we're moving from our sFTP to our network share for special characters. I'm having a hard time figuring out which actions to use to complete this task.

I've been looking at "If text contains" but I'm having trouble searching for multiple possible characters to stop the task.

Basically I want to search a text file that I move for any special characters (Text file can only have letters, numbers and spaces) and stop the task if it finds one.

Can you help?

 Category Survey
AutoMate BPA Server 10 version: 10.4.2
Windows version: Windows Server 2008 R2
 07/23/2018 01:57 PM
User is offline View Users Profile Print this message

Author Icon
Alex Escalante
HelpSystems

Posts: 871
Joined: 02/26/2014

Hello Stephen,

You are on the right track to look for special characters. However you will need to combine it with other actions to look through a text file.

We suggest first reading the entire file into a variable. Once it is read, you can use the "loop list" action to loop through the file line by line (make sure to set the delimiter to "new line"). Inside of the loop, use the "if text contains" action to look for the character. In essence you will be looking for that character line by line of the file.

Attached you will find an example of this procedure. I have added dialog boxes to show you the current line, and one to show when the character is found. Make sure to put the sample file under C:\temp.

Please let us know if that works for you.

Thanks.

 Category Survey
AutoMate BPA Server 10 version:
Windows version:


7 23.zip
7 23.zip  (1 KB)



-------------------------

Alex Escalante | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665
Statistics
18258 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 5551 on 01/08/2018 at 11:11 AM.
There are currently 1210 guests browsing this forum, which makes a total of 1210 users using this forum.

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

Sitemap Network Automation Software Blog