Search Results

Search: Posts Made By: member2014
3,633
Posted By member2014
I am trying to design this and looking for...
I am trying to design this and looking for recommendations. As of now i'm thinking to write a script which will take the id as input and execute it. And a wrapper around it to call the script and...
3,633
Posted By member2014
Executing SQL's in parallel
Hi Folks,

I have requirement to pull a bunch of SQL's from a table in DB and execute them in parallel and update the status of each query as and when they complete. Can you please help me with...
1,503
Posted By member2014
Thanks Chubler_XL, Robin and RudiC. This is...
Thanks Chubler_XL, Robin and RudiC. This is really helpful.

I changed Chubler_XL's code to use 8 characters and it is working perfectly.

Robin - Thanks for your suggestion. The test file I...
1,503
Posted By member2014
Using freq in script
Hi,

I have a requirement where I need to check a column data in a fixed length file.

Sample file.

1 10 20150201 TEST1 TEST1
2 20 20140201 TEST2 TEST2
3 30 20150810 TEST3 TEST3
4 10...
3,349
Posted By member2014
Sry for the confusion. I picked up the first part...
Sry for the confusion. I picked up the first part of my test file which happened to have delimiters between fields.

Thanks for the help RudiC and Scrutinizer. Both codes are working.
3,349
Posted By member2014
Thanks Rudi. One problem with this is, some of...
Thanks Rudi. One problem with this is, some of the columns are adjoining without fillers in between. For such cases this is not working.
3,349
Posted By member2014
Thanks Yoda. This is giving me the csv file with...
Thanks Yoda. This is giving me the csv file with the columns I need.


I,0515,MR ,394
I,0618,MR & MRS,942
I,0618,MR & MRS,944
I,0205,MR & MRS,614
I,0122,MR ,940


Is there a way I...
3,349
Posted By member2014
Fixed length to delimited file conversion
Hi All,

I need to convert a fixed length file to a delimited file with , (comma). But not all columns, some of the columns in the fixed files are used as fillers and I do not need that in the...
11,602
Posted By member2014
Thank you Derek. This is helpful.
Thank you Derek. This is helpful.
11,602
Posted By member2014
Replacing a column in a pipe delimited file
Hi,

I have a pipe delimited file as below and I need to replace the 2nd column of each line with null values.


1|10/15/2011|fname1|lname1
2|10/15/2012|fname2|lname2...
1,729
Posted By member2014
Aah, that worked. Thanks RudiC. This is really...
Aah, that worked. Thanks RudiC. This is really helpful. I will try to break it down and understand the logic.
1,729
Posted By member2014
Error files are also in the same folder: ...
Error files are also in the same folder:

Processed files:

dev/processed>ls *.txt
DEPARTMENT_20140911.txt EMPLOYEE_20140915.txt PRSNL_INFO_20140911.txt SALARY_20140911.txt ...
1,729
Posted By member2014
Please find below details: ...
Please find below details:


dev/processed>ls *.txt
DEPARTMENT_20140911.txt EMPLOYEE_20140915.txt PRSNL_INFO_20140911.txt SALARY_20140911.txt SAL_HIKE_20140911.txt



AWK version:...
1,729
Posted By member2014
Thanks RudiC. I am a beginner in Unix and...
Thanks RudiC.

I am a beginner in Unix and still learning. I tried a few things but did not get anywhere so wanted to get help.

Can you help me understand what this code is doing? I seem to be...
1,729
Posted By member2014
Prepare file run report
I have a requirement to prepare a report.

We validate some incoming data fields and create validation_error reports which will contain records which do not pass validation. Once files are...
9,335
Posted By member2014
Thank you for the great explanation. This has...
Thank you for the great explanation. This has been really helpful.
9,335
Posted By member2014
Thank you soo much. This is really helpful. I...
Thank you soo much. This is really helpful. I used the above code and it is working as expected.

Is the && used as an AND operator? Cos when I remove it as below, the script does not execute via...
9,335
Posted By member2014
Thanks vbe and Chubler_XL. I just changed to...
Thanks vbe and Chubler_XL.

I just changed to run today and tested. I tried two ways:


0 9 22-31 8 2 /path/to/your/script > /path/to/your/log 2>&1


I would think that this cron should run...
9,335
Posted By member2014
Cron to run 3rd Tuesday of every odd months
Hi,

I need to schedule a script to run on the 3rd tuesday of every odd months at 9 am.
min, hour would be - 0 9
month would be - 1,3,5,7,9,11

Can someone suggest how I can schedule it to 3rd...
1,667
Posted By member2014
This is a really great way of doing what I am...
This is a really great way of doing what I am trying to acomplish. And definately eleminates unwanted if statement. Its a great new learn for me.
1,667
Posted By member2014
This is really helpful. Thanks much Robin....
This is really helpful. Thanks much Robin. Reading the parametes in while loop makes it so much easier.

I will need to check that the par1 and par2 are not blank and create the .finished file....
1,667
Posted By member2014
Cut a script name to create a blank file
I have a requirement to read a list of script names create a .finish blank file for each of them.
The script names can be like:
- ScriptName.sh
- ScriptName.sh Param1
- ScriptName.sh Param1...
1,769
Posted By member2014
Thank you for the response. I was wondering if...
Thank you for the response. I was wondering if there is any option in unix which doest that automatically.
I think I will need to make changed while creating the logfile itself. This is helpful.
1,769
Posted By member2014
If the contents of the file error_log.txt is as...
If the contents of the file error_log.txt is as below:
This is test line 1
This is test line 2
This is test line 3
This is test line 4
This is test line 5
This is test line 6
This is test line...
1,769
Posted By member2014
Email attachment contents misaligned
Hi All,

I am using mail -s in my shell script to write contents of logfile as the content of my email, and attaching the error_log.txt along with it.
When the email gets sent out, the contents of...
Showing results 1 to 25 of 32

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