07-25-2012
Howto add a constant column to the text file
Hi,
I am converting a .DBF file to pipe delimited file
my requirement is like
lets say my .DBF is residing in path /a/b/c/d/f/abc.DBF
I need my .txt file as
having a column with source _cd =f
sample data in .DBF in folder "f"
c1 c2 c3
1 2 3
in txt file it should be
c1|c2|c3|source_cd
1|2|3|f
i am suceeded in getting converted to 1|2|3
but having problem in how to get the Source_Cd from the path
regards
Angel
7 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear Folks :),
I am new to UNIX scripting and I do not know how can I insert some text in the first column of a UNIX text file at command promtp.
I can do this in vi editor by using this command :g/^/s//BBB_
e,g I have a file named as Test.dat and it containins below text:
michal... (4 Replies)
Discussion started by: Muhammad Afzal
4 Replies
2. Shell Programming and Scripting
I have one text file which is result of bdf command that have 6 fields separated by space and I want to add one new column in the beginning which is the name of the server because I have to insert whole thing into oracle table consisting of 7 fields
THis is not a complete list but it looks... (9 Replies)
Discussion started by: pareshan
9 Replies
3. Shell Programming and Scripting
Hi, I need to edit a file Protein Data Bank (pdb) and then open that file with the program VMD but when I edit the file with awk, it changes pdb format and the VMD program can not read it.
I need to subtract 34 to field 6 ($ 6).
this is a pdb file :
ATOM 918 N GLY B 103 -11.855 8.675... (8 Replies)
Discussion started by: bio_
8 Replies
4. UNIX for Dummies Questions & Answers
I have a file like this
1 chr1 3661579 3662579
2 chr1 4350395 4351395
3 chr1 4399322 4400322
4 chr1 4486494 4487494
5 chr1 4775807 4776807
6 chr1 4775807 4776807
7 chr1 4775807 4776807
8 chr1 4796973 4797973
9 chr1 4846774 4847774... (3 Replies)
Discussion started by: sunsnow86
3 Replies
5. UNIX for Dummies Questions & Answers
I want to add a new column to a tab delimited text file. It will be the first column and it will just be 1's. How do I go about doing that? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies
6. Shell Programming and Scripting
I am very new to scripting and I know this request is simple but I am having no luck with it.
I have a file a.dat with the following data in it.
aa
bb
cc
dd
I need to run a script that will take each line of a.dat and put dsjc/ubin/ in front of each record, so the output looks like
... (2 Replies)
Discussion started by: jclanc8
2 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I have a text file with many column (1,000,000+). I want to add a column of 0's as the third column. I tried:
awk '{$3=0}1' input file > output file
But it simply replaces the third column with 0's instead of adding a new column. How do I go about doing this? Thanks! (2 Replies)
Discussion started by: evelibertine
2 Replies