checking flat bfile

If you have a new question you’d like our support staff to post a response to, please visit our customer community, GoAnywhere Insiders, to pose the question in our Discussion Boards. We have a thread “Ask Our Tech Experts” that our support team monitors on a regular basis, or you can start a new discussion where other GoAnywhere users and support staff can weigh in. Log in or create your new account at https://insiders.goanywhere.com.

If you need an immediate response, please create a support ticket or contact our support team by email at [email protected].
2 posts Page 1 of 1

ehersh

Posts: 56
Joined: Mon Sep 26, 2016 12:50 pm

Post by ehersh » Fri Jul 28, 2017 3:50 pm
We currently have a process of manually checking flat files for errors. We scroll all the way to the right. slowly moving down checking to see if any CRLF's are out of alignment. then if they are we fix that record. It may be a blank line, it may have a special character inserted etc. I know GOANYWHERE can read flat files and we can designate the delimiter but is there any way we can use GOANYWHERE to check a flat file and if any record delimiters are out of alignment to let us know which line that happened on? Then we can just go to that line and fix the record.

Support_Julie

User avatar
Support Specialist
Posts: 91
Joined: Thu Mar 05, 2009 3:49 pm
Location: Ashland, NE USA

Post by Support_Julie » Tue Sep 12, 2017 2:17 pm
The Validate Rowset task was added in version 5.4.1 and then enhanced in Version 5.5.2.

The Validate RowSet task allows you to validate the data contained in a RowSet that was generated by tasks that read the contents of a file or database (for example, SQL or Read CSV tasks). This is useful for identifying problems with data before it is used in another task, such as inserting it into a database or translating it to another file format.

The Validate RowSet task can be used to determine if the RowSet contains a minimum or maximum amount of rows in the RowSet. The task can additionally determine if the expected number of columns are present, can verify the data in the column meets specified conditions, or the data is of the correct data type and format.

In your situation, you would read the file and save to an output rowset. Then using the Validate Rowset Variable task, verify if a column has a certain value. This would be accomplished by using a substring expression. The online help for this task includes a very nice example.
Julie Rosenbaum
Sr Support Analyst
e. [email protected]
p. 1.800.949.4696
w. HelpSystems.com
2 posts Page 1 of 1