Search Results

timestamp=`date '+%Y%m%d%H%M%S'`
FILE=/root/cdr/src.var.csv

Thanks for the quick reply.

I tried the first command I am getting the '<' unexpected. And the second command is giving bad substitution error,

Hi,

I am trying to remove a string ".var" using the below command but it's not working as expected, when I execute this in the command prompt using the echo it's working fine , please let me know...

Hey,
Let me know if you can use batch scripting I have a script with me which exactly suits your requirement some how this kind of dynamic scripting is tough to implement in unix.
Regards,
Shruthi

Hi,

I am generating some delete and insert sqls dynamically and I am redirecting them to a file in \execute\sqls\ through print -u3, now instead of redirecting to a file can i print the insert's...

Hi,

I am writing a script which will get the input from a combinations of awk commands and using counters and loop I am generating a dynamic values and passing the output to a file using print -u3...

Hi ,

I am using the below script for generating my report...it is generating duplicate entries , and I am not able to capture owner and user info...pls tell what is wrong in the script.
...

Hi ,

We are migrating our scripts from one unix server to another unix server in aix. Is there any way we can export the permissions, owner, group of the folders and files inside the folders.
...

is there any easy way to do this.. I have more than 200 files I don't want to write cat statement for all these files to append the data in to one big file.

Hi ,

I have a dump of .csv files in a folder, I need to sort all files by the first 3 columns and merge them all in one big csv file.

I am using a cat command to join them, but how can i sort...

Hi ,

I have a script which has multiple awk and sed commands like below.


First one :-
find /root/src/ -name "*csv" -size 0 -exec rm {} \;

Second one: -
ls *SRE*.txt > SRT_TRAN.dat
...

Hi ,

My source data is as below.

1,2,3,4,5
1,,,,,
1,2,3,,
2,,,,,


My target should be

1,2,3,4,5
1,2,3,,


I am using the below awk code.

awk '$2!="" && $3!="" print$0' infile

Hi,

I have a .csv file which as empty lines with comma and some special characters in 3rd column as below.

Source data
1,2,3,4,%#,6
,,,,,,
1,2,3,4,5,6
Target Data
1,2,3,4,5,6I need to...

Thanks for the replies, the script is some how not working as expected in our environment. is there any other way I can check if file exists if yes the it's size should be greater than 0 bytes. Based...

Hi ,

I am using the below script to check if a file is present if yes I will my next step if no this should return status as 1

if [[ -s $1 ]]
then
echo "File $1 FOUND!"
exit 0
fi
echo...

HI ,

I tried the below code but it's giving the error at the datetime part.

awk 'BEGIN { print "file_name = test_count" } print { Datetime = "date +%Y%m%d%H%M%S"} print {date = "date"} print...

HI ,

I am having a huge comma delimiter file, I have to append the following four lines before the starting of the file through a shell script.

FILE NAME = TEST_LOAD
DATETIME = CURRENT DATE...

Hi,

I am trying to add a header record to all the .csv files in a directory.

I am using the below sed commnad

sed -i '1 i \abc,sam,xyz,tip,pep,rip' xyz.csv

but this is not adding the...

Hi yazu,

Below is my source data

AIRTEL,POSTPAID,98850,9885714478,9885814478,9665871143
AIRTEL,PREPAID,97415,9885714478,9885814478,9665871143...

Hi Yazu,

I am trying to apply a sed logic using the below code only if my first column has ABC and second column as XYZ,but the below code is not giving the required output.

sed -r -n '/^[...

Hi ,

what is the equivalent of below awk in sed.

awk '$1=="ABC"&&$2=="XYZ" {print $0}' infile

Thanks,
Shruthi

Hi,

I am trying to insert a timestamp after all the file names in a folder,after the timestamp is created in the filename the file size is becoming zero bytes.

please tell me where I am doing...

Hi ,

I am trying to write a shell script which will validate all .csv file names in a directory , my file name format is as below.

CDR_SCAN_Report_YYYYMMDDHHMI.csv

1. I need to validate the...

Hi ,

I have a file which has a line starts with $segment_name and has the below data

source data

$Segment_Name = 123.ABC.123.01.txt
$Segment_Name = 123.ABC.ABC.txt
$Segment_Name =...

Hi,
I have the below data

ownername/schemaname/tablename/columnname in a file ( 2nd column)

I want to convert everthing to upper case except the column name like below
...