Search Results

Thank you Aia , RudiC.

RudiC,

You are right , this solution could not have been done by me in a short span with a book.

But i do see a pattern here in the solutions and can focus on those ....

thanks RudiC and Chubler_XL for the directions.

I am working on the problem. I have picked up Arnold Robbins book on AWK and trying to see how can i solve this .

Hopefully i can have something...

I have a Text like below ,

Detailed Table Information Table(tableName:a1, dbName:default, owner:eedc_hdp_s_d-itm-e, createTime:1520514151, lastAccessTime:0, retention:0,...

Thanks RudiC . Appreciate your quick help. Non Unix line terminators might be because i copied the data from terminal to Notepad++ for uploading to the forum.

Hello,

I have attached 2 files

1) Original_table_definition.txt => which has definition of 3 tables
2) describe_table_output.txt => which has again 3 tables definition gotten thorugh doing...

Thank you RudiC . Both approaches are working fine. I am testing the solution with real data and will let you know in case something comes up

Thanks Don . I will keep your points in mind before opening a new thread.

The details you asked are given below

echo $BASH_VERSION
3.2.57(1)-release
uname -a
Linux sedcahdp0390...

In another thread some one suggested below AWK code , unfortunately our awk version did not match and i was not able to use this .

{ a[$2][$1] };
END {
for (col in a) {
printf "%s",...

Hello,

I have a file with 2 columns ( tableName , ColumnName) delimited by a Pipe like below . File is sorted by ColumnName.

Table1|Column1
Table2|Column1
Table5|Column1
Table3|Column2...