Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Loading Fixed format file

947775Apr 9 2013 — edited Apr 11 2013
Hi I am getting one fixed format file like below


110Ramhr20111Samsales10112abc30113xyzmarketing40


so the the data should load like this

EMP_ID EMP_NAME DEPT_NAME DEPT_ID

110 Ram HR 20
111 Sam Sales 10
112 abc 30
113 xyz Marketing 40


if we are getting file like this as fixed format that's fine i can able to load


but if we get file like "110Ramhr20111Samsales10112abc30113xyzmarketing40" then how we can able to load data row by row.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2013
Added on Apr 9 2013
#business-intelligence-applications, #data-integrator, #system-management-and-integration
5 comments
293 views