12-10-2007
This def. works. Thanks rob. I still need to get rid of the blank lines in between:
0 rows created.
Commit complete.
1164988 rows created.
Commit complete.
8320999 rows created.
Commit complete.
1494097 rows created.
Commit complete.
Any ideas?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
HI guys,
I have created a script to read 1 column in a csv file and then place it in text file.
However, when i checked out the text file, it is not in a column format...
Example:
CSV file contains
name,age
aa,11
bb,22
cc,33
After using awk to get first column
TXT file... (1 Reply)
Discussion started by: mdap
1 Replies
2. Shell Programming and Scripting
Can somone take a look at this script for me - I'm trying to get it to exit if the format of dateToLookFor is not in the format YYYYMMDD:
function search
{
cd $logsloc
echo "Enter date in format YYYYMMDD (enter to exit):"
read dateToLookFor
echo $dateToLookFor | grep -q ... (2 Replies)
Discussion started by: rich@ardz
2 Replies
3. Shell Programming and Scripting
hi all
I have a file with many lines like
aa;bb;cc;dd;ee
bb;aa;dd;ee;bb
cc;ee;bb;dd;aa
ee;cc;bb;aa;dd
.
.
.
etc
The first line is in right format,Please help me how to use "SED" to change the rest of the lines to the format like line 1
thank all! (1 Reply)
Discussion started by: yuesko
1 Replies
4. Shell Programming and Scripting
I have the date of the file passed into a variable also current date formatted same passed into a separate variable and compare the two with an if statement and statement always comes up false. Even though I verified the dates. Any help would be awesome.
Filecrtdate=`ls -l $i | awk '{print... (19 Replies)
Discussion started by: coderanger
19 Replies
5. Shell Programming and Scripting
Hi! how do i know if the input is the same as the required date format? the date should be dd/mm/YYYY ex. 2/3/2012 or 15/11/2012
all the following conditions must return an error:
*input of string
*day is > 31 or < 1
*month is > 12 or < 1
*year is < 2013
suppose the date format is stored... (1 Reply)
Discussion started by: angilulu
1 Replies
6. UNIX for Dummies Questions & Answers
Hi,
Recently we migrated an application in HP UX to Linux. The files(scripts & logs)download from HP UX coming in a formatted way in MS notepad. However the files in Linux are not in correct format in MS notepad(No spaces , some spl symbols like square).We tried both ASCII and binary but no... (2 Replies)
Discussion started by: nag_sathi
2 Replies
7. Shell Programming and Scripting
Hi,
I am running two scripts as below.
In Script 1 i am getting correct output in proper HTML format while in script 2 i am not getting output in mail and only html code is getting printed.I want to get the output of script 2.
Please guide.
1.IFILE=/home/home01/Report.csv
if #Checks... (7 Replies)
Discussion started by: Vivekit82
7 Replies
8. Shell Programming and Scripting
I have a script that looks like this:
dirname2=/usr/tmp/filelist/*/*
for dirname2 in /tmp/filelist/*/*; do (cd $dirname2/catalog ||echo "file does not exist" && echo "$dirname2" |cut -d '/' -f 7,8 && echo $i && ls -la |awk 'NR>3 {SUM += $5} END { print "Total number of kb " SUM }');done... (2 Replies)
Discussion started by: newbie2010
2 Replies
9. Shell Programming and Scripting
All,
Objective : Extract the correct format of a file name.
Please share the script command which will extract the correct format of the file after untarring.
Example : If the file is of .csv format then extract filename.csv
if the file is having .CSV then extract the same.CSV
if the file... (1 Reply)
Discussion started by: Mahesh G
1 Replies
10. Shell Programming and Scripting
Hi Experts,
path=/db/files/
format=$1
User can enter any file format.compare the user file format with actual file format existed in the directory /db/files. User enter all characters as "A" apart from date format.
example1: user will be entering the file format AAA_AA_YYYYMMDD.AAA
Actual... (6 Replies)
Discussion started by: nalu
6 Replies
LEARN ABOUT OSF1
cdslinvchk
cdslinvchk(8) System Manager's Manual cdslinvchk(8)
NAME
cdslinvchk - Checks the CDSL inventory of the base operating system and layered applications.
SYNOPSIS
/usr/sbin/cdslinvchk [log_file_path]
OPTIONS
The path name to a location for the log file. By default this will be /var/adm/cdsl_check_list.
DESCRIPTION
Use the cdslinvchk script to verify the current inventory of Context Dependent Symbolic Links (CDSLs) on a running system. CDSLs are spe-
cial symbolic links that enable a system to work in a cluster. If CDSLs are accidentally removed, your system will not function correctly
in a cluster. While this is not a problem for stand-alone systems, you may not be able to add the system as a member of a working cluster
at some future time. You can run this script at any time or configure it to run at system start-up, or as a cron task.
When you invoke the script, it checks the CDSLs on the running system against CDSLs of the installed inventory in /usr/.smdb and the addi-
tional entries in /var/adm/cdsl_admin.inv, and ensures that each target file exists on the system as a properly-constituted CDSL. If the
check is successful, the following message is displayed and the script terminates: Successful CDSL inventory check
If the script finds inconsistencies in the inventory, warning messages are displayed on your terminal and logged to the default log file at
/var/adm/cdsl_check_list. You can specify an alternate location for the log fill if required. The script locates any modified, missing,
or replaced CDSLs. Note that the previous copy of the log file is renamed and retained for reference and is renamed by appending to the
filename.
Refer to the System Administration guide for information on recreating any missing or broken CDSLs. Refer to the hier(5) reference page
for an inventory of CDSLs.
MESSAGES
One or more of the following messages may be displayed and logged to the log file: Unable to create <pathname> report file -- the script
was not able to create a log file. Check the target directory and security. Expected CDSL: <cdsl_pathname> -> <pathname> CDSL Target has
been modified to: <pathname> CDSL has been replaced with <pathname> CDSL is missing Failed CDSL inventory check. See details in <log file>
FILES
Additional inventory file entries. This file will not exist on all systems. The current and previous log files for inventory errors and
messages
SEE ALSO
Commands: cron(8)
Others: hier(5)
See also the System Administration guide for details of CDSLs
cdslinvchk(8)