Sponsored Content
Top Forums Shell Programming and Scripting Perl script to accept specific columns from excel Post 302938925 by omkar.jadhav on Friday 20th of March 2015 05:11:08 AM
Old 03-20-2015
could you please shown me small examples of the same ... i will refer it for doing the modification.
thanks..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Adding columns to excel files using Perl

How do I add 4 columns to an excel file using Perl? The 4 headers for those columns will all have different names? Please help and I greatly appreciate... (1 Reply)
Discussion started by: dolo21taf
1 Replies

2. Shell Programming and Scripting

how to differentiate columns of a file in perl with no specific delimiter

Hi everybody, This time I am having one issue in perl. I have to create comma separated file using the following type of information. The problem is the columns do not have any specific delimiter. So while using split I am getting different value. Some where it is space(S) and some where it is... (9 Replies)
Discussion started by: Amiya Rath
9 Replies

3. Shell Programming and Scripting

PERL: Split Excel Workbook to Indiv Excel files

Hi, I am trying to find a way to read an excel work book with multiple worksheets. And write each worksheet into a new excel file using perl. My environment is Unix. For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
Discussion started by: sandeep78
2 Replies

4. Shell Programming and Scripting

Perl script to sort an Excel file

Hello! I need to sort a file that is partly in English partly in Bulgarian. The original file is an Excel file but I converted it to a tab-delimited text file. The encoding of the tab delimited file is UTF-8. To sort the text, the script should test every line of the text file to see if... (9 Replies)
Discussion started by: degoor
9 Replies

5. Shell Programming and Scripting

Perl script to get info from specific rows & columns (.xls file)

Hi all, I want to read some specific rows & columns in the .xls file with my script to get the data to be manipulated. Now, I can read the .xls file correctly & i can go to the specific sheet that I want but i have a problem to specify the specific rows & columns. I mean, I want to get the info... (0 Replies)
Discussion started by: Yohannita
0 Replies

6. Shell Programming and Scripting

How to accept arguments in shell script when calling in perl

I have a shell script like this: #!/bin/sh $PYTHON MetarDecoder.py < ../data/mtrs/arg1/arg2 And I'm calling it with this in perl: my $output = `./metar_parse.sh --options`; It's successful when I put in actual values for arg1 and arg2 in the shell script, but I'd like to pass arguments... (1 Reply)
Discussion started by: civilsurfer
1 Replies

7. Shell Programming and Scripting

Perl script to Merge contents of 2 different excel files in a single excel file

All, I have an excel sheet Excel1.xls that has some entries. I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls These may be in different workbooks. They are totally independent made by 2 different users. I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies

8. Shell Programming and Scripting

Need specific columns in a log file as excel.

Hi All... I am in need of few columns from a log file.. in .xls file... below is what i have tried. my log file has 16 colums with " ; " as delimiter, but i need randomn columns 1 2 3 4 5 6 10 11 16 in an excel. I tried to awk the columns with delimiter ; and it worked, below is the log... (5 Replies)
Discussion started by: nanz143
5 Replies

9. Shell Programming and Scripting

Reading specific range of columns in an Excel file

Hi All, I want to read an excel file. PFA excel, I want to read the cloumn from A to G and the V to AH starting from Row number 3. Please help me on this. (7 Replies)
Discussion started by: Abhisrajput
7 Replies

10. UNIX for Beginners Questions & Answers

Shell script, For loop output to excel as columns

Hi, I have a shell script which analyses the log folder for a specific string and throws me the output. I have used for loop since it does this in multiple servers. Now I want to save the output in a excel in the below format. Can someone please help? The output which I get Server1 : count... (14 Replies)
Discussion started by: srilaxman
14 Replies
touch(1)						      General Commands Manual							  touch(1)

NAME
touch - update access, modification, and/or change times of file SYNOPSIS
ref_file time] file_name... Obsolescent time_str file_name... DESCRIPTION
updates the access, modification, and last-change times of each argument. The file name is created if it does not exist. If no time is specified (see date(1)) the current time is used. The and options are mutually exclusive. Options The following options are available: Change the access time of file_name to time, or to the current time if time is not specified. Do not change the modification time unless is also specified. Change the modification time of file_name to time, or to the current time if time is not specified. Do not change the access time unless is also specified. Silently prevent from creating the file if it did not previously exist. Do not write any diagnostic messages concerning this condi- tion. Use the corresponding time of ref_file instead of the current time. Use the specified time instead of the current time. The option argument is a decimal number of the form: [[CC]YY]MMDDhhmm[.SS] where each two digits represents the following: CC The first two digits of the year. YY The second two digits of the year. MM The month of the year (01-12). DD The day of the month (01-31). hh The hour of the day (00-23). mm The minute of the hour (00-59). SS The second of the minute (00-61). If neither CC nor YY is given, the current year is assumed. If YY is specified, but CC is not, CC is derived as fol- lows: (taken into account the local time factor) If YY is: CC becomes: ------------------------ 69-99 19 00-68 20 If the resulting time value precedes the Epoch (00:00:00 January 1, 1970 Greenwich Mean Time), exits immediately with an error status. The range for SS is 00 through 61 rather than 00 through 59 to accommodate leap seconds. If SS is 60 or 61, and the resulting time, as affected by the environment variable, does not refer to a leap second, the resulting time is one second after a time where SS is 59. If SS is not given a value, it is assumed to be 0. The syntax shown by the second line is recognized when neither the option, the option, nor the option delimiter is specified, and the first operand consists of all decimal digits. This operand is interpreted as the time argument instead of as a file name. However, in this case, time_str is assumed to be of the form: MMDDhhmm[YY] This is for backward compatibility. The form given above is recommended for future portability. The option delimiter can be used before the first file_name if there is a possibility that file_name consists of all digits, in order to ensure that the first syntax is used. succeeds when invoked by the of the file if any of the following are true: o A time is specified. o Only the access time of the file is being updated. o Only the modification time of the file is being updated. In addition, succeeds when invoked by a user with write permission on the file if of the following are true: o No time is specified. o the access time and modification time of the file are being updated. EXTERNAL INFLUENCES
Environment Variables If the time is specified via the option, is used to interpret the time for the specified time zone. determines the language in which messages are displayed. If 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 vari- able. 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 multibyte character code sets are supported. RETURN VALUE
returns the following values: All file_name arguments were successfully changed. Prints out a diagnostic message if an invalid time or a time earlier than the Epoch was specified with the option, or if the and options were both specified, or if one or more of the file_name arguments could not be accessed. EXAMPLES
The following command sets the modification and access times of the file named "bastille" to midnight, July 14, 1989, creating the file if it does not already exist. The following command does the same thing using the backward-compatible syntax: The following command sets the time of the two files named "0714000089" and "bastille" to the current time, creating them if they do not exist: To create a zero-length file, use any of the following: DEPENDENCIES
NFS An attempt to touch a file owned by the superuser on a remote server can fail, even if the invoking user has write permission on the file. SEE ALSO
date(1), utime(2). STANDARDS CONFORMANCE
touch(1)
All times are GMT -4. The time now is 05:44 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy