text file load

[praneshsapmm]

Hello ,

I have the format of my text file as mentioned below : 

------------------------------------------------------------------------------------------------------

AAAAAAAAAAAAAAAAAAAAA

BBB  AAAAAAA  AAAAAAAA

Plant code 

Company code 

------------------------------------------------------------------------------------------------------

Item Inventory Price Received qty Outgoing Qty net Qty 

------------------------------------------------------------------------------------------------------

AA      1             100     10                         10        2

BB      2             20        5                           4         1

Above header data is not needed . I  would like to split the table into multiple fields . 

Iam trying to do this using , but table details are not visible to me to split the data , only header in available .

Any help .Thanks

[Qiu]

@praneshsapmm 
How about we imported it as CSV format?

But there is one issue though. your header is difficult to parse, so I used brutal force.

[praneshsapmm]

Hi @Qiu ,

Thanks for the proposal . I tried with CSV but the values in table are not aligned in good way . I'am not sure why i couldn't see the table at the bottom while i split . 

Thanks.

[binuacs]

@praneshsapmm  similar to @Qiu using input as CSV