Visit Our UNIX and Linux User Community


insert a variable in the last column of a file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting insert a variable in the last column of a file
# 1  
Old 12-06-2007
insert a variable in the last column of a file

i want to insert a variable in the last column of a file, the columns are separated by "|". I want to insert the variable in everyline of the file .
# 2  
Old 12-06-2007
You want to substitute the existing value of the last field,
or you want to append a new filed?
# 3  
Old 12-06-2007
Is is what you are meaning?

$ cat unx.out
fan|2|3.45
fan1|r42|2.15
fanw1|t|5

To insert "jks" in the last column.

$ awk -F "|" '{print $0"|jks"}' unx.out
fan|2|3.45|jks
fan1|r42|2.15|jks
fanw1|t|5|jks

//Jadu
# 4  
Old 12-06-2007
i want to append
# 5  
Old 12-06-2007
try this

cat <filename> | sed s/$/"\|"hello/g > new_file.txt
# 6  
Old 12-06-2007
With awk:

Code:
awk '{sub(/[^|]*$/,"&|new value")}1' filename

or

Code:
awk 'NF=NF+1{$NF="new value"}1' FS="|" OFS="|"  filename

Use nawk or /usr/xpg4/bin/awk on Solaris.
# 7  
Old 12-06-2007
thanx

But i want to use the value of a variable ,when i give $variable its inserting $variable not the value of variable

iam using this snippet-
nawk '{sub(/[^|]*$/,"&|$date")}1' catalog_details.dat

Previous Thread | Next Thread
Test Your Knowledge in Computers #340
Difficulty: Easy
Apache2 is a web server developed by Apple Computer.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Bash: Insert in a variable a file

hi all i have a problem in the bash shell. i'd like insert in a variable a file for example : i have a file datafine.log in this file there is : 17/JUN/2019 i want to insert the value of datafine.log in a variable. Regards Frncesco edit by bakunin: please use CODE-tags for your data... (2 Replies)
Discussion started by: Francesco_IT
2 Replies

2. UNIX for Beginners Questions & Answers

How to insert data into black column( Secound Column ) in excel (.XLSX) file using shell script?

Source Code of the original script is down below please run the script and try to solve this problem this is my data and I want it column wise 2019-03-20 13:00:00:000 2019-03-20 15:00:00:000 1 Operating System LAB 0 1 1 1 1 1 1 1 1 1 0 1 (5 Replies)
Discussion started by: Shubham1182
5 Replies

3. Shell Programming and Scripting

Insert value of column based on file name matching

At the top of the XYZ file, I need to insert the ABC data value of column 2 only when ABC column 1 matches the prefix XYZ file name (not the ".txt"). Is there an awk solution for this? ABC Data 0101 0.54 0102 0.48 0103 1.63 XYZ File Name 0101.txt 0102.txt 0103.txt ... (7 Replies)
Discussion started by: ncwxpanther
7 Replies

4. Shell Programming and Scripting

Insert value of env variable in xml file

Hello, I have the following variables set in my env echo $MY_XSD_FILE /home/jak/sample.xsd echo $MY_INTERVAL_VALUE 4 I want to insert them between the xml tags in my xml file cat sample.xml ::::::::::::::: ::::::::::::::: <property name="FILE"></property> :::::::::::::::::::::::... (2 Replies)
Discussion started by: jakSun8
2 Replies

5. UNIX for Dummies Questions & Answers

insert a column into file

hi everybody! Could u show me how to do following: I have files (in total 22) .txt that contain one column of values (the total number of values varies from file to file from 40.0000 to 10.000). For example: 742429 758311 995669 1008567 1011278 1011521 1020428 1021403 ... And I need... (2 Replies)
Discussion started by: kush
2 Replies

6. Shell Programming and Scripting

Insert a variable to a text file after fixed number of lines

Hi, I am new to unix. I need to insert a variable which contains some lines of text into a text file after fixed number of lines.. Please help me on this.. Thanks in Advance, Amrutha (3 Replies)
Discussion started by: amr89
3 Replies

7. Shell Programming and Scripting

script to insert variable file into another, bit like C's #include

Hi, I want to insert one file into another like this: file 1: 1 2 3 <!-- #include file="file2" --> 4 5 <!-- #include file="file3" --> 6 with the complete output going to another file. Have seen some solutions to similar problems using sed, but this problem is different because it is... (5 Replies)
Discussion started by: cvq
5 Replies

8. Shell Programming and Scripting

Insert text into file depending on variable

Hey guys , i have a variable with the contents ... NUMBER=4 and a test file with the contents 1248 1213 1214 1278 1200 3045 3444 2130 I want to execute a script that will produce the following output ( based on NUMBER=4) to be ... create 1248 (1 Reply)
Discussion started by: theshams
1 Replies

9. Shell Programming and Scripting

insert line into file using variable

Hi all, I am trying to insert couple of lines before first occurance of line3 which occuring after line 5. So I identified the line 5 line number in the file. Also redirected the all line3 line number to out.txt. Now I have problem in inserting the line using the variable $rep. Please help me... (2 Replies)
Discussion started by: aimmanuel
2 Replies

10. Shell Programming and Scripting

Insert first line of a file to first column of remaining files

I want to extraxt data from a html table the html file is downloaded from UG / PG Univ - Exam.Results April/May 2008 After processing the html file using sed i got the output like this 11305106082,RANJANI R, CS1251,20,69,P CS1302,20,45,P EC1006,20,52,P EC1351,20,53,P... (5 Replies)
Discussion started by: a_artha
5 Replies

Featured Tech Videos