How to import SAP TXT file

Originally posted by: abd.zoh

I 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,