file_list=( $(find . -maxdepth 1 -type f) )
file_count=${#file_list[@]}
echo "Number of files: $file_count"
for file in ${file_list[@]}
do
line_count=1
while read line
do
process_line line
(( line_count++ ))
done < $file
echo "Number of lines processed in $file: $line_count"
done
hi all
i want to display the details of text files on terminal in table format
as
JobID SubmissionTime ExecutionTime CompletionTime Status Server Machine
user_1 00:00:00 00:00:00 ... (1 Reply)
I am trying to connect to database db2 through shell script.
The process I am trying is
> db2
It gives me error Access Denied.
While checking for access I have the rights.
Is there ant other way round..?
Please help. (3 Replies)
Hi Experts,
Im a new bee for scripting,
I would ned to do the following via linux shell scripting, I have an application which throws a log file, on each action of a particular work with the application, as sson as the action is done, the log file would vanish or stops updating there, the... (2 Replies)
Hello Everyone,
My issue is that I want to traverse a database table row by row and do some action on the value retrieved in each row.
I have gone through a lot of shell script questions/posts. I could find row by row traversal of a file but not a database table.
Please help.
Thanks &... (5 Replies)
Hi Experts,
can guide how we can Update a Database Table using a txt file source Using
Unix Shell Scripts.
What are the Cron Jobs codes can written to Update DB table.
txt file contains record like data.
US 09/03/2012 User DocType DocID.
these above feilds in txt files need to be updated in... (4 Replies)
Hello,
I extracted a list of files in a directory with the command ls . However this is not my computer, so the ls functionality has been revamped so that it gives the filesizes in front like this :
This is the output of ls command : I stored the output in a file filelist
1.1M... (5 Replies)
Hi,
Sorry i can't find what particular forum should i post my question.
I was given a username and password for the database, but i was not given the hostname, SID and the port to were i can connect to with.
Is there a way for me to get the following details in unix, by the way i am using... (5 Replies)
Hi,
I'm an amateur and need your help in figuring this out. I have been asked to connect to a prod db from non-prod env., and download a table from prod db to non-prod env.
I was able to connect to the prod db and then run a simple query as below.
@@@@@@@@@@
... (7 Replies)
All,
I am trying to create a report on the duration of an ETL load from the file arrival to the final dump in to a database for SLA's.
Does anyone have any guidance or ideas on how metadata can be extracted; information of a file: like file name, created timestamp, count of records and load... (1 Reply)
Discussion started by: pradeepp
1 Replies
LEARN ABOUT HPUX
split
split(1) General Commands Manual split(1)NAME
split - split a file into pieces
SYNOPSIS
line_count] suffix_length] [file [name]]
nsuffix_length] [file [name]]
Obsolescent
n] [file [name]]
DESCRIPTION
reads file and writes it in pieces (default 1000 lines) onto a set of output files. The name of the first output file is name with
appended, and so on lexicographically, up to (only ASCII letters are used, a maximum of 676 files). If no output name is given, is the
default.
If no input file is given, or if is given instead, the standard input file is used.
Options
recognizes the following command-line options and arguments:
The input file is split into pieces
line_count lines in size.
suffix_length letters are used to form the suffix of the output filenames. This option allows creation of more than 676 output
files. The output file names created cannot exceed the maximum file name length allowed in the directory containing
the files.
The input file is split into pieces
n bytes in size.
The input file is split into pieces
n x 1024 bytes in size. No space separates the n from the
The input file is split into pieces
n x 1048576 bytes in size. No space separates the n from the
The input file is split into pieces
n lines in size. This option is obsolescent and is equivalent to using the option.
EXTERNAL INFLUENCES
Environment Variables
determines the locale for the interpretation of text as single- and/or multi-byte characters.
determines the language in which messages are displayed.
If or is not specified in the environment or is set to the empty string, the value of is used as a default for each unspecified or empty
variable. If is not specified or is set to the empty string, a default of "C" (see lang(5)) is used instead of
If any internationalization variable contains an invalid setting, behaves as if all internationalization variables are set to "C". See
environ(5).
International Code Set Support
Single- and multi-byte character code sets are supported.
SEE ALSO csplit(1).
STANDARDS CONFORMANCE split(1)