Sponsored Content
Top Forums Shell Programming and Scripting data extraction from xml file Post 302448506 by rdcwayx on Thursday 26th of August 2010 07:50:28 AM
Old 08-26-2010
Code:
awk '
BEGIN{print "depth\ttemp\tsalinity"}
/<Depth/ {split($2,a,"\"");depth=a[2]}
/<Temperature/ {getline;temp=$1} 
/<Salinity/ {getline;salinity=$1;printf "%d\t%d\t%d\n",depth,temp,salinity}
' lat_060_lon_003.xml

depth   temp    salinity
0       2183    3577
10      2155    3576
20      2132    3575
30      2103    3574
50      1942    3574
75      1755    3567
100     1671    3561
125     1622    3558
150     1584    3555
200     1478    3543
250     1373    3530
300     1288    3520
400     1109    3498
500     920     3475
600     735     3457
700     576     3443
800     491     3435
900     425     3435
1000    384     3438
1100    350     3444
1200    322     3450
1300    311     3457
1400    303     3462
1500    301     3467

This User Gave Thanks to rdcwayx For This Post:
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

extraction of data from a text file which follows certain pattern

hi everybody, i have a file, in it I need to extract some data that follows a particular pattern.. For example: my file contains like now running Speak225 sep 22 mon 16:34:05 2008 -------------------------------- ... (4 Replies)
Discussion started by: mohkris
4 Replies

2. Shell Programming and Scripting

Data Extraction From a File

Hi All, I have a requirement where I have to search the file with some text say "Exception". This exception word can be repeated for more then 10 times. Suppose the "Exception" word is repeated at line numbers say x=10, 50, 60, 120. Now I want to extract all the lines starting from x-5 to... (3 Replies)
Discussion started by: rrangaraju
3 Replies

3. Shell Programming and Scripting

Help needed XML Field Extraction

I had an immediate work to sort out the error code and error message which are associated within the log. But here im facing an problem to extract 3 different fields from the XML log can some one please help. I tried using different script including awk & nawk, but not getting the desired output. ... (18 Replies)
Discussion started by: raghunsi
18 Replies

4. Shell Programming and Scripting

data extraction from a file

Hi Freinds, I have a file1.txt in the following format File1.txt I want to get 2 files from the above file filextra.txt should have the lines which are ending with "<" and remaining lines in the filecompare.txt file. Please help. (3 Replies)
Discussion started by: i150371485
3 Replies

5. Shell Programming and Scripting

Data extraction from .txt file

Hey all, i´ve got the following problem: i´m aquiring data with an instrument and i get data in a .txt file. This is how the txt file looks like: Report of AU program poptau F1P=-49.986ppm F2P=-110.014ppm Target directory for serfile: D:/data/Spect500/nmr/Thoma/882 Linear... (17 Replies)
Discussion started by: expikx
17 Replies

6. Shell Programming and Scripting

CSV file data extraction

Hi I am writing a shell script to parse a CSV file , in which i am facing a problem to separate the columns . Could some one help me with it. IN301330/00001 pvavan kumar limited xyz@ttccpp.com IN302148/00002 PRECIOUS SECURITIES (P) LTD viash@yahoo.co.in IN300239/00000 CENTRE india... (8 Replies)
Discussion started by: nanduri
8 Replies

7. Shell Programming and Scripting

Data extraction from .xml file

Hello, I'm attempting to extract 13 digit numbers beginning with 978 from a data file with the following command: awk '{ for(i=1;i<=NF;i++) if($i ~ /^978/) print $i; }' datafile > outfile This typically works. However, the new data file is an .xml file, and this command is no longer working... (6 Replies)
Discussion started by: palex
6 Replies

8. Shell Programming and Scripting

Help with XML tag value extraction based on condition

sample xml file part <?xml version="1.0" encoding="UTF-8"?><ContractWorkspace xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" _LoadId="export_AJ6iAFmh+pQHq1" xsi:noNamespaceSchemaLocation="ContractWorkspace.xsd"> <_LocalId>CW2218471</_LocalId> <Active>true</Active> ... (3 Replies)
Discussion started by: paul1234
3 Replies

9. Shell Programming and Scripting

Help with tag value extraction from xml file based on a matching condition

Hi , I have a situation where I need to search an xml file for the presence of a tag <FollowOnFrom> and also , presence of partial part of the following tag <ContractRequest _LoadId and if these 2 exist ,then extract the value from the following tag <_LocalId> which is "CW2094139". There... (2 Replies)
Discussion started by: paul1234
2 Replies

10. UNIX for Beginners Questions & Answers

Data extraction and converting into .csv file.

Hi All, I have a data file and need to extract and convert it into csv format: 1) Read and extract the line containing string ending with "----" (file sample_linebyline.txt file) and to make a .csv file from this. 2) To read the flat file flatfile_sample.txt which consists of similar data (... (9 Replies)
Discussion started by: abhi_123
9 Replies
SPLASHY_UPDATE(1)					 Splashy POSIX boot splash system					 SPLASHY_UPDATE(1)

NAME
Splashy - a user-mode, POSIX and LSB compliant, boot splashing system for UNIX. SYNOPSIS
splashy_update "<text>" DESCRIPTION
Splashy displays an image and a progress bar at boot time. splashy_update is used to send commands to the running Splashy daemon. See "COMMANDS" below to know which commands Splashy understands. OPTIONS
text Sends text to Splashy socket. COMMANDS
chroot <string> <string> is a valid path to which Splashy will be chroot'd. chvt <number> Switch to vt <number>. clear Clears the text box area. CLEAR Same as "clrprint". For compatibility with usplash. exit Exits Splashy server. getstring <string> Makes splashy prompt for a string. The first argument will be the prompt displayed. getpass <string> Same as getstring except that the characters typed will no be shown, like in a password box. progress <number> Updates the progress bar to <number>%, where N is a number between 0 and 100. PROGRESS <number> Same as "progress". For compatibility with usplash. print <string> Print <string> in the text box. scroll <string> Print <string> in the text box and scroll down. repaint Redraw the background image. TEXT <string> Same as "print". For compatibility with usplash. SCROLL <string> Same as "scroll". timeout <number> Sets the amount of seconds splashy waits for new commands. If that time is exceeded, it exits. QUIT Same as "exit". For compatibility with usplash. RETURN CODES
1 cannot open the socket 2 cannot write to socket 3 invalid args 255 /etc/splashy does not exist FILES
/etc/splashy/config.xml Main configuration. defines how splashy should be setup. SEE ALSO
splashy(1), splashy_config(1), splashy-config.xml(5), splashy-theme.xml(5) AUTHORS
Andrew Williams <mistik1@geeksinthehood.net> Luis Mondesi <lemsx1@gmail.com> perl v5.12.1 2010-07-05 SPLASHY_UPDATE(1)
All times are GMT -4. The time now is 01:03 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy