Search Results

thanks

Thanks , I understood your logic but not code.

I mean in first sentence we are using fileB only
and in second sentence fileB and fileA both.
How code decides it

It is working, could you please explain me in layman terms how this code woks

Hi Now requirement has changed. Now I dont need to merge two columns of different files but I have merged output in single file. still some word processing remaining

file A:
1|fkgk
2|sfkgn...

Both solutions are working , but no of columns are varies for each record, so can you generalize this solution for n no of column

I want alternate columns of fileA and fileB like
col1of A -> col1ofB |col2ofA -> col2ofB

This is adding columns of file B after columns of fileA.
I need one column of fileA and then fileB

I have used column separator as '|' in oracle query and then I have removed that with replacing it by tab but $ remains there .

so output after replacing "|" is
aa bb cc$
dd ee ff gg$
hh...

Hi All,

I have two files having oracle query result. I want to merge to files line by line and also with column

File1
23577|SYNC TYPE
23578|Order Number|ConnectionState...

I will let you know tomorrow

I have to keep last $ as it is. It is expected eol character.

suppose db record is like
aa|bb|cc|dd|ee|ff|gg|hh|ii|jj|kk

but my output has $ in between where I have given large format space for column.
aa|bb|cc|$
dd|ee|ff|gg|$
hh|ii|jj|kk|$
$

I hope...

Hi All,

I am fetching oracle query result in shell variable. As columns numbers are more the output wraps in unix terminal .i.e one complete record in db gets store in multiple lines. with each...