What be so difficult in using code tags as required?
If I interpret correctly what you say, those country/currency entries already exist in output.xls. Be aware that correlating file entries based on just line numbers may be dangerous as a missing line will corrupt your results. Anyhow, try sth like (untested):
Edit: Improved above untested version:
Last edited by RudiC; 06-24-2013 at 01:08 PM..
Reason: eliminated script errors and tested it.
Hi,
Can any one tell me how to put data using shell script to a excel file from text file to other columns of excel file,leaving first column unaffected i.e it should not overwrite data in first column.
Say my text file data is:
15-dec-2008 15-dec-2009
16-dec-2008 16-dec-2009
say my first... (1 Reply)
Hi.
I wish to add data in a specific excel file on daily basis.However the currect dat's data should always come on top i.e for example should always occupy cell A7,B7,C7 ..
and the data of day before which was earlier on 7th row of each coloumn should move to 8th row..data on 8th row should... (1 Reply)
hi,
i have a text file that looks like this!
i want to generate an excel sheet out of it, removing all the junk data except the addresses
that look like
. Arrow Electrical Services
Rotating Machinery, Electrical Contracting & Mining Specialists
Onsite maintenance, breakdown... (8 Replies)
Hi,
Please help me on this.
I want to insert data from text file to excel using shell script
nawk -v r=4 -v c=4 -v val=$a -F, 'BEGIN{OFS=","}; NR != r; NR == r {$c = val; print}' "file.csv"
I used above one to insert $a value in 4th row, 4th column in an excel file.csv and it... (3 Replies)
Hi,
I want to write a program to copy a log file to Excel sheet. Excel sheet has four columns MethodName , Code , Description, Details and Time.
I want to pick these info from text file and put it in excel sheet.
here is how the text file looks -
04.17.2014 08:06:12,697... (1 Reply)
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Hi Everyone,
I want your help to write a script which will take text file as input and on the basis of delimiter ":"script will create excel sheet.
Example input:
IpAdress:InstanceName:Port:ServerName
10.255.255.1:abc:2232:xyz_abc
Output should be an excel sheet like below:
Column... (8 Replies)
I have input data looks like this which is a part of a csv file
7,1265,76548,"0102:04"
8,1266,76545,"0112:04"
I need to make the output data should look like this and the output data will be part of text file:
7|1265000 |7654899 |A|
8|12660000 |76545999 |B|
The logic behind the... (6 Replies)
Source Code of the original script is down below please run the script and try to solve this problem
this is my data and I want it column wise
2019-03-20 13:00:00:000
2019-03-20 15:00:00:000
1
Operating System
LAB
0
1
1
1
1
1
1
1
1
1
0
1 (5 Replies)
Discussion started by: Shubham1182
5 Replies
LEARN ABOUT DEBIAN
psiclean
psiclean(1)psiclean(1)NAME
psiclean - delete files in the PSI temporary directories
DESCRIPTION
The psiclean command finds a job name by scanning the input file for a keyword assignment of the form
DEFAULT:FILES:DEFAULT:NAME = string
It then goes through all of the machine's temporary directories and deletes all files of the form string.*. In previous versions of psi-
clean , temporary directories were assumed to be of the form
/tmp[0-9]/$user
In this version of psiclean , we get the names of the temporary directories from the user input file by looking for volume paths of the
form
DEFAULT:FILES:DEFAULT:VOLUMEi = string
It is essential that users see to the removal of their scratch files as soon as their job completes, because temporary directories are usu-
ally a shared resource and there is not necessarily an automatic way for files to be deleted from these areas. Thus, the last command run
after a job has finished should be the psiclean command.
The user must take care to follow certain conventions when choosing filenames. Any files which are to be kept after a job completes should
not be kept in the default temporary directories. The FILES input must be used to specify other locations for the specific files which are
to be kept. psiclean will ignore files which are specifically listed by number (e.g., PSIF_CHKPT ) in the FILES section. Files which are
not needed after the run should use the default path given in the input file. Otherwise, these files will remain on the system and will
impede other jobs.
EXAMPLE
Suppose the PSI temporary directories contained the following subdirectories and files:
/tmp1/cpuhog:
-rw-r--r-- 1 cpuhog 14492 Jun 11 16:48 dicubane.30
-rw-r--r-- 1 cpuhog 187320 Jun 8 17:20 diketene.34
-rw-r--r-- 1 cpuhog 16384 Jun 7 19:17 o4big.30
-rw-r--r-- 1 cpuhog 16384 Jun 7 19:17 o4.30
-rw-r--r-- 1 cpuhog 974848 Jun 7 18:41 o4.34
/tmp2/cpuhog:
-rw-r--r-- 1 cpuhog 14492 Jun 11 16:48 dicubane.30
-rw-r--r-- 1 cpuhog 187320 Jun 8 17:20 diketene.34
-rw-r--r-- 1 cpuhog 10904 Jun 7 18:50 o4big.30
-rw-r--r-- 1 cpuhog 10904 Jun 7 18:50 o4.30
-rw-r--r-- 1 cpuhog 973752 Jun 7 18:41 o4.34
/tmp3/cpuhog:
-rw-r--r-- 1 cpuhog 14492 Jun 11 16:48 dicubane.30
-rw-r--r-- 1 cpuhog 187320 Jun 8 17:20 diketene.34
-rw-r--r-- 1 cpuhog 8192 Jun 7 19:17 o4big.30
-rw-r--r-- 1 cpuhog 8192 Jun 7 19:17 o4.30
-rw-r--r-- 1 cpuhog 966656 Jun 7 18:41 o4.34
Let's also say that the user cpuhog is in a directory which contains an input file which has the following line in it:
DEFAULT:FILES:DEFAULT:NAME = "o4"
If the user cpuhog now executes the psiclean command, then the o4 files in the temporary directories would be deleted, leaving the follow-
ing files:
/tmp1/cpuhog:
-rw-r--r-- 1 cpuhog 14492 Jun 11 16:48 dicubane.30
-rw-r--r-- 1 cpuhog 187320 Jun 8 17:20 diketene.34
-rw-r--r-- 1 cpuhog 16384 Jun 7 19:17 o4big.30
/tmp2/cpuhog:
-rw-r--r-- 1 cpuhog 14492 Jun 11 16:48 dicubane.30
-rw-r--r-- 1 cpuhog 187320 Jun 8 17:20 diketene.34
-rw-r--r-- 1 cpuhog 10904 Jun 7 18:50 o4big.30
/tmp3/cpuhog:
-rw-r--r-- 1 cpuhog 14492 Jun 11 16:48 dicubane.30
-rw-r--r-- 1 cpuhog 187320 Jun 8 17:20 diketene.34
-rw-r--r-- 1 cpuhog 8192 Jun 7 19:17 o4big.30
AUTHOR
C. David Sherrill <sherrill@alum.mit.edu>
Psi Version 3.0 29 July, 1999 psiclean(1)