Sponsored Content
Full Discussion: Reformatting Data in AWK
Top Forums Shell Programming and Scripting Reformatting Data in AWK Post 302297125 by radoulov on Thursday 12th of March 2009 02:39:58 PM
Old 03-12-2009
I think the code already produces the output that you describe, except for the field separator (a single space instead of a tab).
Anyway, try running the following code and then open the file with MS Excel or OO Calc (converting text to columns with tab separators).
The records are too long to be correctly displayed on a terminal.

Code:
nawk 'END { print _ }
$1 ~ /^[0-9]*$/ && $NF ~ /^[0-9]*$/ {
  print _; _ = ""
  }
{ $1 = $1; _ = _ ? _ OFS $0 : $0 }
' OFS='\t'  infile > outfile.csv

 

10 More Discussions You Might Find Interesting

1. Filesystems, Disks and Memory

reformatting a floppy!

i am trying to reformat a floppy i am using solaris 9 when i run this: rmformat -F quick /vol/dev/aliases/floppy0 it tells me that it cannot perform the operation on a mounted device. how do i unmount the device and format the floppy? (1 Reply)
Discussion started by: rmuhammad
1 Replies

2. Shell Programming and Scripting

awk multiple file reformatting

I hopefully have a simple request - I need to process multiple files reformatting the output based on tags at the beginning of each line. So the data for the new 3 lines of the output file are in the HDR line and then the details are in the DTL tagged lines. for ifile in $indir do echo... (1 Reply)
Discussion started by: jason_v_brown
1 Replies

3. Shell Programming and Scripting

reformatting xml file, sed or awk I think (possibly perl)

I have some xml files that cannot be read using a standard parser, or I am using the wrong parser. The issues seems to be spaces in some of the tags. Here is a sample,<UgUn 2 > <Un> -0.426753 </Un> </UgUn>The parser isn't able to find the number 2, so that information is lost, etc. It seems... (16 Replies)
Discussion started by: LMHmedchem
16 Replies

4. UNIX for Dummies Questions & Answers

Date reformatting

I have a file with temperature measurements: Loc1,20090102,71.55 Loc1,20090103,71.65 Loc1,20090104,71.55 Loc1,20090105,71.54 Loc1,20090106,71.54 However, to load this into a database I would like to reformat the dates (column 2) from the yyyymmdd format to the yyyy-mm-dd format. I have... (2 Replies)
Discussion started by: figaro
2 Replies

5. UNIX for Dummies Questions & Answers

Date reformatting

I have been reformatting dates from a data file to make them mysql compliant. 31-10-2011 Loc1 1-11-2011 Loc2 The first can be captured by this: sed -i '' -e "s#\(..\)-\(..\)-\(....\)#\3-\2-\1#" data.txt and leads to: 2011-10-31 Loc1 The second line is captured as follows: sed -i... (2 Replies)
Discussion started by: figaro
2 Replies

6. Shell Programming and Scripting

Reformatting data in matrix form

Hi, Some assistance with respect to the following problem will be very helpful. I want to reformat my dataset in the following manner for subsequent analysis. I have first column values (which repeat for each value of 2nd column) which are names, the second column specifies position ad the... (1 Reply)
Discussion started by: newbie83
1 Replies

7. Shell Programming and Scripting

Help with parsing data with awk , eliminating unwanted data

Experts , Below is the data: --- Physical volumes --- PV Name /dev/dsk/c1t2d0 VG Name /dev/vg00 PV Status available Allocatable yes VGDA 2 Cur LV 8 PE Size (Mbytes) 8 Total PE 4350 Free PE 2036 Allocated PE 2314 Stale PE 0 IO Timeout (Seconds) default --- Physical volumes ---... (5 Replies)
Discussion started by: rveri
5 Replies

8. Shell Programming and Scripting

awk help reformatting badly formatted time field

I need help reformatting an input file with spaces in the time field (4th field). I want the field to look like “hh:mm” with appropriate embedded zeros, but instead it has “h :m “ if the hour and/or minute are single character. I'm pretty new to scripting and this is beyond me. Any help would... (4 Replies)
Discussion started by: lisep
4 Replies

9. Shell Programming and Scripting

awk --> math-operation in data-record and joining with second file data

Hi! I have a pretty complex job - at least for me! i have two csv-files with meassurement-data: fileA ...... (2 Replies)
Discussion started by: IMPe
2 Replies

10. Shell Programming and Scripting

Help reformatting column

Hello UNIX experts, I'm stumped finding a method to reformat a column. Input file is a two column tab-delimited file. Essentially, for every term that appears in column 2, I would like to summarize whether that term appears for every entry in column 1. In other words, make a header for each term... (2 Replies)
Discussion started by: torchij
2 Replies
JavaScript::Minifier(3pm)				User Contributed Perl Documentation				 JavaScript::Minifier(3pm)

NAME
JavaScript::Minifier - Perl extension for minifying JavaScript code SYNOPSIS
To minify a JavaScript file and have the output written directly to another file use JavaScript::Minifier qw(minify); open(INFILE, 'myScript.js') or die; open(OUTFILE, '>myScript-min.js') or die; minify(input => *INFILE, outfile => *OUTFILE); close(INFILE); close(OUTFILE); To minify a JavaScript string literal. Note that by omitting the outfile parameter a the minified code is returned as a string. my minifiedJavaScript = minify(input => 'var x = 2;'); To include a copyright comment at the top of the minified code. minify(input => 'var x = 2;', copyright => 'BSD License'); To treat ';;;' as '//' so that debugging code can be removed. This is a common JavaScript convention for minification. minify(input => 'var x = 2;', stripDebug => 1); The "input" parameter is manditory. The "output", "copyright", and "stripDebug" parameters are optional and can be used in any combination. DESCRIPTION
This module removes unnecessary whitespace from JavaScript code. The primary requirement developing this module is to not break working code: if working JavaScript is in input then working JavaScript is output. It is ok if the input has missing semi-colons, snips like '++ +' or '12 .toString()', for example. Internet Explorer conditional comments are copied to the output but the code inside these comments will not be minified. The ECMAScript specifications allow for many different whitespace characters: space, horizontal tab, vertical tab, new line, carriage return, form feed, and paragraph separator. This module understands all of these as whitespace except for vertical tab and paragraph separator. These two types of whitespace are not minimized. For static JavaScript files, it is recommended that you minify during the build stage of web deployment. If you minify on-the-fly then it might be a good idea to cache the minified file. Minifying static files on-the-fly repeatedly is wasteful. EXPORT None by default. Exportable on demand: minifiy() SEE ALSO
This project is developed using an SVN repository. To check out the repository svn co http://dev.michaux.ca/svn/random/JavaScript-Minifier This module is inspired by Douglas Crockford's JSMin: http://www.crockford.com/javascript/jsmin.html You may also be interested in the CSS::Minifier module also available on CPAN. AUTHORS
Peter Michaux, <petermichaux@gmail.com> Eric Herrera, <herrera@10east.com> COPYRIGHT AND LICENSE
Copyright (C) 2007 by Peter Michaux This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.6 or, at your option, any later version of Perl 5 you may have available. perl v5.10.1 2010-12-19 JavaScript::Minifier(3pm)
All times are GMT -4. The time now is 06:35 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy