I generated a csv file.But i have to manipulate it to make it user friendly. This is the structure of the input csv file.
The first line is the header.
The outpout should be:-
Explanation:- In the first row, first column i.e A2, there should be cvf in it. In B2 there should be rejected, B3 should be approved and B4 should be onhold.C2 should be 12, C3 should be 45 and C4 should be 23.
Similarly it should be for others also..
-Amit
---------- Post updated at 02:53 AM ---------- Previous update was at 02:47 AM ----------
Sorry, the input and output data is looking weird. Once more i am posting it--
Input data:-
output
------
Explanation:- In the first row, first column i.e A2, there should be cvf in it. In B2 there should be rejected, B3 should be approved and B4 should be onhold.C2 should be 12, C3 should be 45 and C4 should be 23.
Similarly it should be for others also..
-Amit
Moderator's Comments:
Use code tags please, you got a pm how to use them. Thanks.
Hi,
I want to delete the null values that are present in all the columns except the last column
$ cat x.csv
baseball,NULL,8798765,Most played,0,5,12367,NULL,NULL,98,67,Reason is not sufficient
baseball,NULL,8928192,Most played,0,4,76893,NULL,RAW,54,78,NULL
baseball,NULL,5678945,Most... (6 Replies)
Hi ,
I have a simple text file with contents as below:
12345678900 971,76 4234560890
22345678900 5971,72 5234560990
32345678900 71,12 6234560190
the new csv-file should be like:
Column1;Column2;Column3;Column4;Column5
123456;78900;971,76;423456;0890... (9 Replies)
Hi There
I need a script which will pick up the data from a .CSV file and reformat it as per the requirement and write it to another .CSV file.
I am using an application that will only take data in a particular format and need something that will convert without manual intervention.
The... (4 Replies)
Hallo Friends,
I need you help. My file has 5000 or so lines and currently looks like below(sample).
Service Type,Origin,Destination,Rate Per Minute,Minimum Charge,Time Based Rate,Time Based From Day,Time Based To Day,Time Based From Time,Time Based To Time,Destination Prefix List,,
VoIS... (3 Replies)
Hall0 Team,
I need you help. I have a .csv file called Pax.csv. It has 13 fields
The fields that i am interested in is field 7, field 10(CallDuration),field 12 and field 13(TelkomAsif)
Field 12(Cost) is affected by what is on field 7(CallType)
if field7= VoIS Community Sharecall then Cost... (14 Replies)
Hallo Team and happy Friday,
I have a .csv file attached called MHG_Only_Billing_only_great_201408_SummaryDetails.csv
The file is as below:
$ cat MHG_Only_Billing_only_great_201408_SummaryDetails.csv... (1 Reply)
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)
Hi, all
I want to sort a csv file based on timestamp from oldest to newest and save the output as csv file itself. Here is an example of my csv file.
test.csv
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0739.JPG,2015:02:17 11:32:21
/home/intannf/foto/IMG_0749.JPG,2015:02:17 11:37:28... (10 Replies)
Hi,
I have another problem. I want to sort another csv file by the first field.
result.csv
SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw
/home/intannf/foto5/2015_0313_090651_219.JPG,0.,-7.77223,110.37310,30.75,996.46,148.75,180.94,182.00,63.92 ... (2 Replies)
Discussion started by: refrain
2 Replies
LEARN ABOUT CENTOS
mail::dkim::policy
Mail::DKIM::Policy(3) User Contributed Perl Documentation Mail::DKIM::Policy(3)NAME
Mail::DKIM::Policy - abstract base class for originator "signing" policies
SYNOPSIS
# get all policies that apply to a verified message
foreach my $policy ($dkim->policies)
{
# the name of this policy
my $name = $policy->name;
# the location in DNS where this policy was found
my $location = $policy->location;
# apply this policy to the message being verified
my $result = $policy->apply($dkim);
}
DESCRIPTION
Between the various versions of the DomainKeys/DKIM standards, several different forms of sender "signing" policies have been defined. In
order for the Mail::DKIM library to support these different policies, it uses several different subclasses. All subclasses support this
general interface, so that a program using Mail::DKIM can support any and all policies found for a message.
METHODS
These methods are supported by all classes implementing the Mail::DKIM::Policy interface.
apply()
Apply the policy to the results of a DKIM verifier.
my $result = $policy->apply($dkim_verifier);
The caller must provide an instance of Mail::DKIM::Verifier, one which has already been fed the message being verified.
Possible results are:
accept
The message is approved by the sender signing policy.
reject
The message is rejected by the sender signing policy.
neutral
The message is neither approved nor rejected by the sender signing policy. It can be considered suspicious.
as_string()
The policy as a string.
Note that the string returned by this method will not necessarily have the tags ordered the same as the text record found in DNS.
is_implied_default_policy()
Is this policy implied?
my $is_implied = $policy->is_implied_default_policy;
If you fetch the policy for a particular domain, but that domain does not have a policy published, then the "default policy" is in effect.
Use this method to detect when that happens.
location()
Where the policy was fetched from.
This is generally a domain name, the domain name where the policy was published.
If nothing is published for the domain, and the default policy was returned instead, the location will be "undef".
name()
Identify what type of policy this is.
This currently returns strings like "sender", "author", and "ADSP". It is subject to change in the next version of Mail::DKIM.
SEE ALSO
Mail::DKIM::DkPolicy - for RFC4870(historical) DomainKeys sender signing policies
Mail::DKIM::DkimPolicy - for early draft DKIM sender signing policies
Mail::DKIM::AuthorDomainPolicy - for Author Domain Signing Practices (ADSP)
AUTHOR
Jason Long, <jlong@messiah.edu>
COPYRIGHT AND LICENSE
Copyright (C) 2006-2009 by Messiah College
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.6 or,
at your option, any later version of Perl 5 you may have available.
perl v5.16.3 2010-01-23 Mail::DKIM::Policy(3)