© 2004-2016 AutoMate, Inc.
All worldwide rights reserved
Using the split function to parse a text file
added on December 19, 2011 by David Hubbard
The sample program writes out a table text file to be used as input. Normally this would be created using a text editor such as Wordpad or Textpad. Excel could be used for table-driven processing as well. Excel is more powerful and versatile while text is faster and uses less memory. The text file of parameters is read in and separated by the character '#'. In the example it just displays the table parameters as they are read, but in general the parameters would be used to perform some table-driven process. Each line is split into three words using the Split() function and puts each word into a separate variable.
| Download This Task (2.4kb) Read Text and Split Line.aml |
Would you like to upload a Sample Task or Workflow to the User Resource Center? Click here!
|
More Sample Tasks and Workflows
|
Inline Padding Sample (task)
This sample demonstrates how to pad a string inline with leading or trailing spaces. |
Workflow Loop Sample (workflow)
This sample demonstrates how a workflow loops through a shared dataset using the evaluation object and NO loops within the tasks. |
Updating SharePoint list issue
Hi, I'm tring to update SharePoint list anf got the following error : Error message: SharePoint failed (Error : The underlying connection was closed: An unexpected error occurred on a receive.) The automate version is 9.0.4.5 (Premium + runtime) The failure step : <AMSHAREPOINT ACTIVITY="get_listitems" AM_RETRY="3" AM_RETRYDELAY="500" LIST="Agile_DMO_SAP" QUERY="<View><RowLimit>2</RowLimit></View>" RESULTDATASET="DSGetList" SITE="http://share5.mycompany.com/sites/ccs2/cma/operations" /> Please advise |
Trigger, actually: 7 to 7
I need to create (a) trigger(s) to execute my task at different frequencies depending-upon the time of day. I want my task to trigger every 15 minutes from 7a.m. till 7p.m. and then only trigger every hour from 7p.m. till 7a.m. I also want it to not trigger on Saturday nor Sunday. From what I can tell: exceptions let me do that but then stop triggering alltogether. Please write me back if you have an idea. Thanks in advance, Matt T. |
Split filename into two variables
A task has a name of 'abc_123.txt' I would like the folder name to be the prefix of the filename prior to the "_" delimiter 'C:\abc'. File 123.txt will then be placed inside C:\abc\123.txt |
Count Rows in TXT/CSV using Regular Expression
I have a *.txt or *.csv containing column headers and X rows of data. Using RegEx the task simply counts the number of rows based on carriage returns. Great for csv files that have X amount of records and you simply need a total count of rows minus the headers. |
Dataset to CSV File using Excel action
How do I create a CSV file from a dataset without using Interactivity actions inside MS Excel, ie, 'File Save As.'? Here's how to create a CSV file in one step using a dataset with our 'Excel - Set cells' activity. |
Dataset to CSV using ODS action
How do I create a CSV file from a dataset without Microsoft Excel being present on my machine? Here's how to create a CSV file in one step using a dataset with our new 'ODS (OpenDocument Spreadsheet) - Set cells' activity. |
Hide window
Using this task, you can hide the windows that are active in the field of view. Posted by Younes Raeisi |
Text Spinner/Randomizer aka Article Spinner
This task can be successfully applied in any area, be it SEO article writing, to make your content look as unique as possible every time you submit it, email marketing campaigns, to personalize your messages and adding authenticity in every message you send out, actually anything you can think of in Internet Marketing world and beyond! Input (at Step 11): put the words you want to randomly be chosen in brackets "{}", separated by "|" sign and that's it! Script automatically compiles a unique content every time you run it! Output is passed onto a variable and be used in further infrastructure. See for yourself. |
Leave a Comment