Search Results

Please refer the link, this might help you.

https://www.unix.com/shell-programming-scripting/99133-csv-file-array-match-field1-replace-flat-file-field1-field2.html

Thanks.

otheus,

It is working now.Tons of thanks !!!

I tried at first, but it is not working.

Even this is not working:

tr/\n\r//d,s/"/""/g,1

You are Genius !!! It is working. Thanks.

I hope this is the last question:

What if I dont want to remove the quotes, but add another quotes to quotes, I mean escaping the quotes with...

Thanks it is working.

But I am seeing that it is removing the blank field completely, so field values are not matching up with headers. This is happening in both the cases:

(tr/"//d,$_) and...

Hi,

I am amazed !!! It works. You people are really expert. Thanks.

Using the above command, I was able to remove quotes within the field. But I can see that there are some newline/breakline...

Let me explain this further, the output of my file looks as following :

"Domain","address","department","displayname","sn","roomno","site","location"
"Internal","1234","HCM","John D","JOHN...

Kevin-

I really thank you for all your efforts.

Might be any other Perl experts can help me out on this forum.

Thanks for reply.

However, it is not working. Can't you put the same thing on this variable "$_[0]"?

I believe this is value which gets printed.

This is not working, but may be we are coming closer.

actually the fields are printed out from "$entry" variable, so can't we put something around the variable or into the subroutine "get".
...

I really appreciate your effort Kevin.

The following commad actually prints header, cant we use the same thing on the below line which prints data field values;

print '"'.(join '","',...

Sorry,

The perl script got distorted while posting, here is snapshot of the exact line:

foreach $entry ($mesg->all_entries) # for each entry
{
@dn = map {s/[a-z]+=//gi; $_ = ucfirst}...

Hi,

I got this script from the web, this generates an LDAP report in CSV format.


#!/usr/bin/perl
#
# Copyright (c) 2004
# Ali Onur Cinar &060;cinar&064;zdo.com&062;
#
# License:
#
#...