Good Morning!
I have a need to report on the width of a text file. The width for this extract must be the same every time and we would like to have a validation.
I know I can easily get the length by adding a record count and counting those, but I need to be able to pull the total width of my text files.
Does anyone know a way to do this?
Thank you!
Ben
Solved! Go to Solution.
Hello @bdpowell,
If by Width you are referring to how many characters are contained in a field then this would be called the field length and we can calculate this using a formula tool. I've created a dummy workflow to show this.
Sam :)
That got me on the right track!
I ended up using another action tool to update a copy of the text file and made that 1 field. Then I just did the length formula and it worked.
Thank you,
Ben
Glad it got you sorted!
Sam :)