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
@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.
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.