07-15-2009
Awk: Data Insert
Hi guys, I'm having some difficulties in insert some details to the following contents.
I need to insert "TEST" under MIR & a value "25" to the next line.
So far, I am able to insert "TEST" by using awk to capture MIR as the identifier.
However, I am having some difficulties in inserting "25" to the 2nd split line after MIR
Recordset MIR and ATR contains split lines.
I need some help to join up the split lines.
Afterwhich I need to insert value 25 to MIR recordset.
Can any nice souls here help me? Thanks
Existing Content
FAR:A|4|2
ATR:12:21:05 5-Jul-2009|
/image/bin.rls/stdf_repair XXX_TCS5B_WS2_R03_09Jul05_
09_48.stdf
MIR:3UPF22030.1||TCS5B Probe|T09-J750|J750|
||||||||||SG|||||||T09-J750
SDR:1|0|0,1|Prober|H05|ProbeCard|P02||TCS5B_WS2_R03|0|0
PMR:256|768|2|C10, k4.8, k3.5|AVDD|1|0
PMR:256|768|5|C10, k4.8, k3.5|AVDD|1|1
Expected Output
FAR:A|4|2
ATR:12:21:05 5-Jul-2009|/image/bin.rls/stdf_repair XXX_TCS5B_WS2_R03_09Jul05_09_48.stdf
MIR:3UPF22030.1|TEST|TCS5B Probe|T09-J750|J750|||||25||||||SG|||||||T09-J750
SDR:1|0|0,1|Prober|H05|ProbeCard|P02||TCS5B_WS2_R03|0|0
PMR:256|768|2|C10, k4.8, k3.5|AVDD|1|0
PMR:256|768|5|C10, k4.8, k3.5|AVDD|1|1
PS:
This is the code I'd done for inserting "TEST"
cat $atdf_file | nawk 'BEGIN {
FS="|" } {
where = match($1,"MIR*")
# Process MIR field
if (where != 0) {
replace=0
if($2 == ""){
$2 = "TEST"
OFS = "|"
print $0
break }
if(replace==0){
print $0 } }
else {
print $0 }
}
' > tmp.atdf
Last edited by nantheless; 07-15-2009 at 11:00 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
I have 2 files. File1 has data I wrote, and File2 is a file created by an application. I would like to insert the data from File1 into File2, but it has to be inserted at a certain location on File2.
I know I need to search for
"</jsp-param>
</jsp-descriptor>"
But I don't know... (4 Replies)
Discussion started by: ctcuser
4 Replies
2. UNIX for Dummies Questions & Answers
hi,
am new to unix can any one help me to insert data to afile to a specified
column.
ie to an output file with csv format i should insert some data to 2,3,4 fileds and the data in those fields should move to next fields
eg:
output file
asd,12,12,12,12,1,2,1,1,1,1,1... (10 Replies)
Discussion started by: babu@shell
10 Replies
3. Solaris
Hi All,
I enhanced a perl script that creates a table with xyz_yyyymm and insert data from xyz table before truncate xyz.I have tested it successfully in dev but when i ran it on production new table xyz_yyyymm created but did not insert any records from xyz.(No errors were thrown)The perl... (1 Reply)
Discussion started by: megh
1 Replies
4. Shell Programming and Scripting
Hi
I need to do some thing like "find and insert before that " in a file which contains many records. This will be clear with the following example.
The original data record should be some thing like this
60119827 RTMS_LOCATION_CDR INSTANT_POSITION_QUERY 1236574686123083rtmssrv7 ... (8 Replies)
Discussion started by: aemunathan
8 Replies
5. Shell Programming and Scripting
Hi all,
i have data like this
joe : 1 :a
bob : 2 :b
sue : 3 :c
foo : 4 :d
at column 2 i want to insert TOP to the top column and at column 3 i want to insert BOTTOM to the bottom column. and the result will... (12 Replies)
Discussion started by: psychop13
12 Replies
6. Shell Programming and Scripting
Hello everybody,
My problem is inserting gaussian noise to a file containing data, that is, add every single noise to the number after every 6 character.
here is my data
0910 1 2048 32.38 40 20.88 28 35.53 9.62 0.00
MSDMP0 1.790MSDMS1 2.840KCTXP2 4.400KRCMP0 4.600BOZMP0 5.640BOZMS2... (26 Replies)
Discussion started by: miriammiriam
26 Replies
7. UNIX for Dummies Questions & Answers
Hi Am Using Unix ksh...
I have file name called FILE1
Have a content in a FILE as
11/01/2012
12/07/2012
--
--
I have used one variable
DATE=12/11/2012
I wants to insert DATE variable value at last line in a file
I need Output as cat FILE1
11/01/2012
12/07/2012
-- (2 Replies)
Discussion started by: Venkatesh1
2 Replies
8. Shell Programming and Scripting
Hi folks
I have a script I wrote that basically parses a bunch of config and xml files works out were to add in the new content then spits out the data into a new file.
It all works - apart from the xml and config file format in the new file
with XML files the original XML (that ends up in... (2 Replies)
Discussion started by: dfinch
2 Replies
9. Programming
Hi guys, I would like to seek help on inserting data whenever the switch is on or off to my sensor mySQL database in phpMyAdmin from my control.php. I'm using Raspberry PI as my hardware and follow a few tutorials to create my own Web Control Interface, it works perfectly without insert method.... (1 Reply)
Discussion started by: aoiregion
1 Replies
10. Shell Programming and Scripting
if it is finding some data based on pattern 'test' then insert else if has no data based on the pattern 'test' then exit successfully
cat file | grep test > file2 (3 Replies)
Discussion started by: jagu
3 Replies
LEARN ABOUT SUSE
set_color
set_color(1) fish set_color(1)
NAME
set_color - set_color - set the terminal color
set_color - set the terminal color
Synopsis
set_color [-v --version] [-h --help] [-b --background COLOR] [COLOR]
Description
Change the foreground and/or background color of the terminal. COLOR is one of black, red, green, brown, yellow, blue, magenta, purple,
cyan, white and normal.
o -b, --background Set the background color
o -c, --print-colors Prints a list of all valid color names
o -h, --help Display help message and exit
o -o, --bold Set bold or extra bright mode
o -u, --underline Set underlined mode
o -v, --version Display version and exit
Calling set_color normal will set the terminal color to whatever is the default color of the terminal.
Some terminals use the --bold escape sequence to switch to a brighter color set. On such terminals, set_color white will result in a grey
font color, while set_color --bold white will result in a white font color.
Not all terminal emulators support all these features. This is not a bug in set_color but a missing feature in the terminal emulator.
set_color uses the terminfo database to look up how to change terminal colors on whatever terminal is in use. Some systems have old and
incomplete terminfo databases, and may lack color information for terminals that support it. Download and install the latest version of
ncurses and recompile fish against it in order to fix this issue.
Version 1.23.1 Sun Jan 8 2012 set_color(1)