Search Results

Search: Posts Made By: Arun Mishra
2,348
Posted By Arun Mishra
It doesn't work . Please refer below for results:...
It doesn't work . Please refer below for results:

[B955991_ABBVIE_HCV_DEV@cdtsorl239p B955991_ABBVIEHPC_DAS_DEV]$ head CHGSUM.CSV | sed 's/^~*//; s/~*$//'
~~~ COUNT...
2,348
Posted By Arun Mishra
Remove trailing tilde("~")
Hi,

I have file where i need to remove only the leading and trailing tilde(~) charaters from file. Please seebelow for sample file:

~~OLD PRODUCT RECORD COUNT ~...
1,617
Posted By Arun Mishra
Remove Last field from a delimited file
Hi,

I have a '~' delimited file and i want to remove the last field using awk. Please find the sample records below:

...
1,158
Posted By Arun Mishra
Assigning Variables
Hi,

Can the below be clarified please. i just want to know what is the difference between the two ways of assigning variables as mentioned below.


export...
5,225
Posted By Arun Mishra
Hi, Thanks for the reply. But after using...
Hi,

Thanks for the reply. But after using the above if block i still got error.
I saw in debug mode the fileCount value as mentioned below:

fileCount=$'22454750\r'
the if condition is...
5,225
Posted By Arun Mishra
Getting awk Output as number instead of String
Hi All,

I have a file a.txt, content as mentioned below:

22454750

This data in this control file and


I have a variable called vCount which contains a number.

I need to extract...
1,527
Posted By Arun Mishra
Yes i used the below query to get output: ...
Yes i used the below query to get output:

sqlplus -s ${WMD_DM_CONNECT} <<EOF>arun_temp.out
set feedback off
set colsep |
select proc_id ,FILE_ID,FILE_DT,STAT_CD from wmd_file_cntl where rownum...
1,527
Posted By Arun Mishra
Extract records from Oracle to UNIX file with headers
Hi,

I have a shell script which extracts records form oracle to unix file.



sqlplus -s ${WMD_DM_CONNECT} <<EOF >$tmpfile
set heading off
set pagesize 0
set feedback off
select...
1,073
Posted By Arun Mishra
Ordering Folders having Date as Names
Hi All,

I have directories under
/development/arun/weekly/

20120421
20120414
.
.
.
.
I need to arrange these directories in descending order.
folder name with recent date will be on...
968
Posted By Arun Mishra
File Content Loading to Oracle Error
I habe a UNIX Variablw with content as below:

WHOLE_REC_TXT="$record"
where $record contains contents of file

Sample contents of file:

topic_id|1624|AIDS-HIV||...
1,785
Posted By Arun Mishra
Extract UNIque records from File
Hi,

I have a file with 20GB Pipe Delimited file where i have too many duplicate records.
I need an awk script to extract the unique records from the file and put it into another file.

Kindly...
1,718
Posted By Arun Mishra
Thanks for the reply but after executing the...
Thanks for the reply but after executing the above script i got following error:


date: illegal option -- d
Usage: date [-u] [+format]
date [-u] [mmddhhmm[[cc]yy]]
date [-a...
1,718
Posted By Arun Mishra
How to do Date Manupulation in Korn Shell?
Hi All,

I need to find the date 19days back from the current date:
eg: if today is 17 March 2013
then the output should be : 26 Feb 2013

Can i do this using date command in Korn Shell?

And...
2,004
Posted By Arun Mishra
Thanks, Both the solutions worked perfectly. And...
Thanks, Both the solutions worked perfectly. And yes when i issued the command echo "$BD_RC_CNT" it showed as below

$ echo "$BD_RC_CNT"
6


these seem to be some spaces then 6. may be...
2,004
Posted By Arun Mishra
How to get a numeric value from Oracle to UNIX variable without spaces?
Hi,

I am using the below code to get a numeric value from oracle to unix variable:

BD_RC_CNT=`sqlplus -s ${WMD_DM_CONNECT} <<EOF
set heading off
set pagesize 0
Select count(*)
from...
3,883
Posted By Arun Mishra
Yes man, I tested and it's working. Thanks very...
Yes man, I tested and it's working.
Thanks very much for the code. Can you please explain what basically it does? The for loop specifically.

Thanks again for the help!
3,883
Posted By Arun Mishra
Extract and count number of Duplicate rows
Hi All,

I need to extract duplicate rows from a file and write these bad records into another file. And need to have a count of these bad records.
i have a command
awk '
{s[$0]++}
END {
...
2,340
Posted By Arun Mishra
read thing doesnt work cero as i do have spaces...
read thing doesnt work cero as i do have spaces in the values itself as in one column has a value arun mishra.. read will treat it as two fields instead of 1.
can i assign evrything to arrayvariable...
2,340
Posted By Arun Mishra
How to get Oracle variable in UNIX?
Hello All,

I need to export various variables in UNIX. But the values of those variables will come from Oracle.

Say i have Oracle query:

Select
file_id, file_desc, file_freq_cd,...
3,889
Posted By Arun Mishra
Removing older version files
Hi,

I have a direcory as mentioned below:
/development/arun/cycdt/
unser the above i have directories
/2013
/2012
/2011
......
.....
/2000
I need to write a script which can delete the...
1,319
Posted By Arun Mishra
thanks for the reply, Can you explain what...
thanks for the reply,

Can you explain what eval does here? and why you put \?
why is it a security risk? and if there is any other way you suggest as i need to have this variable from input only.
1,319
Posted By Arun Mishra
Assigning variables
i have variables RECIPIENTS_DEVL,RECIPIENTS_UACC,RECIPIENTS_PROD
i have a case statement to get the phase variable:
case ${WMD_UPHASE1} in
u) WMD_UPHASE4=UACC;;
i) WMD_UPHASE4=DEVL;;
p)...
1,018
Posted By Arun Mishra
Delimiter Conversion(Generic Code)
Hi All,

I am looking for a generic code which can search for the existing delimiter(what ever it may be) in a file and convert it to Pipeline. The file may have Pipeline delimiter already in that...
3,295
Posted By Arun Mishra
Actually i wanted all existing values plus the...
Actually i wanted all existing values plus the remaining fields to make it 20. and in all if any value is null it should be defaulted to space. i think the below should do it :

$i = $i != "" ? $i...
3,295
Posted By Arun Mishra
Thanks Don, Pamu for all your efforts to make out...
Thanks Don, Pamu for all your efforts to make out the best effective pracrtise of coding. So i can use the final version by Don.. looks awesome and simple.:b:... really brilliant piece of coding .:)...
Showing results 1 to 25 of 51

 
All times are GMT -4. The time now is 09:49 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy