Script for data formatting Post: 302279360

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 SUSE

ssgrep

SSGREP(1)							       GNOME								 SSGREP(1)

NAME

       ssgrep - search spreadsheets for strings

SYNOPSIS

       ssgrep  [OPTIONS] [FILES]

DESCRIPTION

       This manual page briefly documents the ssgrep command.

       ssgrep is a command line utility to search for strings in spreadsheets of any format supported by gnumeric.

OPTIONS

       This  program  follows  the  usual GNU command line syntax, with single letter options starting with a single dash (`-') and longer options
       starting with two dashes (`--').

   Options controlling input file handling
       --recalc
	      Recalculate all cells

   Options controlling patterns and pattern matching
       -f, --keyword-file=FILE
	      The path to a text file containing one key per line

       -i, --ignore-case
	      Ignore differences in letter case

       -w, --word-regexp
	      Match only whole words

       -F, --fixed-strings
	      Pattern is a set of fixed strings

       -R, --search-results
	      Search results of expressions too

       -v, --invert-match
	      Search for cells that do not match

   Options controlling output in general
       -c, --count
	      Only print a count of matches per file

       -L, --files-without-matches
	      Print filenames without matches

       -l, --files-with-matches
	      Print filenames with matches

       -q, --quiet
	      Suppress all normal output

       -H, --with-filename
	      Print the filename for each match

       -h, --without-filename
	      Do not print the filename for each match

       -n, --print-locus
	      Print the location of each match

       -T, --print-type
	      Print the location type of each match

   Help options
       -V, --version
	      Display ssgrep's version

       -?, --help
	      Display the supported options

       --usage
	      Display a brief usage message

EXAMPLE

       To search for the string "SUM" in the file foo.gnumeric :

       ssgrep SUM foo.gnumeric

       To search for the strings from the file keywords in the spreadsheet foo.xls :

       ssgrep --keyword-file=keywords foo.xls

LICENSE

       ssgrep is licensed under the terms of the General Public License (GPL), version 2. For information on this license look at the source  code
       that came with the software or see the GNU project page <http://www.gnu.org>.

COPYRIGHT

       The copyright on ssgrep and the gnumeric software and source code is held by the individual authors as is documented in the source code.

AUTHOR

       ssgrep's primary author is Jody Goldberg <jody@gnome.org>; ssgrep builds on the gnumeric codebase.

       The initial version of this manpage was based on ssindex.1 by J.H.M. Dassen (Ray) <jdassen@debian.org>.

SEE ALSO

       beagled(1), gnumeric(1), ssconvert(1), ssindex(1)

       The Gnumeric Homepage <http://www.gnome.org/projects/gnumeric/>.

       The GNOME project page <http://www.gnome.org/>.

gnumeric							    2009-02-08								 SSGREP(1)