10-18-2005
Hit my nickname 'noelcantona' in Google, from the hit you get, tell me whether I am looking for a quick solution for my homework.
My friend needs help. He received 4 excels file with 60k of lines everyday. He is lazy to look for another solution and doing the ctrl+c and ctrl+v way. Approximately 2 hours per file.
Initially this question is posted in sqlserver forum but he can't use sqlserver, so I am here. I pity him, thats why I am doing my first post here in unix.com.
My meaning of assignment here does not mean homework but job assignment.
cheers,
-NoeL-
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
#!/bin/sh
rpt="/export/home/legato/rpt_offsite"/test_eject.tape
cat <$rpt
while read line
do
echo $line
perform routine
done
I am trying to read the contents of this file line by line and perform a routine for each line read.
The file contents are numbers..
What is wrong with my... (1 Reply)
Discussion started by: gzs553
1 Replies
2. Shell Programming and Scripting
First I' d like to say you guys are awesome. :)
I have a word document that I cut and paste into Textpad and it removed all the fancy formatting which is fine with me. I WinScp'd it to the box and and called it inputfile.txt.
Opened it in vi and don't see any special characters or stuff that... (2 Replies)
Discussion started by: zilla30066
2 Replies
3. Shell Programming and Scripting
I am trying to read input for a C program (that expects input from the user) from a file using the shell command:
progname < filename
but it seems that the program considers the char '<'
as the first input, hence causing an "error" in my program.
I checked it with another program and it... (2 Replies)
Discussion started by: nadbar
2 Replies
4. Shell Programming and Scripting
Hi guys,
I am new to AWK and unix scripting. Please see below my problem and let me know if anyone you can help.
I have 2 input files (example given below)
Input file 2 is a standard file (it will not change) and we have to get the name (second column after comma) from it and append it... (5 Replies)
Discussion started by: sksahu
5 Replies
5. Shell Programming and Scripting
Hi,
I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format.
Example:
File.txt
AP|{SSHA}VEEg42CNCghUnGhCVg==
APVG3|{SSHA}XK|"password"
AP3|{SSHA}XK|"This is test"
....
etc
---------
test.sh has... (1 Reply)
Discussion started by: hudson03051nh
1 Replies
6. Shell Programming and Scripting
I need to know how the the string constant from Input File should be read and provide as input data for the script .
INPUT FILE
CONST VARIABLE
myname=/root/dir/syslog/myname1
myname=/root/dir/syslog/myname2
myname=/root/dir/syslog/myname3
urname=/root/dir/syslog/urname1... (6 Replies)
Discussion started by: baraghun
6 Replies
7. Shell Programming and Scripting
Hello,
I've been trying to come up with a solution for the following problem; I have an input file with two columns and I want to print as an output the first column without any changes but for the second column, I want to divide it by its last value. Example input:
1 9
2 10
3 11
4 12
5... (14 Replies)
Discussion started by: acsg
14 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I need to read the date from the input file. The format of the input file is as follows:
a_b_c_yyyymmdd.txt
I need to read the date(yyyymmdd) part from the name of the input file.
Would really appreciate if someone can help me in this regard
Thanks a lot. (1 Reply)
Discussion started by: Sunny_teotia
1 Replies
9. Shell Programming and Scripting
Hi,
Could someone let me know how to read input from a web page into a unix file.
I am writing my script in bash shell in Solaris version.
Thanks in advance,
ayarlaga. (7 Replies)
Discussion started by: ayarlaga
7 Replies
10. UNIX for Dummies Questions & Answers
I am not able to capture the user input in this script(bash).There is prompt for user input.Could some one help me capture user input while reading afile?
while read line
do
echo "$i"
path1=$line
path2=`echo $line|sed s/new_dir/old_dir/`
echo "Do you want to replace?";... (4 Replies)
Discussion started by: parijat guh
4 Replies
LEARN ABOUT LINUX
anacrontab
ANACRONTAB(5) Anacron Users' Manual ANACRONTAB(5)
NAME
/etc/anacrontab - configuration file for anacron
DESCRIPTION
The file /etc/anacrontab describes the jobs controlled by anacron(8). Its lines can be of three kinds: job-description lines, environment
assignments, or empty lines.
Job-description lines are of one of these two forms:
period delay job-identifier command
@period_name delay job-identify command
The period is specified in days, the delay in minutes. The job-identifier can contain any non-blank character, except slashes. It is used
to identify the job in Anacron messages, and as the name for the job's timestamp file. The command can be any shell command. The fields
can be separated by blank spaces or tabs. The period_name can only be set to monthly at the present time. This will ensure jobs are only
run once a month, no matter the number of days in this month, or the previous month.
Environment assignment lines are of the form:
VAR = VALUE
Spaces around VAR are removed. No spaces around VALUE are allowed (unless you want them to be part of the value). The assignment takes
effect from the next line to the end of the file, or to the next assignment of the same variable.
Empty lines are either blank lines, line containing white-space only, or lines with white-space followed by a '#' followed by an arbitrary
comment.
You can continue a line onto the next line by ending it with a ''.
SEE ALSO
anacron(8)
The Anacron README file.
AUTHOR
Itai Tzur <itzur@actcom.co.il>
Currently maintained by Pascal Hakim <pasc@(debian.org|redellipse.net)>.
Pascal Hakim 2004-07-11 ANACRONTAB(5)