04-05-2019
It works perfectly. Many many thanks
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i want sort columns with headers based on another file headers
file1
eg: i'm having an empty file with only coumn names like
lastname firstname title expirydate stlcno status etc...
another file with same column names and some other as well but in different order...
file2
eg:firstname... (2 Replies)
Discussion started by: Man83Nagesh
2 Replies
2. UNIX for Dummies Questions & Answers
Hi All,
I have to convert the excel file which will be placed in the Unix box to a CSV file using a shell script.
Please Advise.
Thanks & Regards,
Kumar66 (1 Reply)
Discussion started by: kumar66
1 Replies
3. Shell Programming and Scripting
Hi,
I am new to scripting. I have a requirement
1.convert excel 2007 format to excel 2003 fromat
2.sort the excel file -( all columns in descending order).
This needs to be done progarmmatically. Please let me know what would be the possible steps that I would need to take inorder to... (2 Replies)
Discussion started by: eva13
2 Replies
4. UNIX for Dummies Questions & Answers
hello, I have a large file (about 1gb) that is in a file similar to the following:
I want to make it so that I can put all the duplicates where column 3 (delimited by the commas) are shown on top. Meaning all people with the same age are listed at the top.
The command I used was ... (3 Replies)
Discussion started by: jl487
3 Replies
5. Shell Programming and Scripting
Hello people,
I am having problem to sort, sed and zero padding of column in csv file.
7th column only.
Input of csv file:
1,2,3,4,5,6,4/1/2010 12:00 AM,8
1,2,3,4,5,6,3/11/2010 9:39 AM,8
1,2,3,4,5,6,5/12/2011 3:43 PM,8
1,2,3,4,5,6,12/20/2009 7:23 PM,8
Output:... (5 Replies)
Discussion started by: sean1357
5 Replies
6. Shell Programming and Scripting
Hi, I am newbie in shell script.
I need your help to solve my problem.
Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies
7. UNIX for Beginners Questions & Answers
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
8. UNIX for Beginners Questions & Answers
I have data of an excel files as given below,
file1
org1_1 1 1 2.5 100
org1_2 1 2 5.5 98
org1_3 1 3 7.2 88
file2
org2_1 1 1 2.5 100
org2_2 1 2 5.5 56
org2_3 1 3 7.2 70
I have multiple excel files as above shown.
I have to copy column 1, column 4 and paste into a new excel file as... (26 Replies)
Discussion started by: dineshkumarsrk
26 Replies
9. UNIX for Beginners Questions & Answers
I have a csv file as shown below,
xop_thy 80 avr_njk 50 str_nyu 60
avr_irt 70 str_nhj 60 avr_ngt 50
str_tgt 80 xop_nmg 50 xop_nth 40
cyv_gty 40 cop_thl 40 vir_tyk 80
vir_plo 20 vir_thk 40 ijk_yuc 70
cop_thy 70 ijk_yuc 80 irt_hgt 80
I need to align/sort the csv file based... (7 Replies)
Discussion started by: dineshkumarsrk
7 Replies
cvmkfile(1) cvmkfile(1)
NAME
cvmkfile - Create a pre-allocated file
SYNOPSIS
cvmkfile [-k <key>] [-p] [-s] [-w] [-z] <size>[k|m|g] <filename>
DESCRIPTION
cvmkfile can be used to pre-allocate a file on the Xsan volume. This
is useful and preferable when preparing a file for use in a real-time
or streaming environment as the entire file is represented in only one
file system extent. Additionally, a file can be placed onto a specific
storage pool by specifying the <key> value, which is used as the affin-
ity locator. See cvfs_config(4) for more details about affinities.
USAGE
The -k <key> optionally tells the file system where to place the data
file. If an Affinity Key is specified, the file is placed on storage
pools that are specified to support this key. If there is no storage
pool with the key specified, then the file is placed in non-exclusive
data pools. If there are no non-exclusive data pools, then ENOSPC (no
space) is returned.
The -p option forces the allocation and any subsequent expansions to be
fitted "perfectly" as multiples of the InodeExpandMin configuration
parameter. The allocation extent will always line up on and be a per-
fect multiple of the blocks specified in InodeExpandMin.
The -s option forces the allocation to line up on the beginning block
modulus of the storage pool. This can help performance in situations
where the I/O size perfectly spans the width of the storage pool's
disks.
The -w option sets the file size to be equal to <size>. Without this
option the blocks are allocated but the size is set to zero. NOTE:
Unless the -z option is used, the new file will contain undefined data.
Using the -w option is not recommended unless absolutely needed.
The -z option causes the file to be physically zeroed out. This can
take a significant amount of time.
The <size> argument specifies the number of bytes, kilobytes(k),
megabytes(m) or gigabytes(g) to allocate for the file. There is no
guarantee that all requested space will be allocated. If there is
insufficient contiguous available space to satisfy the requested amount
then a "best effort" will be performed. In this case a success value
is returned even though not all of the requested amount is allocated to
the file. Even though the allocation may not be fully satisfied, if
the -w option is specified then the file size will still reflect the
requested <size> value.
EXAMPLES
Make a file of one gigabyte with zero length. Allocate it on a storage
pool that favors the media type 6100_n8.
rock # cvmkfile -k 6100_n8 1g foobar
SEE ALSO
cvfs_config(4), cvmkdir(1)
Xsan File System December 2005 cvmkfile(1)