Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.
Originally posted by: abd.zohI have several SAP files in TXT format. MARD, RESB, etc
I am loading them into Lava BRE to do some data validation
All of the Text document from SAP start with date, two rows of dashes and useless information. Then columns/fields where all the important information is..
I want to the most efficient way (because I have so many tables) to remove the dashes and useless information at the first three rows of the document and then split the rest of the information by delimiter (l) into separate columns
Thank you in advance,