10-18-2013
Thanks a lot guys. It helped!!!
Now an addition to it:
TABLE_1
TABLE_2
TABLE_3
are transposed as TABLE_1,TABLE_2,TABLE_3
Now I need it as 'TABLE_1','TABLE_2','TABLE_3'
Again to make sure the last character is not a comma.
Appreciate your support.
Cheers,
NG
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
dear all:
maybe i have a file like :
12
34
56
78
end
how do write can i replace newline into NA :
make the file inte :
12
NA
34
NA
56
78
END (3 Replies)
Discussion started by: jeter
3 Replies
2. Shell Programming and Scripting
Hi, for some reason I cant seem to figure this out. I have a file which looks something like this
word
word
word
word
word,word,word
word
word
word,word,word,word,word
word
word
Basically I want this whole thing to be a list with 1 word on each line like this...
word
word
word... (1 Reply)
Discussion started by: eltinator
1 Replies
3. Shell Programming and Scripting
SHELL SCRIPT
Hi
I have a file in the following format
Mayank Sushant
Dheeraj Kunal
ARUN Samir
How can i replace the white space in between and replace them with a comma?? The resultant output should be
Mayank,Sushant
Dheeraj,Kunal
ARUN,Samir
i tried using
sed -e... (8 Replies)
Discussion started by: mayanksargoch
8 Replies
4. Shell Programming and Scripting
I have output from a file like this:
15,01,11,14:06
235
I would like to change this to:
15,01,11,14:06,235
Removing newline and change to ","
I now this can be done with tr
cat OUT | tr '\n' ',''
My problem is that tr is not implemented in this shell. sed is, show it should be... (7 Replies)
Discussion started by: Jotne
7 Replies
5. Shell Programming and Scripting
I am trying to search the pattern "ARS (11)" and after the LAST pattern, i am trying to open new line and enter text using sed.
My Existing Text file is Users.txtpaul, Paul Smith, Stevn Smiley, REQ000001, ARS (11)
sam, Sam Martin, Stevn Smiley, REQ000001, ARS (11)
mike, Mike Conway, Stevn... (8 Replies)
Discussion started by: evrurs
8 Replies
6. Shell Programming and Scripting
The input file is as below
AR,age,marks,roll,section,evin,25,80,456,A,atch,23,56,789,B,eena,24
,78H245,C,Ps,ot,ecessary,hat,ame comes first then age and rest AR
AZ,kevin,25,80,456,A,Satch,23,56,789,Satch,23,56,789,B,Meena,24,78,H245,C,AZ
................
................
I am writting... (8 Replies)
Discussion started by: millan
8 Replies
7. Shell Programming and Scripting
Hi ,
I have a huge file with following records and I want to replace the last comma with ',NULL'. I try using SED but could not create a correct script .
In my opinion I need a script which can convert ,/n with ,NULL/n
1,CHANGE_MEMBER,2010-12-28 00:05:00,
2,CHANGE_MEMBER,2012-09-02... (8 Replies)
Discussion started by: Ajaypal
8 Replies
8. Shell Programming and Scripting
I,
I have a file and i need to replace comma and blank space with comma and 0.
cat file.txt
a,5
b,1
c,
d,
e,4
I need the output as
cat file.txt
a,5
b,1
c,0
d,0 (4 Replies)
Discussion started by: jaituteja
4 Replies
9. Shell Programming and Scripting
I have a comma delimited file of major codes and descriptions. I want to replace all occurrences of spaces with underscores up to the first comma (only in the first field), but not replace spaces following the comma. For instance I have the following snippet of the file:
EK ED,Elementary and... (7 Replies)
Discussion started by: tdouty
7 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I have below requirement.
Apple
Orange
Banana
Required O/p in bash
'Apple,Orange,Banana'
Can you please help.
Please wrap your samples, codes in CODE TAGS as per forum rules. (3 Replies)
Discussion started by: Rtk
3 Replies
LEARN ABOUT DEBIAN
net::inet6glue
Net::INET6Glue(3pm) User Contributed Perl Documentation Net::INET6Glue(3pm)
NAME
Net::INET6Glue - Make common modules IPv6 ready by hotpatching
SYNOPSIS
use Net::INET6Glue; # include all glue
use LWP;
use Net::SMTP;
use Net::FTP;
..
DESCRIPTION
Net::INET6Glue is a collection of modules to make common modules IPv6 ready by hotpatching them.
Unfortunatly the current state of IPv6 support in perl is that no IPv6 support is in the core and that a lot of important modules (like
Net::FTP, Net::SMTP, LWP,...) do not support IPv6 even if the modules for IPv6 sockets Socket6, IO::Socket::INET6 are available.
This module tries to mitigate this by hotpatching. Currently the following submodules are available:
Net::INET6Glue::INET_is_INET6
Makes IO::Socket::INET behave like IO::Socket::INET6, especially make it capable to create IPv6 sockets. This makes LWP, Net::SMTP and
others IPv6 capable.
Net::INET6Glue::FTP
Hotpatches Net::FTP to support EPRT and EPSV commands which are needed to deal with FTP over IPv6. Also loads
Net::INET6Glue::INET_is_INET6.
COPYRIGHT
This module and the modules in the Net::INET6Glue Hierarchy distributed together with this module are copyright (c) 2008, Steffen Ullrich.
All Rights Reserved. These modules are free software. They may be used, redistributed and/or modified under the same terms as Perl itself.
perl v5.12.3 2011-08-27 Net::INET6Glue(3pm)