Search Results

Yes Radoulov, something was wrong with my input file.

Your script is working fine!! Thanks a lot!

Hi Radoulov,

thanks for your reply, but the output is not complete with your last code, I get :

PARAM_VALUE;PARAM_HEADER;
p1val;;
p4val;;
p7val;;
p2val;;
p5val;;
p8val;;
p3val;;
p6val;;...

Hi All,

I'm looking for a script which can transpose field names from column headers to values in one column.
for example, the input is:

IDa;IDb;IDc;PARAM1;PARAM2;PARAM3;...

Thanks,

Your command is working fine!

Hi,

I have an sqlplus output file using the character ';' as a delimiter and I would like to replace the fields without datas (i.e delimited by ';;') by ';0;'

Example: my sqlplus output:...