Howto add a constant column to the text file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Howto add a constant column to the text file
# 1  
Old 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
# 2  
Old 07-25-2012
Code:
 
path=$(pwd | awk -F\/ '{print $(NF-1)}')

# 3  
Old 07-25-2012
Cna you please explain me this?
# 4  
Old 07-25-2012
your file is in /a/b/c/d/f/abc.DBF


Code:
 
so pwd command gives the output as /a/b/c/d/f/abc.DBF

then you want to retrieve the folder name f.
 
-F\/ - field seperator is /
$(NF-1) - take the last before field

# 5  
Old 07-25-2012
Or
Code:
path=$(pwd)
echo ${path##*/}

Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Add a column of 0's to a text file

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

2. Shell Programming and Scripting

Need to insert text(constant) at the beginning of file

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

3. UNIX for Dummies Questions & Answers

Add a new column to a tab delimited text file

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

4. UNIX for Dummies Questions & Answers

how to add a constant value to a column in a file using unix command

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. Shell Programming and Scripting

how I can add a constant to a field without changing the file format

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

6. Shell Programming and Scripting

Add new column in Text File

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

7. Shell Programming and Scripting

How to insert some constant text at beginig of each line within a text file.

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
Login or Register to Ask a Question