change the output format Post: 302419482

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

change the empty function from the old format to the new format

I have about 300 files which has the function getDBBackend(). How to write a program to change the empty function from the old format to the new format? Old empty function format are either: function getDBBackend() { // Not available } // getDBBackend or: function...

2. Shell Programming and Scripting

capturing output from top and format output

Hi all, I'd like to capture the output from the 'top' command to monitor my CPU and Mem utilisation.Currently my command isecho date `top -b -n1 | grep -e Cpu -e Mem` I get the output in 3 separate lines.Tue Feb 24 15:00:03 Cpu(s): 3.4% us, 8.5% sy .. .. Mem: 1011480k total, 226928k used, .......

3. Shell Programming and Scripting

Change file output format

I have a file which has following contents usmtnz-dinfsi19 62 61 18400 18800 99.7 usmtnz-dinfsi19 62 61 18400 18800 99.7 i want the o/p to be like date

4. Shell Programming and Scripting

How can I change is output format by awk ?

Hello, Can you tell me how can I change this format by awk Input 0.2057422D-01 0.2463722D-01 -0.1068047D-02 Output 0.02057422 0.02463722 -0.001068047 Thanks wan

5. Shell Programming and Scripting

format change

I have a text file sample.txt which contains some details like Order 9001 Item Code 34 Quantity 4 Entry Date 2009-04-23 Ordered by Ram Order 9002 Item Code 34 Quantity 3

6. Shell Programming and Scripting

change output format using ksh

I have a script that reaches out to several systems and pulls back infomation in serveral files. I would like to take the infomation returned and reformat it so I can export it to excel. Below is current output: File1:item1:abc=1 File1:item2:efg File2:item1:ab=1 File2:item2:efg...

7. AIX

How change format of storage

First padd the string with spaces and then store in file (e.g result) with"" Example: i/p: name="abc" echo "$name">>result Blank space..=12 Required o/p of Result file: "abc " # "Value 12 blank space" How to perform using scripting??:confused: Please use code tags,...

8. Shell Programming and Scripting

Format change

I wish to convert the following in shell. Help me SED or AWK ID= 12345,23456,67859 , 90225 , 67583 I can extract the right hand side of "=" using cut command "cut -d "=" -f2 after extracting that right side i would need like this '12345','23456','67859','90225','67583' 1 ) the...

9. Shell Programming and Scripting

Change name format

I am trying to use either awk or sed to make names like J. A. Smith and J.A. Martin Smith become JA Smith and JA Martin SmithThe code should concatenate abbreviated letters that have a dot after them. I have only been able to do this: echo $name | sed 's/\.\ //g'But that concatenates the...

10. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM...

LEARN ABOUT DEBIAN

mdb-tables

MDBTools(1)															       MDBTools(1)

NAME

       mdb-tables - Get listing of tables in an MDB database

SYNOPSIS

       mdb-tables [-S] [-1 | -d delimiter] database

DESCRIPTION

       mdb-tables is a utility program distributed with MDB Tools.

       It produces a list of tables contained within an MDB database in a format suitable for use in shell scripts.

OPTIONS

       -S     Show system tables. System tables are generally those beginning with 'MSys'

       -1     specifies that the tables should be listed 1 per line.

       -d delimiter
	      specifies an alternative delimiter. If no delimiter is specified, table names will be delimited by a tab character, or by newline if
	      the -1 option was specified.

NOTES

ENVIRONMENT

       MDB_JET3_CHARSET
	      Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1).

       MDBICONV
	      Defines the output charset. Default is UTF-8. mdbtools must have been compiled with iconv.

       MDBOPTS
	      semi-column separated list of options:

	      o  use_index

	      o  no_memo

	      o  debug_like

	      o  debug_write

	      o  debug_usage

	      o  debug_ole

	      o  debug_row

	      o  debug_props

	      o  debug_all is a shortcut for all debug_* options

HISTORY

       mdb-tables first appeared in MDB Tools 0.3.

SEE ALSO

       gmdb2(1) mdb-export(1) mdb-hexdump(1) mdb-prop(1) mdb-sql(1) mdb-ver(1) mdb-array(1) mdb-header(1) mdb-parsecsv(1) mdb-schema(1)

AUTHORS

       The mdb-tables utility was written by Brian Bruns.

BUGS

       Access allows for tables to have spaces embeded in the table name.
	      You must specify a delimiter (-d) if you intend on piping the output of mdb-tables to a program such as awk or cut.

0.7								   13 July 2013 						       MDBTools(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

change the empty function from the old format to the new format

Discussion started by: powah

2. Shell Programming and Scripting

capturing output from top and format output

Discussion started by: new2ss

3. Shell Programming and Scripting

Change file output format

Discussion started by: fugitive

4. Shell Programming and Scripting

How can I change is output format by awk ?

Discussion started by: wanchem