Search Results

Using awk or sed command how can i encrypt the characters for a particular column.For every character it should replace the third charter of alphabets.Example replace "A" with "C" and "B" with...

I am using below logic to validate whether i am expecting the correct data from source,if not logic should give which column has error.i am running below logic in linux

awk -F, '
NR==1{next}...

thanks boss its woking,can u please explain how the below command will work.

i am not getting any error but it is not appending the line if it is more than one "<INCOND NAME" condition.please check below.



Data
<JOB JOBISN="3" APPLICATION="PRICD"...

above command is not working.

I have one big XML file which contains information about 100 jobs,"JOB JOBISN=" indicates that is a job so where ever tag starts with "JOB JOBISN=" then i need to add below highlighted line between ...

yes,it should change complete file.in file it may be any value for versionnumber but command/script should change all values to one.

I have big XML which i want to change all VERSIONNUMBER equal to 1,in existing file values of VERSIONNUMBER will be different as below now i want to change all VERSIONNUMBER values qual to 1.Please...

Data not replacing using sed,please check below.

Replace_value=$$dbconn_target
Search_value=$$dbcon_source
　
sed -e s/\${Search_value}/\${Replace_value}/g intrepid_sps_val.parm

I have a Parameter.txt file with set of parameters which i need to replace $$ControlM_Job_Name value with respective to job which i need to run.currently $$ControlM_Job_Name have...

In a .txt file i have a set of teradata queries which i need to execute and capture result for all queries.Is there any way to run teradata queries from a file?

In a incoming folder i have list of files like below,i want to pick the unique files to process the job. if same file contain more than one then it should pick latest date modified file to process....

I am using below code to connect terdata and getting the query result in a file.Now i want to use same code for different tables,plz tell me how to pass table name as parameter.i tried using as...

thanks for your help.

is there any way to remove below part and can pass as parameter?

because i have 800+ columns for 10 files so it will be very tuff to add match statement for all...

Like above file i have 10 different files which contains more that 700+ columns so it is very tuff define lenght and datatype for all columns so i want to get details from source defination file ...

in previous post we directly defined values,in above scenario i want pass value as parameters.Parameters are not accepting in 1st line of awk function.

In below script parameterwhich i am passing to awk function is not working.Not sure why its not accepting parameter.Please tell me how to pass parameter to the awk function.Please check the below...

I have sourcefile and structure of source file,i want to check whether datatype and length mention in emp.txt is same as source file.

Example:
in emp.txt first row contains sno number so in...

sourec file EMP.txt

snoÇnameÇphonenoÇdeptÇjoineddate
1ÇvivekÇ0861ÇCSEÇ2013-05-29 00:00:00
2ÇdineshÇ123456ÇECEÇ2013-05-29 00:00:00
3ÇsaiÇ78945ÇEEEÇ2013-05-29 00:00:00
4ÇsridarÇadfÇITÇ2013-05-29 00:00:00

...

awk -FÇ ' NR==1{next} {f="ok"} length($1)>2{f="err"} length($2)>20{f="err"} length($3)>10{f="err"} length($4)>20{f="err"} length($5)>19{f="err"} {print f,$0} '...

I have a sourcefile which contains data as below.I want to check whether datatype,structure and date format looks good as mentioned.
Data is delemited by cydila .

Source file-Emp.txt
sno name...

I have a sourcefile which contains data as below.I want to check whether datatype,structure and date format looks good as mentioned.

Data is delemited by cydila Ç.

Source file-Emp.txt
...

Its working thanks all.

From below text how to get value of Affected Rows in 10th line.
output should be 1000


DIRECTOR> TM_6252 Source Load Summary.
DIRECTOR> CMN_1740 Table: [SQ_Payment_Tran_File] (Instance Name:...

below code is not executing the stored procedure,not sure what the issue.Even sqllog is blank.please help me its very urgent.
sqlplus -s $connect_str@$DB_ORACLE_SID >> ${SQL_LOG_FILE} << EOF
set...