Sponsored Content
Top Forums Shell Programming and Scripting Overwrite specific column in xml file with the specific column from adjacent line Post 302958155 by RudiC on Tuesday 20th of October 2015 04:24:19 AM
Old 10-20-2015
Something alomg this line?
Code:
awk '$9=="NaN" {sub ("NaN",last9)} $11=="NaN" {sub ("NaN", last11)} {last9=$9; last11=$11} 1' file

This User Gave Thanks to RudiC For This Post:
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Retrieve line from a file based on a value in specific column

Hi, I have a file that has several values seperated by ":" 2006:John:Student:Football:Portugal:Cinema 2006:James:Engineer:Basket:Poland:Theatre 2007:Lucy:Diver:Gymnastic:England:Music 2007:Smith:Plumber:Basket:Spain:Poker I need make a filter based on the 5th field to find countries that... (1 Reply)
Discussion started by: efernandes
1 Replies

2. UNIX for Dummies Questions & Answers

(cont) Retrieve line from a file based on a value in specific column

HI, Your help was great: awk -F":" '$5 ~ /^P/{print }' file I would like to know what changes need to be done to this line code, so that I can put it in a shell script and call it as the example below. example: countries that start with chacater 'P' > country P Result: ... (0 Replies)
Discussion started by: efernandes
0 Replies

3. Shell Programming and Scripting

4 column tsv file, output 1 specific column

Hello all siteexplorer.search.yahoo.com can output results in tsv format, when opened in excel I get 4 columns. I would like to wget that file, which I can do. I would then like to pull the 2nd column and output it only. I've searched around and found a few bits and pieces but nothing I've... (6 Replies)
Discussion started by: casphar
6 Replies

4. Shell Programming and Scripting

Assigning a specific format to a specific column in a text file using awk and printf

Hi, I have the following text file: 8 T1mapping_flip02 ok 128 108 30 1 665000-000008-000001.dcm 9 T1mapping_flip05 ok 128 108 30 1 665000-000009-000001.dcm 10 T1mapping_flip10 ok 128 108 30 1 665000-000010-000001.dcm 11 T1mapping_flip15 ok 128 108 30... (2 Replies)
Discussion started by: goodbenito
2 Replies

5. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

I have a text file in the following format: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 13402 NA07019... (3 Replies)
Discussion started by: evelibertine
3 Replies

6. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

Hi, I have a text file in the following format: Code: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 ... (2 Replies)
Discussion started by: evelibertine
2 Replies

7. Shell Programming and Scripting

convert huge .xml file in .csv with specific column.

I have huge xml file in server and i want to convert it to .csv with specific column ... i have search in blog but i didn't get any usefully command. Thanks in advance (1 Reply)
Discussion started by: pareshkp
1 Replies

8. Shell Programming and Scripting

Replace column that matches specific pattern, with column data from another file

Can anyone please help with this? I have 2 files as given below. If 2nd column of file1 has pattern foo1@a, find the matching 1st column in file2 & replace 2nd column of file1 with file2's value. file1 abc_1 foo1@a .... abc_1 soo2@a ... def_2 soo2@a .... def_2 foo1@a ........ (7 Replies)
Discussion started by: prashali
7 Replies

9. Shell Programming and Scripting

How to grep an empty line in a specific column of a file?

Suppose i have the following data : cat file.txt 12431,123334,55353,546646,14342234,4646,35234 123123,3535,123434,132535,1234134,13535,123534 123213,545465,23434,45646,2342345,4656,31243 2355425,2134324,53425,342,35235,23434,234535 3423424,234234,65465,,2344,35436,234524,234... (7 Replies)
Discussion started by: Ravi Tej
7 Replies

10. Shell Programming and Scripting

How to read particular line in file from specific column?

Hi...friends.... I want to create inventory...information for that I need to read some specific row say 2nd row from 1st 3 column and and write data with particular file used, I have some more column also but I need only 3 column data of first entry after header I attached sample file..those... (12 Replies)
Discussion started by: nex_asp
12 Replies
cdde.xml(5)															       cdde.xml(5)

NAME
cdde.xml - Configuration file for cdde DESCRIPTION
When cdde is run for the first time, an example xml configuration file (~/.cdde.xml) is created for you: <?xml version="1.0"?> <cdde delay="5000000"> <drive path="/dev/cdrom"> <audio command="echo An audio cd was inserted."/> <data command="echo A data cd was inserted."/> <dvd command="echo A dvd was inserted."/> <vcd command="echo A vcd was inserted."/> <svcd command="echo A svcd was inserted."/> <blank command="echo A blank cdr/dvdr was inserted."/> <mixed command="echo A mixed (audio/data) cd was inserted."/> </drive> </cdde> This default file is not very useful, and so I suggest you to edit it to your needs before running cdde again. You may add as many drive entries, or commands as you like. If multiple entries are found for a type of disc then all entries will be run in the order they are found. The specific device in use can be passed to the command with one of the following special tags: %dev% - is replaced with the device name of the cdrom that just had a disc inserted %mnt% - is replaced with the listed mount point for the cdrom that just had a disc inserted Note: %mnt% is determined through your fstab (usually located in /etc) file. If you do not have a listing for each <drive> in the fstab this will cause problems. This way, you can tell your video player which device to use when playing a VCD, for example. EXAMPLE
This is an example of ~/.cdde.xml file: <?xml version="1.0"?> <cdde delay="5000000"> <drive path="/dev/cdroms/cdrom0"/> <audio command="xmms %mnt%"/> <data command="mount %mnt%"/> <dvd command="xterm -iconic -e mplayer -fs -xineramascreen 1 -dvd 1"/> <vcd command="xterm -iconic -e mplayer -fs -xineramascreen 1 -vcd 1"/> <svcd command="xterm -iconic -e mplayer -fs -xineramascreen 1 -vcd 1"/> <blank command="gcombust"/> <mixed command="mount %mnt%"/> </drive> </cdde> FILES
~/.cdde.xml SEE ALSO
cdde(1) AUTHORS
Eric Lathrop <eric@ericlathrop.com> Stanislav Maslovski <stanislav.maslovski@gmail.com> WEBSITE
For the latest release of cdde, see: http://cdde.sourceforge.net/ Eric Lathrop 0.3.1 cdde.xml(5)
All times are GMT -4. The time now is 02:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy