|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
How to replace word in CSV
Post 302188851 by aigles on Thursday 24th of April 2008 11:09:11 AM
04-24-2008
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I want to replace a word in a file which occurs after a particular word.
For example :
$cat file.txt
CASE
WHEN
AND c1 = 'I'
AND c2= '2'
THEN 1
WHEN
AND c1= 'I'
AND c2= '0'
THEN 2
So in this example i want to replace... (4 Replies)
Discussion started by: ashwin3086
4 Replies
2. Shell Programming and Scripting
Hello Friends,
How to substitue with a word by another word in file written in VI Editor.
Thanks & Regards
Siva Ranganath
7760774961 (2 Replies)
Discussion started by: sivaranganath
2 Replies
3. Shell Programming and Scripting
Hi All,
I have a file in which a number of lines are starting with similar first word but different next words.
I want to replace the any nth word(not 1st or 2nd) with another word.
Eg:- My file contains are like this:-
Ram is a boy.
Ram is a good boy.
Ram plays cricket.
Here I want to... (2 Replies)
Discussion started by: mukeshbaranwal
2 Replies
4. Shell Programming and Scripting
Hi Everyone,
I am looking for a simple way for replacing all the files under a directory that use the server "xsgd1234dap" with "xsdr3423pap".
For Example:
In the Directory,
$pwd
/home/nick
$ grep -l "xsgd1234dap" *.sh | wc -l
119
I have "119" files that are still using... (5 Replies)
Discussion started by: filter
5 Replies
5. Shell Programming and Scripting
Hi Everybody,
I am having a query like I want to change only first three patterns of the first line in a file.
ex: I like unix unix unix unix is very much.
after using the command it should be like
I like linux linux linux unix is very much.
Thanks,
Naga (3 Replies)
Discussion started by: nagraju.allam
3 Replies
6. Shell Programming and Scripting
Hello,
I want to add a sentence to "post column" those who are only less than 30 characters.Thank you very much for your help.
"category","title","post"
"Z","Zoo","test 54325 test 45363mc."
"Z","Zen","rs2w3rsj 2d342dg 2d3s4f23 d23423s23h 2s34s2423g ds232d34 2342."
"Z","Zet","test4444... (3 Replies)
Discussion started by: hoo
3 Replies
7. UNIX for Dummies Questions & Answers
Is there a generic method for applying word wrap to all cells for a .csv file? (6 Replies)
Discussion started by: jimmyf
6 Replies
8. Shell Programming and Scripting
Hi All,
I have a XML file which is looks like as below. <<please see the attachment >>
<?xml version="1.0" encoding="UTF-8"?>
<esites>
<esite>
<name>XXX.com</name>
<storeId>10001</storeId>
<module>
... (4 Replies)
Discussion started by: Rajeev_hbk
4 Replies
9. Shell Programming and Scripting
Hi,
This should be really simple. But not sure why I am unable to crack it.
I am looking for a simple one liner to print every alternate word in a csv. say my file is having content :
abc,def,ghi,jkl,.....
i need the output as below
abc
ghi (7 Replies)
Discussion started by: ctrld
7 Replies
10. Shell Programming and Scripting
echo {mbr_key,grp_key,dep_key,abc,xyz,aaa,ccc} |
awk 'gsub(/^|abc,|$/,"") {print}'
Required output
{grp_key,xyz,aaa,ccc} (5 Replies)
Discussion started by: 100bees
5 Replies
LEARN ABOUT DEBIAN
sql::reservedwords::db2
SQL::ReservedWords::DB2(3pm) User Contributed Perl Documentation SQL::ReservedWords::DB2(3pm) NAME
SQL::ReservedWords::DB2 - Reserved SQL words by DB2 SYNOPSIS
if ( SQL::ReservedWords::DB2->is_reserved( $word ) ) { print "$word is a reserved DB2 word!"; } DESCRIPTION
Determine if words are reserved by DB2. METHODS
is_reserved( $word ) Returns a boolean indicating if $word is reserved by either DB2 5, 6, 7 or 8. is_reserved_by_db2v5( $word ) Returns a boolean indicating if $word is reserved by DB2 5. is_reserved_by_db2v6( $word ) Returns a boolean indicating if $word is reserved by DB2 6. is_reserved_by_db2v7( $word ) Returns a boolean indicating if $word is reserved by DB2 7. is_reserved_by_db2v8( $word ) Returns a boolean indicating if $word is reserved by DB2 8. reserved_by( $word ) Returns a list with DB2 versions that reserves $word. words Returns a list with all reserved words. EXPORTS
Nothing by default. Following subroutines can be exported: is_reserved is_reserved_by_db2v5 is_reserved_by_db2v6 is_reserved_by_db2v7 is_reserved_by_db2v8 reserved_by words SEE ALSO
SQL::ReservedWords <http://www-306.ibm.com/software/data/db2/udb/> AUTHOR
Christian Hansen "chansen@cpan.org" COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.8.8 2008-03-28 SQL::ReservedWords::DB2(3pm)