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]
Split the text to column
Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard