Challenge #302: International Bank of Awesome Data - Part I

[kimlam]

My first time posting a solution. Please feel free to provide feedback. Thank you!

Spoiler

Also, I have a question. After working through Region C, I figured out I could apply the same approach (based on length of the fields) to Region B. I saw the hint say each field of Region B file contains 40 characters. How did you arrive to this number?

[AngelosPachis]

Challenge #302 is done!

Spoiler

[BSilverblatt]

Thanks for the challenge! This is my solution:

[mbogusz]

Spoiler

Weekly Challenge #302 in the can

[ryan-bush]

Spoiler

Great challenge for those looking to upskill on data prep! 

[Tony_Castillo]

Spoiler

Region A and B only

[hayleematecko]

Extra credit was quite the challenge, hoping to get to that piece soon!

[juliabarale002]

🏦

[KaneG]

Now that's a fun challenge. I'm so out of practice, but the urge is still there to make it as dynamic as possible. Minimal changes would need to be made if fields changed. I was tempted to pull out CReW Dynamic Formula for the REGEX, but it wasn't too hard to dynamically build the REGEX without it. I would like to make a lookup table to rename the fields...

Spoiler

[LiuZhang]

Spoiler

Few issues encountered. For C, don't know who to join for the final stage, how to join the Bank Branch to individual Bank Account.