If there is one thing which we take very seriously at Advanced Cyber Solutions, then it is providing our customers with the best possible support and assistance with the solutions they have purchased from us.
One such example of this recently was a query from one of our customers, who automate the file movements between their suppliers and partners and their own internal processing systems. Already a long-term customer of Ipswitch MOVEit Automation, their automated file movement requirements were more than met.
Unexpected File Formatting
A new supplier of theirs posed a challenge by presenting files which were using an alternative format to that which their processing systems expected. Where they would normally expect pipe delimited CSV files and the use of a full stop as a decimal separator for numbers, instead they were provided files with a semicolon and comma respectively.
This | is | a | test | 1.00 This | is | another | test | 22.00
This ; is ; a ; test ; 1,00 This ; is ; another ; test ; 22,00
And so the question posed to us was, how could Ipswitch MOVEit Automation be configured to not just move the file, but also manipulate it so that it is converted into a format accepted by their processing systems?
Ipswitch MOVEit Automation contains a number of predefined scripts, as well as the capability to import custom scripts, for processing files as they are transferred.
In this particular case, a predefined script called "Find or Replace" can be used to find instances of semicolons and commas and replace those with the pipe and full stop required.
Ipswitch MOVEit Cloud meets all of the NCSCs cloud security principles - Want to learn more? Read our blog here.
Using two instances of the script, we can find each of those characters and have them replaced by another. The parameters available for this task are as follows:
FindorReplace_Action - Replace or Find. Find will simply count the instances of the found character(s).
FindorReplace_CaseSensitive - Determines whether the replace or find actions are case sensitive.
FindorReplace_Find - The character or characters to be searched for in the file.
FindorReplace_Replace - The character or characters which replace those found in the find parameter.
The result is a task which collects files from a source; places them into a loop; each file is run through the find and replace scripts; and finally the files are placed onto the destination.
The outcome is that the supplier can continue to supply files in format which is standard to their output system; and our customer receives those in a format which their processing systems expect. All being held together by Ipswitch Automation, without any human interaction or manipulation of files.
Best of all, not a single custom script has had to be written.
Happy customer, happy supplier...and their business continues its automated operations with little effort.