Script for data formatting Post: 302279545

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Formatting Data

i am writing a script that reads in a file and i just want it to print each element on a new line here is my code and the data that i want to read in #!/usr/bin/perl use strict; use CGI qw(:standard); use CGI qw(:cgi); my $data_file = "/tmp/results.txt"; my $configuration; my...

2. Shell Programming and Scripting

Re-formatting of data display

Hi All, I have been trying to re-arrange the below data using AWK or Perl. Can anybody help me ? Thanks in advance. Input: 111 222 333 444 AAA BBB CCC DDD 555 666 777 888 EEE FFF GGG HHH Output:

3. Shell Programming and Scripting

Formatting Data - CSV

I want to check whether if any column data has any + , - , = prefixed to it then convert it in such a form that in excel its not read as formula. echo "$DATA" | awk 'BEGIN { OFS="," } -F" " {print $1,$2,$3,$4,$5,$6,$7,$8.$9,$10,$11,$12}'

4. Shell Programming and Scripting

Formatting input data

Hello everybody, I have a file containing some statistics regarding CPU usage. The file has this syntax : Fri Jul 16 14:27:16 EEST 2010 Cpu(s): 15.2%us, 1.4%sy, 0.0%ni, 82.3%id, 0.1%wa, 0.0%hi, 0.9%si, 0.0%st Fri Jul 16 15:02:17 EEST 2010 Cpu(s): 15.3%us, 1.4%sy, 0.0%ni, 82.3%id, ...

5. Shell Programming and Scripting

help with data formatting

Hi, I have data coming in like below. Not all data is like that, these are the problem records that is causing the ETL load to fail. Can you pls help me with combining theese broken records! 001800018000000guyMMAAY~acct name~acct type~~"address part 1 address...

6. UNIX for Advanced & Expert Users

formatting the data

HI I want to make it single row if start with braces i.e. { .Any idea {1:XXX2460275191}{2:SEC00687921131112201641N}{3:{58910}}{4: :R:GENL :C::xx//xx1 :20C::yy//yy1 :2S:xxT} {1:XXX2460275190}{2:SEC00687921131112201641y}{3:{58911}}{4: :z:GENL :v::xx//xx1 :10C::yy//yy1 :4S:xxT ...

7. Shell Programming and Scripting

AWK/Shell script for formatting data in a file

Hi All, Need an urgent help to convert a unix file in to a particular format: **source file:** 1111111 2d2f2h2 3dfgsd3 ........... 1111111 <-- repeats in every nth line. remaining all lines will be different 123ss41 432ff45 ........... 1111111 <-- repetition qwe1234 123weq3...

8. Shell Programming and Scripting

Help with data formatting

Hi, I am generating the following output from my script. Country,A,B,C,D,E,F INDIA ,3755019,774604,484749,329838,7333612,442031 CHINA ,3716520,889197,530899,379754,6198475,355768 JAPAN ,52038,30462,231224,147275,1272,498 USA,9494,1130,0,0,15303,451...

9. Shell Programming and Scripting

Data formatting using awk

Need assistance on the data extraction using awk Below is the format and would like to extract the data in another format ------------------------------------------------------------------------------------------------- Minimum Temperature (deg F ) DAY 1 2 3 4 5 6 7 8 9 10 11...

LEARN ABOUT DEBIAN

runxlrd

RUNXLRD(1)						      General Commands Manual							RUNXLRD(1)

NAME

       runxlrd - extract data from Microsoft Excel spreadsheet files

SYNOPSIS

       runxlrd [options] command [input-file-patterns]

DESCRIPTION

       This manual page documents briefly the runxlrd command.

       runxlrd offers a commandline interface to the Python xlrd module; it extracts data from Microsoft Excel spreadsheet files.

OPTIONS

       -h, --help
	      Show summary of options and exit.

       -l logfilename
	      Contains error messages.

       -v verbosity, --verbosity=verbosity
	      Level of information and diagnostics provided.

       -p pickleable, --pickleable=pickleable
	      1: ensure Book object is pickleable (default); 0: don't bother.

       -m mmap, --mmap=mmap
	      1: use mmap; 0: don't use mmap; -1: accept heuristic.

       -e encoding, --encoding=encoding
	      Encoding override.

       -f formatting, --formatting=formatting
	      0 (default): no fmt info 1: fmt info (all cells) 2: fmt info (margins trimmed).

       -g gc, --gc=gc
	      0: auto gc enabled; 1: auto gc disabled, manual collect after each file; 2: no gc.

       -s onesheet, --onesheet=onesheet
	      Restrict output to this sheet (name or index).

COMMANDS

       Valid commands are

       o dump

       o count_records

       o version

       o hdr

       o ov

       o show

       o 2rows

       o 3rows

       o bench

       o names

       o name_dump

       o labels

       o xfc

       o hotshot

       o profile

       See the xlrd API documentation for the meaning of these commands.

EXAMPLES

       To show the first, second and last rows of each sheet in each file, run
	      $ runxlrd 3rows *blah*.xls
       Run
	      $ runxlrd -e koi8_r 3rows myfile.xls
       to explicitly pass the needed codepage to xlrd, e.g. if the codepage record is missing, or if it exists but is wrong.

SEE ALSO

       The xlrd API documentation, shipped in the file xlrd.html.
       The xlrd website <http://www.lexicon.net/sjmachin/xlrd.htm>.

AUTHOR

       runxlrd was written by John Machin.

       This manual page was written by Joost van Baal <joostvb+debian@uvt.nl>, for the Debian project (but may be used by others).

xlrd 0.6.1a4							    2007-05-24								RUNXLRD(1)