Search Results

Hi Don,

I need to fetch the data between certain limits. In the above example if we pass the project3,project4 as arguments, I need the contents between those 2 arguments.

In between project3 &...

Hi All,

Below is my requirement.

I need to pick the certain content from log file and display. for example log file consist of following information

project1
project2
project3
...

Hi Corona688,

I tried the above code snippet as below, I am not getting any values into new file

awk '{ while(NF>3) { sub(/ /, ""); $0=$0 } }' file_4.txt > 2.dat

Thanks,
Chandu.

One more question here,

Is it possible to correct the record if there is extra space.

chandu balu 434657 DD

it should become chandubalu 434657 DD after modification

Thanks Corona688.. I re-directed to another file and finally renamed to file to old file name.

Hi,

I tried the above command, But its not working

awk 'FNR==3' test1.dat > test1.dat

After executing above code, I didnt get any records into the test1.dat file

Hi All,

Please help me how to remove the records from the file if it is having more number of fields than the required one, before loading into stage

Here is the sample records. File is space...

I have adjusted the quotes in my code, that is also working.

awk '$7 < '$day_chk' && $6 =="'$mon_chk'" { print $9 }' > temp.dat

Hi All,

I have written one program to print the files which are not updated in the specified directory in .Dat file. If I am executing the same command in the command prompt its working fine but...

Got the answer with Awk

awk '/20120912/ { print $0 }' test.dat | wc -l

Hi All,

I need to get the count of records in the file, if the passing parameter matches with the list of records in the file. Below is my example

source file: Test1.dat

20120913
20120913...

Hi,

I know its dumb question but can you please explain little bit about following code.

printf "%s_%02d_file.csv" $TS $SEQ

what is the purpose of %s and %02d over there.

Thanks,
Chandu

Hi Joeyg,

I am not taking any differences between the files. That is the exact file name structure and files will come every one hour. our process will pick all those files to load int to stage.
...

Hi All,

Below is my requirement.

I want to display the missing files in the directory. Below is my example

From SFTP we are copying 10 files every day. if any files missed on that day need...

Hi All,

I want to display the distinct values in the file and for each distinct value how may occurance or there.

Test data:

test1.dat

20121105
20121105
20121105
20121105
20121106...

Hi Experts,

I am writing one shell script. Below is the requirement

1. need to login to the SFTP server, go to the particular folder
2. take the file count in that folder and assign it to...

Really good reference doc Jim.. thank u

---------- Post updated at 09:33 AM ---------- Previous update was at 09:30 AM ----------

Jim, Can you suggest me good docs for Unix. I am just beginner...

Thanks for replying me Tyler. This is the part of the code in one of my script.
so If I used the AWK, that is the better option.

In your code I couldn't understand one thing. I completely new to...

Hi All,

Below is my issue.

File consist of the 2 server information. This information I am pulling from Netezza table and keeping it in tmp file.

File format:
database...

Hi,
iam working with the existing script which consist of if condition

if [ -e ${v_ctlFile} ]
then
rm ${v_ctlFile}
touch ${v_ctlFile}
fi


what is the significant of -e there in the...

eg: $date1 :20090301
$ date2: 20090502

archivefile dir : /projects/home01/archive/2009/

file names:

20090311_archival.txt
20090312_archival.txt
20090313_archival.txt...

hi all,

here is the description to my problem.

input parameters: $date1 & $date2

based on the range i need to select the archived files from the archived directory and moved them in to...

its requirement.few logfiles and list files will generate sas program.iam able to move those files into one dynamic folder and zipping that folder.after zipping iam deleting the normal folder.tats...

hi all,

iam using unix command in the basesas programming.
i need to delete one folder which is dynamically creating when SAS script runs.


rm -rf " dynamic foldername"


iam not able to...

zip -j dir dir/*

i gave the above command but the file inside the directory also converted into .gz format.
but i dont want tat.is there format for tat