Challenge : How to load data of multiple rows into a single row in hive table (can regex be used in this scenario)

[m sreenath]

Hi

I have a large data-set of the form :
A    12323:213
B    adasd
C    sedweqwd

A    12323:213
B    adasd
C    sedweqwd

The general form is :
<char>\t<data>
<char>\t<data>
<char>\t<data>\n

In the given format, I need the <data> part from the three rows in a table 
containing three columns (time,name,content). Can regex be used for this 
scenario. If yes, help. Or any other method like writing custom serde.
Any help is appreciated.
Thanks