05-04-2016
And now: the desired output sample. (What be a "standard CSV format"?)
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi There
I needed to write a Unix shell 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.
Currently I am in the proess of Data Import to "Remedy System" (A one kind of incident mangement Application) and this... (8 Replies)
Discussion started by: Uday1982
8 Replies
2. Shell Programming and Scripting
HI guys,
I have created a script to read 1 column in a csv file and then place it in text file.
However, when i checked out the text file, it is not in a column format...
Example:
CSV file contains
name,age
aa,11
bb,22
cc,33
After using awk to get first column
TXT file... (1 Reply)
Discussion started by: mdap
1 Replies
3. UNIX for Advanced & Expert Users
Hi all,
I have written a shell script to search a specified directory (e.g. /home/user) for a list of specific words (shown as ${TMPDIR}/wordlist below). The script works well enough, but I was wondering if there was a way to display the line number that the word is found on?
Thanks!
cat... (1 Reply)
Discussion started by: tmcmurtr
1 Replies
4. Shell Programming and Scripting
Hi All,
I have created a Unix Shell script whch creates a *.csv file and export it to Excel.
The problem i am facing is that Users wants one of the AMOUNT field in comma separted values. Example :
if the Amount has the value as 3000000 User wants to be in 3,000,000 format.
This Amount format... (2 Replies)
Discussion started by: rawat_me01
2 Replies
5. Shell Programming and Scripting
Hi Unix Gurus,
I tried to convert the attached xhtml table content into csv file using unix shell script (lynx -dump filename) and got the below results:
Title ID Owner Priority Estimate Project Change Date Changed By
Complexity Create Date Created By Detail Estimate Total De tail... (6 Replies)
Discussion started by: bi.infa
6 Replies
6. Shell Programming and Scripting
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)
Discussion started by: rbggbr16
4 Replies
7. Shell Programming and Scripting
User Aia had created this below script to help translate LDIF files to CSV format, and it works very well (thanks again Aia if you are reading this)
Here is the original thread.
https://www.unix.com/shell-programming-and-scripting/265753-ldap-data-csv-format.html?referrerid=302170129
However... (2 Replies)
Discussion started by: tfm217
2 Replies
8. Shell Programming and Scripting
I am new to html and need to convert the attached csv file data to html format ; running into issues. please assist.
#!/bin/ksh
echo "<html>" ;
echo "<head><style> table {border-collapse: collapse;} table, td, th {border: 1px solid black;} </style></head>"
echo "<title> REPORT </title>"
echo... (0 Replies)
Discussion started by: archana25
0 Replies
9. Shell Programming and Scripting
HI ,
I m looking for help here!!!
Can we filter the below log data into CSV format ?
timestamp INFO <text > - Some text Drive ..
Need a format of separate field such as
1 2 3 4 ... (2 Replies)
Discussion started by: MohSalNiz
2 Replies
10. UNIX for Beginners Questions & Answers
I m looking for help here!!!
Can we filter the below log data into CSV format ?
1 2 3 4 5 6 7 8
timestamp INFO <text > - Some text (1 Reply)
Discussion started by: MohSalNiz
1 Replies
LEARN ABOUT CENTOS
lwp::protocol::ldap
LWP::Protocol::ldap(3) User Contributed Perl Documentation LWP::Protocol::ldap(3)
NAME
LWP::Protocol::ldap - Provide LDAP support for LWP::UserAgent
SYNOPSIS
use LWP::UserAgent;
$ua = LWP::UserAgent->new();
$res = $ua->get('ldap://ldap.example.com/' .
'o=University%20of%20Michigan,c=US??sub?(cn=Babs%20Jensen)',
Accept => 'text/json'):
DESCRIPTION
The LWP::Protocol::ldap module provides support for using ldap schemed URLs following RFC 4516 with LWP. This module is a plug-in to the
LWP protocol handling, so you don't use it directly.
In addition to being used with LDAP URIs, LWP::Protocol::ldap also acts as the base class for its sibling modules LWP::Protocol::ldaps and
LWP::Protocol::ldapi.
Features
HTTP methods supported
LWP::Protocol::ldap implements the HTTP GET and HEAD methods. They are mapped to the LDAP search operation,
Response format
Depending on the HTTP Accept header provided by the user agent, LWP::Protocol::ldap can answer the requests in one of the following
formats:
DSML
When the HTTP Accept header contains the "text/dsml" MIME type, the response is sent as DSMLv1.
JSON
When the HTTP Accept header contains the "text/json" MIME type, the response is sent as JSON. For this to work the JSON Perl module
needs to be installed.
LDIF
When the HTTP Accept header contains the "text/ldif" MIME type, the response is sent in LDIFv1 format.
HTML
In case no HTTP Accept header has been sent or none of the above MIME types can be detected, and the x-format extension has not been
provided either, the response is sent using HTML markup in a 2-column table format (roughly modeled on LDIF).
As an alternative to sending an HTTP Accept header, LWP::Protocol::ldap also accepts the "x-format" extension
Example:
ldap://ldap.example.com/o=University%20of%20Michigan,c=US??sub?(cn=Babs%20Jensen)?x-format=dsml
TLS support
For ldap and ldapi URIs, the module implements the "x-tls" extension that switches the LDAP connection to TLS using a call of the start_tls
method.
Example:
ldap://ldap.example.com/o=University%20of%20Michigan,c=US??sub?(cn=Babs%20Jensen)?x-tls=1
Note: In the above example, ideally giving "x-tls" should be sufficient, but unfortunately the parser in URI::ldap has a little flaw.
Authorization
Usually the connection is done anonymously, but if the HTTP Authorization header is provided with credentials for HTTP Basic authorization,
the credentials given in that header will be used to do a simple bind to the LDAP server.
SEE ALSO
LWP::Protocol::ldaps, LWP::Protocol::ldapi
COPYRIGHT
Copyright (c) 1998-2004 Graham Barr, 2012 Peter Marschall. All rights reserved. This program is free software; you can redistribute it
and/or modify it under the same terms as Perl itself.
perl v5.16.3 2013-06-08 LWP::Protocol::ldap(3)