concatenating static string to records in data file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting concatenating static string to records in data file
# 1  
Old 06-20-2006
concatenating static string to records in data file

I just need to add a static ID to each output record so the users will be able to tell which group records in combined flatfiles come from I have the static ID in a bourne variable. I tried

awk '{print "${GroupID}" $0}' infile > outfile

But I ended up with the string ${GroupID} instead of the value of the var in the output file. Surely there's an easy way to do this? Thanks.
# 2  
Old 06-20-2006
sed "s#^#${GroupID} #" infile > outfile
# 3  
Old 06-22-2006
You can pass variables into Awk using -v (and note that they are printed without the leading $)
Code:
$ GroupID="This Group"
$ awk -v GID="$GroupID " '{print GID $0}'  names.dat
This Group Jim
This Group Jon
This Group Joe

# 4  
Old 06-22-2006
This works but I don't understand what the #s do. Do they substitute for a slash in sed? Oh, and thanks for the help. I got snowed with other issues for a couple of days so I was just able to impliment this.
# 5  
Old 06-22-2006
I had vgersh99's response open on one of my monitors since yesterday so I hadn't noticed thestevew's response. While thestevew's response looks good and would undoubtably work it's not near as obscure as vgersh99's response. So in the old unix spirit I'll go with that.
# 6  
Old 06-22-2006
Quote:
Originally Posted by gillbates
This works but I don't understand what the #s do. Do they substitute for a slash in sed? Oh, and thanks for the help. I got snowed with other issues for a couple of days so I was just able to impliment this.
Yes, that's correct - you can use ANY single character as an 'action' separator in sed. The more common and widely spread is ''/
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How can I retrieve the matching records from data file mentioned?

XYZNA0000778800Z 16123000012300321000000008000000000000000 16124000012300322000000007000000000000000 17234000012300323000000005000000000000000 17345000012300324000000004000000000000000 17456000012300325000000003000000000000000 9 XYZNA0000778900Z 16123000012300321000000008000000000000000... (8 Replies)
Discussion started by: later_troy
8 Replies

2. UNIX for Dummies Questions & Answers

Problems concatenating data using UNIX?

Hello, Can somebody help me to solve this inconsistent data issue. I have a pipe delimiter file and one of the column is a comment. I am trying to concatenate into one single sentence. For instance, I have a file actually with 2 records but the way it considers the first record is as different... (3 Replies)
Discussion started by: brialp
3 Replies

3. Shell Programming and Scripting

Concatenating the lines of a data

I have a data of 1 lac lines with the following format abcde,1,2,3,4, ,ee ,ff ,gg ,hh ,mm abcde,3,4,5,6, ,we ,qw ,as ,zx ,cf abcde,1,5,6,7, ,dd ,aa ,er .... .... (6 Replies)
Discussion started by: aravindj80
6 Replies

4. Shell Programming and Scripting

de concatenating a string

I have a variable var=string1:string2:string3 I want to get the string de-concatenated and put it as var1=string1 var2=string2 var3=string3 Thanks in advance. ---------- Post updated at 02:18 PM ---------- Previous update was at 01:45 PM ---------- I got the solution as below:... (2 Replies)
Discussion started by: Deepak62828r
2 Replies

5. Shell Programming and Scripting

Concatenating File and String for Sendmail

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

6. Shell Programming and Scripting

Concatenating string with numbers

Hi, I want to display the string value with number value. I dont know how to display. Can anyone help me. This is my code export A=${file_name} echo $a $b $sum | awk '{ printf "%011.f,%014.f,%014.f\n", $1,$2,$3}' >> ${MRR_OUTPUT} the out put shold be ${A}, $a, $b filename,... (2 Replies)
Discussion started by: easterraj
2 Replies

7. Shell Programming and Scripting

Extract data from large file 80+ million records

Hello, I have got one file with more than 120+ million records(35 GB in size). I have to extract some relevant data from file based on some parameter and generate other output file. What will be the besat and fastest way to extract the ne file. sample file format :--... (2 Replies)
Discussion started by: learner16s
2 Replies

8. UNIX for Dummies Questions & Answers

Concatenating records from 2 files

I'm trying to concatenate records from 2 files and output it to a third file. The problem I'm running into is that it seems like the "While" command is limited to processing one file at a time. It seems like you could read a record from file1 into a variable. Then do the same for the for file2.... (4 Replies)
Discussion started by: Powcmptr
4 Replies

9. UNIX for Dummies Questions & Answers

concatenating string and variable

how to concatenate a string and variable like a=rahul and i want to put it into another variable 'b' as "rahul_prasath" i dont want to use another variable for "_prasath" how to do it? (1 Reply)
Discussion started by: rolex.mp
1 Replies

10. Shell Programming and Scripting

finding null records in data file

I am having a "|" delimited flat file and I have to pick up all the records with the 2nd field having null value. Please suggest. (3 Replies)
Discussion started by: dsravan
3 Replies
Login or Register to Ask a Question