Search Results

Thank you very much for your time.

Program works like champ but little problem is if the column has one character values "C" or something above that it has "ONE underscore" _ it is printing the...

previously we used the input file has only one key column left to the ||'s but it is keep changing this input file has 3 columns some files has 5 columns or more left to the || but after the pipes...

Jean-Pierre.
it works fine thanks lot for yor time.

Hi

here is the expected result.

FNL_PIPLN_EXIT_DT,17303,.
FNL_PIPLN_EXIT_DT,17303,.
FNL_PIPLN_EXIT_DT,17303,.
FNL_PIPLN_EXIT_DT,17303,.
FNL_PIPLN_EXIT_DT,17303,17103...

hi Jean-Pierre.

we need this column Fnl_pipln_exit_rsn_cd and values well ,we can delete the Value in both places after Base and Compare for this column.

Thank you.

I'm not getting the result as we expected ,below is is the output i'm getting.

,FNL_PIPLN,FNL_PIPLN
,_EXIT_DT,_EXIT_DT
,_________,_________
,17303,.
,17303,.
,17303,....

Thank you very much for your time Jean-Pierre,
actually input file format little bit chaged ,i have tested your scripts works fine but new format file does n't work ,please take look at the new file...

need to load these all colum difference into tbl so expected output like this below.

col1_exit_dt,17303,5
col1_exit_dt,17303,0
rate_hi,100,34

thanks for your time.

how to get the column names and values after the || del.
i tried like this ..grep '||' file name | grep -v '_' | grep -v base | awk '{print $3, $4 } i'm get the values but the column names. ...

thank youuuu