Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Extracting data from tables and storing in a file
Special Forums UNIX Desktop Questions & Answers Extracting data from tables and storing in a file Post 302427932 by gini32 on Tuesday 8th of June 2010 10:15:00 AM
Old 06-08-2010
strange...!!!
the usage of sed posted above, is well tested one....

---------- Post updated at 07:45 PM ---------- Previous update was at 07:41 PM ----------

try sed with single quotes

sed -e 's/ //g' tmpFile | grep -v '^$' | grep -v "\-\-" > outfile.csv
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting tables of row data into columns of tables

I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated. Input: test_data_1 1 2 90% 4 3 91% 5 4 90% 6 5 90% 9 6 90% test_data_2 3 5 92% 5 4 92% 7 3 93% 9 2 92% 1 1 92% ... Output:... (7 Replies)
Discussion started by: justthisguy
7 Replies

2. UNIX for Dummies Questions & Answers

Extracting Data from a File

Hi I need to calculate the number of occurrences of a item in a number of files using Perl. The item appears continually throughout the files but in each case I only want to calculate it in certain blocks of the file. Example - Calculalte the number of occurrences of a 'pass' in a block of... (0 Replies)
Discussion started by: oop
0 Replies

3. Shell Programming and Scripting

Extracting particular string in a file and storing matched string in output file

Hi , I have input file and i want to extract below strings <msisdn xmlns="">0492001956</ msisdn> => numaber inside brackets <resCode>3000</resCode> => 3000 needs to be extracted <resMessage>Request time getBalances_PSM.c(37): d out</resMessage></ns2:getBalancesResponse> => the word... (14 Replies)
Discussion started by: sushmab82
14 Replies

4. UNIX for Dummies Questions & Answers

Storing data from a table into a csv file

Hi I need to write a bash script to take the data stored in 3 oracle tables .. and filter them and store the results in a csv file. It is an Oracle database Thank you (1 Reply)
Discussion started by: ladyAnne
1 Replies

5. Shell Programming and Scripting

Extracting data from tables......

HOw to extracts data from tables in database. Merges them into one output file. This output file is loaded into another tables in database. (1 Reply)
Discussion started by: nari.bommi
1 Replies

6. Shell Programming and Scripting

Extracting columns from a matrix and storing each column in a separate file

Hi All, I have a huge matrix file consisting some some millions rows and 6000 columns. The contents are just floating point numbers in the matrix. I want to extract each column (i.e. 6000 of them) and store each column in a separate file. For example, 1.dat will consist of elements from column... (4 Replies)
Discussion started by: shoaibjameel123
4 Replies

7. Shell Programming and Scripting

Extracting specific lines of data from a file and related lines of data based on a grep value range?

Hi, I have one file, say file 1, that has data like below where 19900107 is the date, 19900107 12 144 129 0.7380047 19900108 12 168 129 0.3149017 19900109 12 192 129 3.2766666E-02 ... (3 Replies)
Discussion started by: Wynner
3 Replies

8. UNIX for Dummies Questions & Answers

Extracting data from file

I am trying to compare the data in lines 3 & 5 to see if they match up to the '-S570' (see first code set, all proprietary information has been removed from code set) spawn telnet Trying ... Connected to CA-LOS1234-ASE-S570.cl . Escape character is '^]'. CA-LOS1234-ASE-S570 Username: ... (1 Reply)
Discussion started by: slipshft
1 Replies

9. Shell Programming and Scripting

Extracting characters and storing in some variable

eg: ./myProgram.sh filename.cpp I want to remove the :".cpp" extension from the filename.cpp expected output: filename (3 Replies)
Discussion started by: umesh314
3 Replies

10. UNIX for Beginners Questions & Answers

Using bash script : How to Import data from a dsv file into multiple tables in mysql

HI I have a dsv file that looks like: <<BOF>> record_number|id_number|first name|last name|msisdn|network|points|card number|gender 312|9101011234011|Test Junior|Smith|071 123 4321|MTN|73|1241551413214444|M 313|9012023213011|Bob|Smith|27743334321|Vodacom|3|1231233232323244|M... (4 Replies)
Discussion started by: tera
4 Replies

LEARN ABOUT OPENSOLARIS

update-desktop-database

update-desktop-database(1)					   User Commands					update-desktop-database(1)

NAME

       update-desktop-database - Desktop file caching utility

SYNOPSIS

       update-desktop-database [--help] [--verbose] [--quiet] [filepath]

DESCRIPTION

       update-desktop-database creates cache files for desktop file MIME type mapping for improved MIME lookup performance.

       It  expects  to	be  given  the	path  to  a  directory	or  directories  containing a number of application installed .desktop files, e.g.
       /usr/share/applications, and writes a mime-info.cache containing cached information about the MIME types that each application can  handle.
       If  no directory is provided, this utility will use a default directory list as specified in the FreeDesktop MIME specification. This cache
       file is used to avoid a lot of system call and disk seek overhead in a number of applications.

OPTIONS

       The following options are supported:

       -?, --help		       Show help options.

       -v, --verbose		       Turn on verbose output.

       -q, --quiet		       Do not provide any output.

OPERANDS

       The following operands are supported:

       filepath 	       The path to a directory or directories containing a number of application installed .desktop files.

EXIT STATUS

       The following exit values are returned:

       0	Application exited successfully

       1	Application exited with failure

FILES

       The following files are used by this application:

       /usr/bin/update-desktop-databaseThe command-line executable for the application.

       /usr/share/applications	       System desktop file directory

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWgnome-desktop-prefs	   |
       +-----------------------------+-----------------------------+
       |Interface stability	     |Committed 		   |
       +-----------------------------+-----------------------------+

SEE ALSO

       update-mime-database(1), gnome-desktop-item-edit(1), attributes(5), gnome-interfaces(5)

       Latest version of the GNOME Desktop User Guide and GNOME System Administration Guide for your platform.

NOTES

       Written by Glynn Foster, Sun Microsystems Inc., 2007.

SunOS 5.11							    31 Jan 2007 					update-desktop-database(1)
All times are GMT -4. The time now is 07:53 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy