Recently I was requested by a client to help with a legacy data migration to Oracle. The data resided in flat files generated from an IBM AS400 in csv and other text formats. Part of the migration was to read through the text lines that contained lines of text which needed to be tokenized and then inserted into different columns. What follows are the atomic PL/SQL functions that I wrote to break down the legacy data lines into tokens which can then be manipulated and used to populate the normalized target schema. I hope you find this useful as a foundation to develop more complex parsing algorithms.
About the Author: David Rincon
David Rincon, with a journey beginning in 1992, has dedicated over three decades to Oracle technologies. As the Founder and Managing Partner of Cornerstone Data Systems, INC., David and his team prioritize understanding their clients' needs, aiming to maximize the value of their technology investments.
Prior to Cornerstone, David established The DBA Group, LLC, an Oracle-focused firm which was later acquired by Zanett in 2007, a NASDAQ-listed company subsequently absorbed by KPMG.
Apart from his business ventures, David shared his expertise as a consultant instructor for Oracle University, guiding many on the Oracle DBA Masters Curriculum.
Specializing in areas such as Oracle DBA, Oracle RAC, and Oracle Enterprise Manager Grid Control, David also holds several Oracle certifications, testament to his commitment to the field. Through his endeavors, David Rincon has quietly and consistently contributed to the Oracle community, helping organizations navigate their technology journeys.
Share This Story, Choose Your Platform!
Start The Conversation Today!
- Schedule Your Consultation
- Enjoy a Personalized Strategy Session
- Level-Up Your IT
