Sponsored Content
Full Discussion: Xml to csv
Special Forums UNIX and Linux Applications Xml to csv Post 302993818 by RudiC on Tuesday 14th of March 2017 04:45:30 PM
Old 03-14-2017
Try (unsuppressed):
Code:
awk '/a001|b203|j151/ {L=/a001/; gsub (/ *<[^>]*> */, _); printf "%s%s", L?TRS:"\t", $0; TRS=ORS} END {printf RS}' file
9781328740472    Peepers    7.99    10.99

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help to convert XML to CSV

Apologies if this has already been covered in this site somewhere, I did try looking but without any success. I am new to the whole XML thing, very late starter, and have a requirement to convert an XML fiule to a CSV fomat. I am crrently working on a Solaris OS. Does anyone have any suggestions,... (2 Replies)
Discussion started by: rossingi_33
2 Replies

2. Shell Programming and Scripting

CSV to XML

Iam pretty new to UNIX and would like to convert a CSV to an XML file using AWK scripts. Can anybody suggest a solution? My CSV file looks something like this : Serial No Growth% Annual % Commission % Unemployed % 1 35% 29% 59% 42% 2 61% ... (15 Replies)
Discussion started by: pjanakir
15 Replies

3. Shell Programming and Scripting

CSV processing to XML

Hi, i am really fresh with shell scripting and programming, i have an issue i am not able to solve to populate data on my server for Cisco IP phones. I have CSV file within the following format: ;;;;;;;;;;;;;;;;;; ;;;;;;;;;;;;;;;;;; ;;;;;;;;;;;;;;;;;; ;;;;;;;;;;;;;;;;;; ;;;;;;;;;;;;;;;;;;... (9 Replies)
Discussion started by: angel2008
9 Replies

4. Shell Programming and Scripting

XML to csv transformation

Hi, I want to write a perl script. Which should accept the xml file, one xsl file and the loaction. The perl script should process the xml file using the xsl file and puts the out put in specified location. For example: My.perl is perls cript. my.xml is like this <?xml version="1.0"... (2 Replies)
Discussion started by: siba.s.nayak
2 Replies

5. Shell Programming and Scripting

XML to CSV specific

Hi , Please any one to help on ,extract this xml code into csv columns list. <SOURCEFIELD BUSINESSNAME ="" DATATYPE ="date" DESCRIPTION ="" FIELDNUMBER ="1" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="19" LEVEL ="0" NAME ="BUSINESS_DATE"... (4 Replies)
Discussion started by: mohan705
4 Replies

6. Shell Programming and Scripting

Convert xml to csv

I need to convert below xml code to csv. I searched other posts as well but this post (_https://www.unix.com/shell-programming-scripting/174417-extract-parse-xml-data-statistic-value-csv.html) gives "sed command garbled" error. As of now I have written a long script to do it, but can it be done with... (7 Replies)
Discussion started by: dineshydv
7 Replies

7. Shell Programming and Scripting

How to convert xml to csv ?

I am in need of converting billions of XML into csv file to load data to DB, i have found the below code in perl but not sure why it's not working properly. CODE: #!/usr/bin/perl # Script to illustrate how to parse a simple XML file # and pick out all the values for a specific element, in... (1 Reply)
Discussion started by: rspwilliam
1 Replies

8. Shell Programming and Scripting

XML to CSV

I want to pharse below Xml Using Shell Scripting . Thanks in Advance <md> <neid> <neun>1523</neun> <nedn>XXX1212</nedn> <nesw>fffff12515</nesw> </neid> <mi> <mts>20141128001500</mts> <gp>550</gp> <mt>pmct1</mt> <mt>pmNo2</mt> <mt>pmNo3S</mt> <mv> <moid>Ma=1,Rn=1,Ul=311C</moid>... (6 Replies)
Discussion started by: pareshkp
6 Replies

9. UNIX for Beginners Questions & Answers

Xml to csv (again)

Hello, I have copied .xml code for a single item below. I am trying to extract three items (field indices*b244 (second occurrence), b203, and j151), so the desired output would be: 9780323013543 Manual of Natural Veterinary Medicine: Science and Tradition, 1e 68.95 A parallel solution,... (14 Replies)
Discussion started by: palex
14 Replies

10. Shell Programming and Scripting

Converting XML to CSV

Hello, For i while i have been using XMLStarlet to convert several XML files to CSV files. So far this always went fine. Today however i got a new XML format however but i cannot find out how to get the data i need. Below is part of the code where it shows the different format. What... (10 Replies)
Discussion started by: SDohmen
10 Replies
cassette(1)						      General Commands Manual						       cassette(1)

Name
       cassette - data cassette image manipulator for xtrs TRS-80 emulator

Syntax
       cassette

Description
       To control the emulated cassette used by xtrs, a file called ".cassette.ctl" in the current directory keeps track of what file is currently
       "loaded" as the cassette tape and the current position within that file. The cassette shell script provides a way to manipulate this  file;
       typing  "help" at its prompt shows its commands. You may use this script to load and position cassette tape files. The operation works very
       much like an actual tape recorder.

       This manual page also describes the image formats that the emulator supports and their limitations.

Commands
       pos generates a status message including the filename being used as the cassette image and the current position within the image, in bytes.

       load [filename] changes the cassette image currently being used to the file specified, and resets the position counter to zero.

       type typename tells the emulator what type of image is loaded.  Usually this is detected from the file extension, but you can override  the
       detected value with this command.  The supported types are listed in the next section.

       rew [position] changes the position counter to the position specified.  If no position is given, the counter is reset to zero.

       ff [position] changes the position counter to the position specified.  If no position is given, the counter is set to the end of the file.

       quit exits the cassette shell script.

Types
       xtrs supports several different types of cassette images, each of which represents cassette data in a different format.

       cas  format  is	fairly	compact  and is compatible with other TRS-80 emulators that have cassette support.  This format represents the bit
       stream that (the emulator thinks) the TRS-80 cassette routines were trying to save to the tape, not the actual electrical  signals  on  the
       tape.

       On  writing,  the  emulator  monitors the values that the TRS-80 software is sending to the cassette port and their timing, auto-recognizes
       whether a 250-bps, 500-bps, or 1500-bps format is being written, decodes the signals into a string of 0 and 1 bits,  packs  the	bits  into
       bytes,  and writes them to the cas file.  On reading, the emulator auto-detects whether software is trying to read at 250, 500, or 1500 bps
       and encodes the 0's and 1's back into the signals that the TRS-80 software is expecting.  This somewhat roundabout method should work  with
       most  TRS-80  cassette routines that read and write signals compatible with the ROM cassette routines, but it may fail with custom routines
       that are too different.

       Note that generally nothing useful will happen if you try to write a cas image at one speed and read it at another.  There are  differences
       in the actual bit streams that standard TRS-80 software records at each of the three different speeds, not just differences in encoding the
       electrical signals on the tape.	Thus an incoming bit stream that was originally recorded at one speed will not	be  understood	when  read
       back  in  at a different speed.	For example, Level 2 Basic programs are tokenized, while Level 1 Basic programs are not, and the two Basic
       implementations record different binary information at the start of the program and between lines.  Also, when a file is saved at 1500 bps,
       standard TRS-80 software puts an extra 0 bit after every 8 data bits, and these extra bits are packed into the cas file along with the data
       bits.

       cpt format (for "cassette pulse train") encodes the exact values and timing of the signals that the TRS-80 cassette routine  sends  to  the
       cassette  output  port  to be recorded on the tape.  Timing is to the nearest microsecond.  This format emulates a perfect, noise-free cas-
       sette, so any cassette routines that even halfway worked on real hardware should work with it.

       wav format is a standard sound file format.  The wav format is intermediate in emulation accuracy between cas and cpt.  It  does  represent
       actual  signals,  not  decoded  bits,  but  its timing precision is limited by the sample rate used.  The default rate for new wav files is
       44,100 Hz; you can change this with the -samplerate command line option to xtrs.

       You can play wav files written by xtrs through your sound card and hear roughly what a real TRS-80 cassette sounds  like.   A  real  TRS-80
       should  be able to read wav files written by xtrs if you copy them to a cassette or connect the TRS-80 directly to the sound card's output.
       This feature has not been tested extensively, but it does seem to work, at least for short programs.

       xtrs can also read wav files.  It can read back the wav files that it writes without error.  Reading wav files sampled from real  cassettes
       is  more  difficult  because of the noise introduced, but in brief testing it does seem to work.  The signal processing algorithms used are
       very crude, and better ones could probably do a better job of reading old, noisy cassettes, but I don't have any  such  cassettes  to  test
       with (and I don't know much about signal processing!).  Help in this area would be welcome.

       The  wav  file  parsing code has several limitations.  Samples must be 8-bit mono, and the wav file must contain only one data chunk and no
       extra optional RIFF chunks in the header.  If you have a wav file whose header xtrs rejects, try using sox(1)  to  convert  it  to  a  more
       vanilla format.

       direct format is similar to wav format, except that the samples go to (or come from) your sound card directly, not a wav file.  Direct for-
       mat requires the Open Sound System /dev/dsp device.  Extending the code to work with other sound interfaces would probably not be hard, but
       is left as an exercise for the reader.  Please send me the changes if you do this.

       debug  format  is  the  same as cpt format except that the data is written in human-readable ASCII.  The cassette output is assumed to be 0
       initially.  Each line of output gives a new value (0, 1, or 2), and the amount of time (in microseconds) to wait before changing the output
       to this value.

Authors
       xtrs  1.0 was written by David Gingold and Alec Wolman.	The current version was revised and much extended by Timothy Mann (see http://tim-
       mann.org/).  An initial version of this man page, and the translation from C-shell (cassette) to Bourne shell  (cassette.sh),  are  due	to
       Branden Robinson.

																       cassette(1)
All times are GMT -4. The time now is 09:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy