Search Results

Hi Ygor,

Thanks for the code.

This code worked for me perfectly for the scenario I gave. I may have scenario where in I would not have Test in common like

Test1.PO_Itm COLUMN ACTVIND. ...

Hello,

I am looking for concatenating the lines based on conditions. Below are the contents of the file:

Infile:
-----
Test1.PO_Itm COLUMN GAC_DT.
Test1.PO_Itm COLUMN (PRODTCD ,PLNTCD). ...

Hello..

Thanks for the quicky..
Will "if [ $# -lt 3 ]" check for case when any 3 arguments are passed or the first 3.

Hello,

I have a shell script "Test.ksh" and I need to pass 8 parameters/arguments while executing the script

./Test.ksh 1 2 3 4 5 6 7 8

Out of these I want first 3 to be compulsory and...

Thanks All..!!!

Hello Gurus,

Apologies if this Q has been repeated but i was not able to find it :(

I have an input file:
-------------------------------
Replace DB.Employee
as
select
column1...

Oops sorry my bad for reversing the solutions :confused:

The field CalDayRunDt may not be always the case so I just want to look for dates and replace them with the variable. But the dates will...

Hello,

The solution was working fine until i had following in my input file:

Soln By Scottn:
awk -vx=2010-06-28 '{sub("....-..-..",x,$0)}1' vwdef_MoSumSnpsht1_tmp

the $0 got replaced...

Thank You Scottn and Bartus11 - both solutions work perfect...!!!

Hello Gurus,

I have a file which has foll contents scattered:

,TotUnasgndNetAmt
FROM DEV_EIS_T.Wkly_SO_CCD_MOSumSnpsht
WHERE
CalDayRunDt = '2010-07-21'
UNION ALL
SELECT
CalDayRunDt...

Hi..

Thanks a lot...!!! Its rocking ...appreciate your time for this ..!!!

Sorry but I was assuming that text string wont make difference like

DEV_EIS_T.ProdtAtSlsOrg COLUMN SLSORGNBR.

DB_Name.ProdtAtSlsOrg COLUMN SLSORGNBR.

would require same logic and if we...

I am using the same way you have given:

awk '/DB_Name/{printf "\n"$0;next}{printf $0}' Q1_Expln_file_diag

Output is

DEV_EIS_T.ProdtAtSlsOrg COLUMN SLSORGNBR.DEV_EIS_T.ProdtAtSlsOrg COLUMN...

Thanks for the quicky but the output looks complex:

DB_Name ABC (X,Y,Z).DB_Name
DEF (T).DB_Name GHI (U,V,W).

whereas i wanted to have
DB_Name ABC (X,Y,Z).
DB_Name DEF (T).
DB_Name GHI...

Hello,

I have been searching the forum for concatenation based on condition. I have been close enough but not got th exact one.

infile:
-----DB_Name ABC (X,
Y,Z).
DB_Name DEF (T)....