sed data extract Post: 302729687

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed or awk to extract data from Xml file

Hi, I want to get data from Xml file by using sed or awk command. I want to get the following result : mon titre 1;Createur1;Dossier1 mon titre 1;Createur1;Dossier1 and save it in cvs file (fichier.cvs). FROM this Xml file (test.xml): <playlist version="1"> <trackList> <track>...

2. Shell Programming and Scripting

extract data from a data matrix with filter criteria

Here is what old matrix look like, IDs X1 X2 Y1 Y2 10914061 -0.364613333 -0.362922333 0.001691 -0.450094667 10855062 0.845956333 0.860396667 0.014440333 1.483899333...

3. Shell Programming and Scripting

how to extract the data ?

Hi, I'm trying to pick out a data field eg. from below. I need the required field as below but they are filled sometimes with weird chars like \-(. or watever. How can I accurately extract the 3rd field in shell? :confused: ID IDNO - REQUIRED FIELD ID 1447 - MAT620BR. ID 1452 -...

4. Shell Programming and Scripting

Extract data based on match against one column data from a long list data

My input file: data_5 Ali 422 2.00E-45 102/253 140/253 24 data_3 Abu 202 60.00E-45 12/23 140/23 28 data_1 Ahmad 256 7.00E-45 120/235 140/235 22 data_4 Aman 365 8.00E-45 15/65 140/65 20 data_10 Jones 869 9.00E-45 65/253 140/253 18...

5. Shell Programming and Scripting

Extract specific data content from a long list of data

My input: Data name: ABC001 Data length: 1000 Detail info Data Direction Start_time End_time Length 1 forward 10 100 90 1 forward 15 200 185 2 reverse 50 500 450 Data name: XFG110 Data length: 100 Detail info Data Direction Start_time End_time Length 1 forward 50 100 50 ...

6. Shell Programming and Scripting

SED to extract HTML text data, not quite right!

I am attempting to extract weather data from the following website, but for the Victoria area only: Text Forecasts - Environment Canada I use this: sed -n "/Greater Victoria./,/Fraser Valley./p" But that phrasing does not sometimes get it all and think perhaps the website has more...

7. Shell Programming and Scripting

Extract data b/w two words using sed

Hi, I want to extract data b/w two words with the help of sed.. Eg: In "Anna said that she would fetch the bucket", I want to display data b/w "Anna" and "would" O/P: said that she I have tried with below code, but unable to get desired o/p echo "Anna said that she would fetch the...

8. Shell Programming and Scripting

Router ping log extract data from it Awk/Sed/grep

Hi, I am new to this world.. Using expect i loging to router and checking ping response to my links. I need to genarate report using this output and that report contains only three file link name, packet loss, latency. my output of script is like below: -bash-3.00$ monmw/mwbkp...

9. Shell Programming and Scripting

sed or awk, cut, to extract specific data from line

Hi guys, I have been trying to do this, but... no luck so maybe you can help me. I have a line like this: Total Handled, Received, on queue Input Mgs: 140 / 14 => 0 I need to, get the number after the / until the =, to get only 14 . Any help is greatly appreciated. Thanks,

10. Shell Programming and Scripting

Extract header data from one file and combine it with data from another file

Hi, Great minds, I have some files, in fact header files, of CTD profiler, I tried a lot C programming, could not get output as I was expected, because my programming skills are very poor, finally, joined unix forum with the hope that, I may get what I want, from you people, Here I have attached...

LEARN ABOUT DEBIAN

cldump

cldump(1)							   User Manuals 							 cldump(1)

NAME

       cldump - Clarion database extractor

SYNOPSIS

       cldump [options] database.dat

DESCRIPTION

       cldump  extracts  the  data contained in a Clarion database; Clarion is a Windows IDE similar to Delphi or others, and has its own (simple)
       database format.

       cldump can extract the data contained in such a database, and export it to CSV, SQL (including the database schema, keys  and  indexes)	or
       its own format (this format will give you all the meta information, but isn't easily parsable).

       A Clarion database consists in a set of files :

       .DAT   files contain the data,

       .Kxx   files contain the key/index data,

       .MEM   files contain the memo entries associated to the data.

OPTIONS

       -x n, --decrypt n
	      Decrypt an encrypted file. Required argument n indicates the location where the key will be retrieved. Valid values are in the range
	      1 - 4 inclusive. n = 1 usually works.

	      Decryption happens in-place so KEEP A BACKUP as there is no guarantee the decryption process won't fail.	Encrypted  files  must	be
	      decrypted before they can be dumped.

	      Note  that  only the data file and the memo file are decrypted in this process; key/index files are left untouched as cldump doesn't
	      use them.

       -d, --dump-active
	      Dump active entries only

       -D, --dump-data
	      Dump the actual data (active and deleted entries)

       -m, --dump-meta
	      Dump meta information (no SQL or CSV output format exist for this option)

       -f c, --field-separator c
	      Set the field separator to character c. Only valid for CSV output (see below).

       -c, --csv
	      Dump data or schema in CSV format

       -S, --sql
	      Dump data or schema in SQL format

       -s, --schema
	      Dump database schema

       -M, --mysql
	      Use MySQL specific construct (backticks, ...)

       -n, --no-memo
	      Do not dump memo entries

       -U[charset], --utf8[=charset]
	      Transcode strings and memos from charset to UTF-8 (charset defaults to ISO8859-1; for the list  of  supported  charsets,	see  iconv
	      --list)

OUTPUT

       cldump  outputs	the  data to stdout or stderr depending on the output format selected, the data to extract and the type of the data (data,
       meta data).

BUGS

       The SQL output could be improved. Not all the types supported by the Clarion database format are implemented yet (due to lack of test data-
       bases using these types of data); see the source code for details.

       Please report bugs to jb@jblache.org; if possible, please send patches as the set of test databases I have is very limited.

AUTHOR

       cldump was written by Julien BLACHE <jb@jblache.org>.

HOMEPAGE

       http://www.technologeek.org/projects/cldump/

Linux								   November 2010							 cldump(1)