Sponsored Content
Top Forums Shell Programming and Scripting converting specific XML file to CSV Post 302474779 by Nicol on Thursday 25th of November 2010 10:51:55 AM
Old 11-25-2010
Hi,

all data in bold separated by #

like:
Code:
20101125T143946,91+01#20101125T145142,38+01#yes#never#

and so on

regards
Christian

Last edited by Scott; 11-26-2010 at 07:01 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting txt file in csv

HI All, I have a text file memory.txt which has following values. Average: 822387 7346605 89.93 288845 4176593 2044589 51883 2.47 7600 i want to convert this file in csv format and i am using following command to do it. sed s/_/\./g <... (3 Replies)
Discussion started by: mkashif
3 Replies

2. 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

3. Shell Programming and Scripting

Converting a flat file in XML

Hello Friends, I am new to UNIX shell scripting. Using bash....Could you please help me in converting a flat file into an XML style output file. Flat file: (Input File entries looks like this) John Miller: 617-569-7996:15 Bunting lane, staten Island, NY: 10/21/79: 60600 The... (4 Replies)
Discussion started by: humkhn
4 Replies

4. 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

5. Shell Programming and Scripting

Converting specific Excel file tabs to CSV in Python

Hi list, This is probably something really simple, but I am not particularly familiar with Python so I thought I would ask as I know that python has an excel module. I have an excel document with multiple tabs of data and graphs. One of the tabs is just data which I require to have dumped to... (8 Replies)
Discussion started by: landossa
8 Replies

6. Shell Programming and Scripting

need to save the space when converting to CSV file

Hi, I have a text file with the following format. Some of the fields are blank. 1234 3456 23 45464 327837283232 343434 5654353 34 34343 3434345 434242 .... .... .... I need to convert this file to a CSV file, like 1234, ,23, ... (3 Replies)
Discussion started by: wintersnow2011
3 Replies

7. Shell Programming and Scripting

Help with converting XML to Flat file

Hi Friends, I want to convert a XML file to flat file. Sample I/p: <?xml version='1.0' encoding='UTF-8' ?> <DataFile xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' contactCount='4999' date='2012-04-14' time='22:00:14' xsi:noNamespaceSchemaLocation='gen .xsd'> <Contact... (3 Replies)
Discussion started by: karumudi7
3 Replies

8. Shell Programming and Scripting

Converting rows to columns in csv file

Hi, I have a requirement to convert rows into columns. data looks like: c1,c2,c3,.. r1,r2,r3,.. p1,p2,p3,.. and so on.. output shud be like this: c1,r1,p1,.. c2,r2,p2,.. c3,r3,p3,.. Thanks in advance, (12 Replies)
Discussion started by: Divya1987
12 Replies

9. 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

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
term::ansi::code::attr(n)					 Terminal control					 term::ansi::code::attr(n)

__________________________________________________________________________________________________________________________________________________

NAME
term::ansi::code::attr - ANSI attribute sequences SYNOPSIS
package require Tcl 8.4 package require term::ansi::code ?0.1? package require term::ansi::code::attr ?0.1? ::term::ansi::code::attr::names ::term::ansi::code::attr::import ?ns? ?arg...? ::term::ansi::code::attr::fgblack ::term::ansi::code::attr::fgred ::term::ansi::code::attr::fggreen ::term::ansi::code::attr::fgyellow ::term::ansi::code::attr::fgblue ::term::ansi::code::attr::fgmagenta ::term::ansi::code::attr::fgcyan ::term::ansi::code::attr::fgwhite ::term::ansi::code::attr::fgdefault ::term::ansi::code::attr::bgblack ::term::ansi::code::attr::bgred ::term::ansi::code::attr::bggreen ::term::ansi::code::attr::bgyellow ::term::ansi::code::attr::bgblue ::term::ansi::code::attr::bgmagenta ::term::ansi::code::attr::bgcyan ::term::ansi::code::attr::bgwhite ::term::ansi::code::attr::bgdefault ::term::ansi::code::attr::bold ::term::ansi::code::attr::dim ::term::ansi::code::attr::italic ::term::ansi::code::attr::underline ::term::ansi::code::attr::blink ::term::ansi::code::attr::revers ::term::ansi::code::attr::hidden ::term::ansi::code::attr::strike ::term::ansi::code::attr::nobold ::term::ansi::code::attr::noitalic ::term::ansi::code::attr::nounderline ::term::ansi::code::attr::noblink ::term::ansi::code::attr::norevers ::term::ansi::code::attr::nohidden ::term::ansi::code::attr::nostrike ::term::ansi::code::attr::reset _________________________________________________________________ DESCRIPTION
This package provides symbolic names for the ANSI attribute control codes. For each control code a single command is provided which returns this code as its result. None of the commands of this package write to a channel; that is handled by higher level packages, like term::ansi::send. API
INTROSPECTION ::term::ansi::code::attr::names This command is for introspection. It returns as its result a list containing the names of all attribute commands. ::term::ansi::code::attr::import ?ns? ?arg...? This command imports some or all attribute commands into the namespace ns. This is by default the namespace attr. Note that this is relative namespace name, placing the imported command into a child of the current namespace. By default all commands are imported, this can howver be restricted by listing the names of the wanted commands after the namespace argument. ATTRIBUTES ::term::ansi::code::attr::fgblack Set text color to Black. ::term::ansi::code::attr::fgred Set text color to Red. ::term::ansi::code::attr::fggreen Set text color to Green. ::term::ansi::code::attr::fgyellow Set text color to Yellow. ::term::ansi::code::attr::fgblue Set text color to Blue. ::term::ansi::code::attr::fgmagenta Set text color to Magenta. ::term::ansi::code::attr::fgcyan Set text color to Cyan. ::term::ansi::code::attr::fgwhite Set text color to White. ::term::ansi::code::attr::fgdefault Set default text color (Black). ::term::ansi::code::attr::bgblack Set background to Black. ::term::ansi::code::attr::bgred Set background to Red. ::term::ansi::code::attr::bggreen Set background to Green. ::term::ansi::code::attr::bgyellow Set background to Yellow. ::term::ansi::code::attr::bgblue Set background to Blue. ::term::ansi::code::attr::bgmagenta Set background to Magenta. ::term::ansi::code::attr::bgcyan Set background to Cyan. ::term::ansi::code::attr::bgwhite Set background to White. ::term::ansi::code::attr::bgdefault Set default background (Transparent). ::term::ansi::code::attr::bold Bold on. ::term::ansi::code::attr::dim Dim on. ::term::ansi::code::attr::italic Italics on. ::term::ansi::code::attr::underline Underscore on. ::term::ansi::code::attr::blink Blink on. ::term::ansi::code::attr::revers Reverse on. ::term::ansi::code::attr::hidden Hidden on. ::term::ansi::code::attr::strike Strike-through on. ::term::ansi::code::attr::nobold Bold off. ::term::ansi::code::attr::noitalic Italics off. ::term::ansi::code::attr::nounderline Underscore off. ::term::ansi::code::attr::noblink Blink off. ::term::ansi::code::attr::norevers Reverse off. ::term::ansi::code::attr::nohidden Hidden off. ::term::ansi::code::attr::nostrike Strike-through off. ::term::ansi::code::attr::reset Reset all attributes to their default values. BUGS, IDEAS, FEEDBACK This document, and the package it describes, will undoubtedly contain bugs and other problems. Please report such in the category term of the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883]. Please also report any ideas for enhancements you may have for either package and/or documentation. KEYWORDS
ansi, attribute control, color control, control, terminal CATEGORY
Terminal control COPYRIGHT
Copyright (c) 2006 Andreas Kupries <andreas_kupries@users.sourceforge.net> term 0.1 term::ansi::code::attr(n)
All times are GMT -4. The time now is 02:08 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy