10-08-2007
Concatenating values in a File
Hi All,
I have a ',' delimited file and i would like concatenate a new value at a specific column.
Example :-
xXXX,XYZ,
20071005,ABC,DEF,123
xXXX,XYZ,
20071005,ABC,DEF,123
xXXX,XYZ,
20071005,ABC,DEF,123
The output that i want is
xXXX,XYZ,20071005
001,ABC,DEF,123
xXXX,XYZ,20071005
002,ABC,DEF,123
xXXX,XYZ,20071005
003,ABC,DEF,123
........
xXXX,XYZ,20071005
010,ABC,DEF,123
xXXX,XYZ,20071005
011,ABC,DEF,123
and so .... on....
As you see the only difference is in the Column # 3 where i want to add 001, 002, 003 .... till the end of file [ in the above example there are 11 records so last updated value is 20071005011 ], however all other values should remain the same.
Please let me know if you have any doubts about the query.
and thanks for your time.
![Smilie Smilie](https://www.unix.com/images/smilies/smile.gif)
Amit
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi
My requirement is i have a file with some records like this
file name ::xyz
a=1
b=100,200
,300,400
,500,600
c=700,800
d=900
i want to change my file
a=1
b=100,200,300,400
c=700,800
d=900
if record starts with " , " that line should fallows the previous line.please give... (6 Replies)
Discussion started by: srivsn
6 Replies
2. UNIX for Dummies Questions & Answers
Hi All,
I want to concatenate the array cell values and form a string.. Is it possible?
for ex.
I have an array
word_array contains d u m b and after concatenating the string shld be 'dumb'
thanks (2 Replies)
Discussion started by: mathur
2 Replies
3. Shell Programming and Scripting
Hi,
I have a table in Db2 with data say
id_1 phase1
id_1 phase2
id_1 phase3
id_2 phase1
id_2 phase2
I need to concatenate the values like
id_1 phase1,phase2,phase3
id_2 phase1,phase2
I tried recursive query but in vain as the length of string to be concatenated in quite long. ... (17 Replies)
Discussion started by: jsaravana
17 Replies
4. Shell Programming and Scripting
I want o add a variable in addition to a file which will be send with sendmail. I have problems to find the correct syntax for concatenating this variable called $MyVariable.
sendmail mai@domain.com </tmp/errormessage.txt $MyVariable]
Thanks for your help! (2 Replies)
Discussion started by: high5
2 Replies
5. Shell Programming and Scripting
I have the following script in a shell
# The start of a filename
file=$(ls -tr $EMT*.dat | tail -1) # Select the latest file echo $file
file_seq=$( < /u02/sct/banner/bandev2/xxxxxx/misc/EFTSQL.dat)
echo $file_seq
file2 = '$file_seq + 1'
echo $file2
It is reading a file EFTSQL.dat... (3 Replies)
Discussion started by: rechever
3 Replies
6. Shell Programming and Scripting
Hi
This is a simple one but I got a lost in translation when doing.
What I want to do, given both variables in the example below, to get one value at the time from both variables, for example:
1:a
2:b
etc...
I need to get this in bash scripting
code:
varas="1 2 3 4"
varbs="a b c d"... (4 Replies)
Discussion started by: ranmanh
4 Replies
7. Shell Programming and Scripting
Hi,
I have a unix file with the below structure -
CustId1 CustName1 CustPhn1 /u/home/xmldata/A000001
CustId2 CustName2 CustPhn2 /u/home/xmldata/A000002
CustId3 CustName3 CustPhn3 /u/home/xmldata/A000003
Then I have another unix directory /u/home/xmldata
This directory has... (3 Replies)
Discussion started by: Simanto
3 Replies
8. Shell Programming and Scripting
I have 3 files
File1
C1 C2 c3
File 2
C1 c2 c3
File 3
C1 c2 c3
Now i want to have
File1 as C1 c2 c3 I
File2 as C1 c2 c3 O
File3 as c1 c2 c3 D
and these 3 files should be concatenated into a single file
how can it be done in unix script? (3 Replies)
Discussion started by: Codesearcher
3 Replies
9. UNIX for Dummies Questions & Answers
Hi there, shameful Linux Newbie here :p
I was wondering if you could help with my problem...
I have plenty of files I'd like to concatenate. I know how to basically use cat command but that won't be enough from what I need : excluding the last xx bytes from files before assembling since there's... (4 Replies)
Discussion started by: grolido
4 Replies
10. UNIX for Beginners Questions & Answers
I want to add the sequence length of File_1.fa and File _2.fa to form the form the fifth column in File_1_pos.txt and File_2_poa.txt respectively using awk and bash. Can anyone help me? Thanks
Get sequence length of each file
File_1.fa
File_2.fa
Add the sequence length to be the third... (6 Replies)
Discussion started by: Ibk
6 Replies
LEARN ABOUT DEBIAN
padre::help
Padre::Help(3pm) User Contributed Perl Documentation Padre::Help(3pm)
NAME
Padre::Help - Padre Help Provider API
DESCRIPTION
The "Padre::Help" class provides a base class, default implementation and API documentation for help provision support in Padre.
In order to setup a help system for a document type called "XYZ" one has to do the following: Create a module called "Padre::Help::XYZ"
that subclasses the "Padre::Help" module and override 3 methods: "help_init", "help_list" and "help_render".
In the class representing the Document ("Padre::Document::XYZ") one should override the "get_help_provider" method and return an object of
the help provide module. In our case it should contain
require Padre::Help::XYZ;
return Padre::Help::XYZ->new;
(TO DO: Maybe it should only return the name of the module)
The "help_init" method is called by the new method of "Padre::Help" once for every document of "XYZ" kind. (TO DO: maybe it should be only
once for every document type, and not once for every document of that type).
"help_list" should return a reference to an array holding the possible strings the system can provide help for.
"help_render" is called by one of the keywords, it should return the HTML to be displayed as help and another string which is the location
of the help. Usually a path to a file that will be used in the title of the window.
perl v5.14.2 2012-06-27 Padre::Help(3pm)