05-05-2015
I don't see why you need to modify commas for what you seem to be trying to do.
How is the <newline> (or <carriage-return><newline>) incorrectly inserted in field 4 supposed to be modified? Should it/they be removed, replaced by a single space, or replaced by two spaces (as in your sample)?
Does the software that creates your input ever incorrectly insert <newline> characters in field 5? Does it ever incorrectly insert <newline> characters in fields 1, 2, or 3?
Can there be more than one <newline> character incorrectly inserted in field 4 for what should be a single input line?
This User Gave Thanks to Don Cragun For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have an input data file :-
Test4599,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,2,2,Rain
Test90,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,0,Not Rain
etc....
I wanted to transpose these data to:-... (2 Replies)
Discussion started by: ahjiefreak
2 Replies
2. Shell Programming and Scripting
Hi.
I have this data below:-
v1 28 14 1.72414 1.72414 1.72414 1.72414 1.72414
v2 77 7 7.47126 6.89655 6.89655 6.89655 6.89655
v3 156 3 21.2644 21.2644 20.6897 21.2644 20.6897
v4 39 3 1.72414 1.72414 1.72414 1.72414 1.72414
v5 155 1 21.2644 23.5632 24.1379 23.5632 24.1379
v6 62 2 2.87356... (2 Replies)
Discussion started by: ahjiefreak
2 Replies
3. Shell Programming and Scripting
Hi,
I did read a few posts on the subjects, tried out a few solutions, but did not solve my problem.
https://www.unix.com/302121568-post11.html
https://www.unix.com/shell-programming-scripting/137953-large-file-columns-into-rows-etc-4.html
Please help. Problem very similar to the second link... (15 Replies)
Discussion started by: genehunter
15 Replies
4. Shell Programming and Scripting
Hi I'm looking to transpose Linux data from a daily report that logs every 10mins like below.
After the first "comma" I need the daily total for Col2 and Col3 transposed like below.
The new transposed format below will then be exported to Microsoft Excel for Reporting.
Any help would be... (9 Replies)
Discussion started by: ravzter
9 Replies
5. Shell Programming and Scripting
Hello. very new to shell scripting and would like to know if anyone could help me.
I have data thats being pulled into a txt file and currently have to manually transpose the data which is taking a long time to do.
here is what the data looks like.
Server1 -- Date -- Other -- value... (7 Replies)
Discussion started by: Mikes88
7 Replies
6. Shell Programming and Scripting
I can no longer find my commands, but I use to be able to transpose data with common fields from a single column to rows using a command line. My data is separated as follows:
NAME=BOB
ADDRESS=COLORADO
PET=CAT
NAME=SUSAN
ADDRESS=TEXAS
PET=BIRD
NAME=TOM
ADDRESS=UTAH
PET=DOG
I would... (7 Replies)
Discussion started by: docdave78
7 Replies
7. Shell Programming and Scripting
Hi I have below requirement, need help
One file contains the meta data information and other file would have the data, match the column from file1 and with file2 and extract corresponding column value and display in another file
File1:
CUSTTYPECD
COSTCENTER
FNAME
LNAME
SERVICELVL
... (1 Reply)
Discussion started by: ravlapo
1 Replies
8. Shell Programming and Scripting
Hi,
Below is my input file:
c116_g1_i1 -,-,-,+
c118_g2_i1 +,+
c118_g3_i1 +
c120_g1_i1 +,+,+,+
.
.
Desired Output File
c116_g1_i1 -
c116_g1_i1 -
c116_g1_i1 -
c116_g1_i1 +
c118_g2_i1 +
c118_g2_i1 + (3 Replies)
Discussion started by: perl_beginner
3 Replies
9. UNIX for Beginners Questions & Answers
Hi All,
I have sort of a case to transpose data from rows to column
input data
Afghanistan|10000|1
Albania|25000|4
Algeria|25000|7
Andorra|10000|4
Angola|25000|47
Antigua and Barbuda|25000|23
Argentina|5000|3
Armenia|100000|12
Aruba|20000|2
Australia|50000|2
I need to transpose... (3 Replies)
Discussion started by: radius
3 Replies
10. UNIX for Beginners Questions & Answers
Hi
I have the following sample of data: my full data dimention is 900,000* 1119
rs987435 C G 1 1 1 0 2
rs345783 C G 0 0 1 0 0
rs955894 G T 1 1 2 2 1
rs6088791 ... (7 Replies)
Discussion started by: marwah
7 Replies
LEARN ABOUT DEBIAN
chart::clicker::data::dataset
Chart::Clicker::Data::DataSet(3pm) User Contributed Perl Documentation Chart::Clicker::Data::DataSet(3pm)
NAME
Chart::Clicker::Data::DataSet - A collection of series
VERSION
version 2.83
SYNOPSIS
use Chart::Clicker::Data::DataSet;
use Chart::Clicker::Data::Series;
my @vals = (12, 19, 90, 4, 44, 3, 78, 87, 19, 5);
my @keys = (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
my $series = Chart::Clicker::Data::Series->new({
keys => @keys,
values => @vals
});
my $ds = Chart::Clicker::Data::DataSet->new({
series => [ $series ]
});
DESCRIPTION
Chart::Clicker::Data::DataSet is a set of Series that are grouped for some logical reason or another. DatasSets can be associated with
Renderers in the Chart. Unless you are doing something fancy like that you have no reason to use more than one in your chart.
max_key_count
Get the number of keys in the longest series. This will be set automatically.
ATTRIBUTES
context
Set/Get the context this DataSet will be charted under.
domain
Get the Range for the domain values
range
Get the Range for the... range values...
series
Set/Get the series for this DataSet
METHODS
add_to_series
Add a series to this dataset.
count
Get the number of series in this dataset.
get_series ($index)
Get the series at the specified index.
get_all_series_keys
Returns an array of keys representing the union of all keys from all DataSets.
get_series_keys
Returns the key at the specified position for every series in this DataSet.
get_series_values
Returns the value at the specified position for every series in this DataSet as an ArrayRef.
get_series_values_for_key
Returns the value for the specified key for every series in this DataSet as an ArrayRef.
largest_value_slice
Finds the largest cumulative 'slice' in this dataset.
AUTHOR
Cory G Watson <gphat@cpan.org>
COPYRIGHT AND LICENSE
This software is copyright (c) 2012 by Cold Hard Code, LLC.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
perl v5.14.2 2012-06-22 Chart::Clicker::Data::DataSet(3pm)