Search Results

Thanks Ravin and RudiC. However, I feel RudiC provided solution is easier to apply into my requirement as it is more flexible by replace the date with a variable. Ravin, yours is able to run with...

Hi All,
I have a list of date number (YYYYMMDD) and its own number in a file.
Here is the example



20170320
D100001
D100002
D100003
20170321
D200001
D200002
D200004
D200005...

Thanks Don and RudiC for your contribution, my environment is AIX server Power 8. The above log was generated by database event monitor file and I would like to tabular it into row base report for...

Greeting Everyone,
Anyone has tested to transform a log file seemingly as following

Text : SELECT DISTINCT Block_Code FROM DSSBDW.CC_PL_TRX
...

Thanks Durden for your good effort to try this solution in perl language. Indeed unix sed is a mutual, powerful tool. Without it, we are probably need to write lengthy script to achieve same...

Thanks RudiC for your clear explanation.

Thanks RudiC, It willl be great if you can explain the sed command you share as I not really understand sed command well.

Thank You Guys,
However perl and sed solution provided will replace the first occurrence as well.
I found Rudic given sed solution has included 2nd occurrence, but it still change for the...

Thanks Guy. I will reply the outcome after I tested.

Hi All,
Please help for the following scenario where I want to add a delimiter after 2 decimal point integer.

Original Line...

Hi Guys,
Any good reference for me to perform user database update statement on table which has quite number of fields could be updated depend on user specified column name and the value to...

Dear All,
I have a requests to retrieve all lines if second line last columns meets certain criteria.

Here is the output of the result
Table: DSSBDW.DA_MASK_CLK_AR
120908 0 86 86 - 1934528 0...