Community

I have a text file that contains all the text like below. My question is how can I break them into column? I want a column with the tablename where contains "abcdefg011" and than all the other text will go to other column.
All the new row begin with# and end with#. and all the "tablename" with begin with "Error in"

RAW FILE WILL LOOK LIKE THIS.
###############################################################
Error tablename abcdefg011 Please check the below lines

0

30
30
Querying table relationship for item AABB:1122 CCDD:3344 EEFF:5566


=============================================================
AABB:1122 Suspended
CCDD:3344 Full
EEFF:5566 Enable
==============================================================
#####################################################################

THE OUTPUT SHOULD LOOK LIKE THIS
tablename OtherColumn
abcdefg011 #########################################
Error in tablename abcdefg011

Looking for item AABB:1122 CCDD:3344 EEFF:5566



===============================
AABB:1122 70 0 Unlocked
CCDD:3344 70 0 Locked
EEFF:5566 0 Unlocked
==============================
##################################
[/img]