I have a flat file that is |(pipe) delimited and it has multiple records. I want to check each record and between all pipes for a preset amount of characters that I have define and have it fail if the characters exceed the check. Here is an example:
|THOMAS|CROWN|05/01/2009|123 MAIN STREET|...etc
WHERE the max characters are as follows for the matching column:
|(max length of 25)|(max length of 25)|(max length of 10)|(max length of 100)|....etc
I am unsure on where to even start with this. Any help would be awesome. I have found some question that are similar, but to no success.
|THOMAS|CROWN|05/01/2009|123 MAIN STREET|...etc
WHERE the max characters are as follows for the matching column:
|(max length of 25)|(max length of 25)|(max length of 10)|(max length of 100)|....etc
I am unsure on where to even start with this. Any help would be awesome. I have found some question that are similar, but to no success.