10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
Hi,
I'm struggling with a problem at the minute. Basically, I have a file with >1000 columns / fields (with headers), each containing a variable number of values. I would like to stack each column such that all the data appears in a single column, e.g. the first value of column 2 is moved to... (5 Replies)
Discussion started by: TAlcock
5 Replies
2. Shell Programming and Scripting
Hi ALL,
We have requirement in a file, i have multiple rows.
Example below:
Input file rows
01,1,102319,0,0,70,26,U,1,331,000000113200000011920000001212
01,1,102319,0,1,80,20,U,1,241,00000059420000006021
I need my output file should be as mentioned below. Last field should split for... (4 Replies)
Discussion started by: kotra
4 Replies
3. Shell Programming and Scripting
Hi All,
I have the input as below:
cat input
032016002 2.891 97.109 16.605 27.172 24.017 32.207 0.233 0.021 39.810 0.077 0.026 19.644 13.882 0.131 11.646 0.102 11.449 76.265 23.735 16.991 83.009 8.840 91.160 0.020 99.980 52.102 47.898 44.004 55.996 39.963 18.625 0.121 1.126 40.189... (15 Replies)
Discussion started by: am24
15 Replies
4. Shell Programming and Scripting
Hi,
In a csv file, I want to select records where first column has zero or multiple spaces.
Eg: abc.csv
,123,a
,22,b
,11,c
a,11,d
So output should be:
,123,a
,22,b
,11,c
Please advise (5 Replies)
Discussion started by: vegasluxor
5 Replies
5. Linux
I have a .CSV file (file.csv) whose data are all enclosed in double quotes. Sample format of the file is as below:
column1,column2,column3,column4,column5,column6, column7, Column8, Column9, Column10
"12","B000QRIGJ4","4432","string with quotes, and with a comma, and colon: in... (3 Replies)
Discussion started by: dhruuv369
3 Replies
6. Shell Programming and Scripting
I have a csv dump from sql server that needs to be converted so it can be feed to another program. I already sorted on field 1 but there are multiple columns with same field 1 where it needs to be compared against and if it is same then append field 5.
i.e from
ANG SJ,0,B,LC22,LC22(0)
BAT... (2 Replies)
Discussion started by: nike27
2 Replies
7. Shell Programming and Scripting
Hi experts,
I need to print the first field first then last two fields should come next and then i need to print rest of the fields.
Input :
a1,abc,jsd,fhf,fkk,b1,b2
a2,acb,dfg,ghj,b3,c4
a3,djf,wdjg,fkg,dff,ggk,d4,d5
Expected output:
a1,b1,b2,abc,jsd,fhf,fkk... (6 Replies)
Discussion started by: 100bees
6 Replies
8. Shell Programming and Scripting
Hi,
I have a requirement with,
No~Dt~Notes
1~2011/08/1~"aaa
bbb
ccc
ddd
eee
fff
ggg
hhh"
Single column alone got splitted into multiple lines.
I require the output as
No~Dt~Notes
1~2011/08/1~"aaa<>bbb<>ccc<>ddd<>eee<>fff<>ggg<>hhh"
mean to say those new lines to be... (1 Reply)
Discussion started by: Bhuvaneswari
1 Replies
9. Shell Programming and Scripting
Hi,
I have a file that has data in it that says
00:01:48.233 1212
00:01:56.233 345
00:09:01.221 5678
00:12:23.321 93444
The file has more line than this but i just wanted to put in a snippet to ask how I would get the highest number with time stamp into another file. So from the above... (2 Replies)
Discussion started by: pat4519
2 Replies
10. UNIX for Dummies Questions & Answers
Hi,
I have a semi colon delimited file of following layout:
FName;Email;LName;Age
eg.
Simon;simon@email.com;Pat;30
Pat;pat@simon@email.com;Simon;25
Sachin;sachin@email.com;Kambli;44
I want to get all records with a particular FName as Simon and LName Pat :confused: How do I dowit?
... (4 Replies)
Discussion started by: c2b2
4 Replies
File::Copy(3pm) Perl Programmers Reference Guide File::Copy(3pm)
NAME
File::Copy - Copy files or filehandles
SYNOPSIS
use File::Copy;
copy("file1","file2");
copy("Copy.pm",*STDOUT);'
move("/dev1/fileA","/dev2/fileB");
use POSIX;
use File::Copy cp;
$n = FileHandle->new("/a/file","r");
cp($n,"x");'
DESCRIPTION
The File::Copy module provides two basic functions, "copy" and "move", which are useful for getting the contents of a file from one place
to another.
o The "copy" function takes two parameters: a file to copy from and a file to copy to. Either argument may be a string, a FileHandle ref-
erence or a FileHandle glob. Obviously, if the first argument is a filehandle of some sort, it will be read from, and if it is a file
name it will be opened for reading. Likewise, the second argument will be written to (and created if need be). Trying to copy a file
on top of itself is a fatal error.
Note that passing in files as handles instead of names may lead to loss of information on some operating systems; it is recommended
that you use file names whenever possible. Files are opened in binary mode where applicable. To get a consistent behaviour when copy-
ing from a filehandle to a file, use "binmode" on the filehandle.
An optional third parameter can be used to specify the buffer size used for copying. This is the number of bytes from the first file,
that wil be held in memory at any given time, before being written to the second file. The default buffer size depends upon the file,
but will generally be the whole file (up to 2Mb), or 1k for filehandles that do not reference files (eg. sockets).
You may use the syntax "use File::Copy "cp"" to get at the "cp" alias for this function. The syntax is exactly the same.
o The "move" function also takes two parameters: the current name and the intended name of the file to be moved. If the destination
already exists and is a directory, and the source is not a directory, then the source file will be renamed into the directory specified
by the destination.
If possible, move() will simply rename the file. Otherwise, it copies the file to the new location and deletes the original. If an
error occurs during this copy-and-delete process, you may be left with a (possibly partial) copy of the file under the destination
name.
You may use the "mv" alias for this function in the same way that you may use the "cp" alias for "copy".
File::Copy also provides the "syscopy" routine, which copies the file specified in the first parameter to the file specified in the second
parameter, preserving OS-specific attributes and file structure. For Unix systems, this is equivalent to the simple "copy" routine, which
doesn't preserve OS-specific attributes. For VMS systems, this calls the "rmscopy" routine (see below). For OS/2 systems, this calls the
"syscopy" XSUB directly. For Win32 systems, this calls "Win32::CopyFile".
On Mac OS (Classic), "syscopy" calls "Mac::MoreFiles::FSpFileCopy", if available.
Special behaviour if "syscopy" is defined (OS/2, VMS and Win32)
If both arguments to "copy" are not file handles, then "copy" will perform a "system copy" of the input file to a new output file, in order
to preserve file attributes, indexed file structure, etc. The buffer size parameter is ignored. If either argument to "copy" is a handle
to an opened file, then data is copied using Perl operators, and no effort is made to preserve file attributes or record structure.
The system copy routine may also be called directly under VMS and OS/2 as "File::Copy::syscopy" (or under VMS as "File::Copy::rmscopy",
which is the routine that does the actual work for syscopy).
rmscopy($from,$to[,$date_flag])
The first and second arguments may be strings, typeglobs, typeglob references, or objects inheriting from IO::Handle; they are used in
all cases to obtain the filespec of the input and output files, respectively. The name and type of the input file are used as defaults
for the output file, if necessary.
A new version of the output file is always created, which inherits the structure and RMS attributes of the input file, except for owner
and protections (and possibly timestamps; see below). All data from the input file is copied to the output file; if either of the
first two parameters to "rmscopy" is a file handle, its position is unchanged. (Note that this means a file handle pointing to the
output file will be associated with an old version of that file after "rmscopy" returns, not the newly created version.)
The third parameter is an integer flag, which tells "rmscopy" how to handle timestamps. If it is < 0, none of the input file's time-
stamps are propagated to the output file. If it is > 0, then it is interpreted as a bitmask: if bit 0 (the LSB) is set, then time-
stamps other than the revision date are propagated; if bit 1 is set, the revision date is propagated. If the third parameter to
"rmscopy" is 0, then it behaves much like the DCL COPY command: if the name or type of the output file was explicitly specified, then
no timestamps are propagated, but if they were taken implicitly from the input filespec, then all timestamps other than the revision
date are propagated. If this parameter is not supplied, it defaults to 0.
Like "copy", "rmscopy" returns 1 on success. If an error occurs, it sets $!, deletes the output file, and returns 0.
RETURN
All functions return 1 on success, 0 on failure. $! will be set if an error was encountered.
NOTES
o On Mac OS (Classic), the path separator is ':', not '/', and the current directory is denoted as ':', not '.'. You should be careful
about specifying relative pathnames. While a full path always begins with a volume name, a relative pathname should always begin with a
':'. If specifying a volume name only, a trailing ':' is required.
E.g.
copy("file1", "tmp"); # creates the file 'tmp' in the current directory
copy("file1", ":tmp:"); # creates :tmp:file1
copy("file1", ":tmp"); # same as above
copy("file1", "tmp"); # same as above, if 'tmp' is a directory (but don't do
# that, since it may cause confusion, see example #1)
copy("file1", "tmp:file1"); # error, since 'tmp:' is not a volume
copy("file1", ":tmp:file1"); # ok, partial path
copy("file1", "DataHD:"); # creates DataHD:file1
move("MacintoshHD:fileA", "DataHD:fileB"); # moves (don't copies) files from one
# volume to another
AUTHOR
File::Copy was written by Aaron Sherman <ajs@ajs.com> in 1995, and updated by Charles Bailey <bailey@newman.upenn.edu> in 1996.
perl v5.8.0 2002-06-01 File::Copy(3pm)