Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHad to peek at yours to figure it out - I was not familiar with RegEx before.
I studied up and got the concept. Thanks for the help!
Of course I got it wrong! Shows you how often I use message boards...
Super elegant solution here Aaron. I had to study it a bit to understand what you did.
@Erin Nice catch! Looks like an issue with a character in the input file that looks like 1 character but is ending up translated somewhere as 2, so it's throwing off the character counts on that record. Special characters are always fun when working with data... *oops*
I'll have an updated start file/solution uploaded asap! Thanks for the diligent sleuthing 🙂
NJ
Thanks for this great ACE Challenge 🥁✨🥇 @NicoleJohnson! I'm sure you'll inspire other ACEs to follow your lead @RolandSchubert , @Ladarthure, @carlosteixeira 😎!
The workflow is downloaded as a packaged workbook and the files are relative. Therefore if you re-save the workflow into a different folder then the relative paths don't know where your data is, I suggest either saving the workflow in the same folder as you downloaded it, or changing the file paths to locate the original files.
Can I have my extra credit please.
Then part c using regex to parse out the fields based on field size, then rebuilding it back to the report table structure.
Always good to test my ability to parse. This happens in the real world all over the place.