Sponsored Content
Top Forums Shell Programming and Scripting Need a script to parse data and output to csv Post 303006467 by RudiC on Thursday 2nd of November 2017 12:44:24 PM
Old 11-02-2017
Try also
Code:
awk  -F"[= ]*"  '
/^[[]/  {V = $1 " " $2 " " ++CNT
         gsub (/[][]/, "", V)
         next
        }

NF < 3  {next
        }

        {LN[V]
         HD[$2]
         MX[V,$2] = $3
        }

END     {H = "DateTime"
                        printf "%20s", H; for (i in HD) printf "%10.10s", i; print "";
         for (j in LN) {printf "%20s", j; for (i in HD) printf "%10.10s", MX[j,i]; print ""}
        }
' file
            DateTime       Age      Name   Subject   Address
 20171102 10:00:00 4        22      MaryLiterature       NYC
 20171102 10:00:00 3        20      John      Math    Newark
 20171102 10:00:00 2        22      Mary                 NYC
 20171102 10:00:00 1        20      John              Newark

We need the running count CNT to differentiate between single records, small additional code can suppress it if need be.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Unix Script to parse a CSV

I am writing a unix script that will parse a CSV and edit the values. My CSV looks like this 0,0,0,0,1,0,1,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0 10,11,7,0,4,12,2,3,7,0,11,3,12,4,0,5,5,4,5,0,8,6,12,0,9,3,3,0,2,7,8... (16 Replies)
Discussion started by: RJ17
16 Replies

2. Shell Programming and Scripting

parse csv file, sha1 hash and output

I have a file, not really a csv, but containing delineated data just the same. Lets call that file "raw_data.txt". It contains data in the format of company name:fein number like this: first company name:123456789 second company name:987654321 what i need to do is read this file, apply... (11 Replies)
Discussion started by: FreddyG
11 Replies

3. Shell Programming and Scripting

select data from oracle table and save the output as csv file

Hi I need to execute a select statement in a solaris environment with oracle database. The select statement returns number of rows of data. I need the data to be inserted into a CSV file with proper format. For that we normally use "You have to select all your columns as one big string,... (2 Replies)
Discussion started by: rdhanek
2 Replies

4. Shell Programming and Scripting

Extract and parse XML data (statistic value) to csv

Hi All, I need to parse some statistic data from the "measInfo" -eg. 25250000 (as highlighted) and return the result into line by line, and erasing all other unnecessary info/tag. Thought of starting with grep "measInfoID="25250000" but this only returns 1 line. How do I get all the output... (8 Replies)
Discussion started by: jackma
8 Replies

5. UNIX for Dummies Questions & Answers

Help to parse csv file with shell script

Hello ! I am very aware that this is not the first time this question is asked here, because I have already read a lot of previous answers, but none of them worked, so... As said in the title, I want to read a csv file with a bash script. Here is a sample of the file: ... (4 Replies)
Discussion started by: Grhyll
4 Replies

6. Shell Programming and Scripting

BASH script to parse XML and generate CSV

Hi All, Hope all you are doing good! Need your help. I have an XML file which needs to be converted CSV file. I am not an expert of awk/sed so your help is highly appreciated!! XML file looks like this: <l:event dateTime="2013-03-13 07:15:54.713" layerName="OSB" processName="ABC"... (2 Replies)
Discussion started by: bhaskar_m
2 Replies

7. Shell Programming and Scripting

Output large volume of data to CSV file

I have a program that output the ownership and permission on each directory and file on the server to a csv file. I am getting error message when I run the program. The program is not outputting to the csv file. Error: the file access permissions do not allow the specified action cannot... (2 Replies)
Discussion started by: dellanicholson
2 Replies

8. Shell Programming and Scripting

How to parse this file using awk and output in CSV format?

My source file looks like this: Cust-Number = "101" Cust-Name="Joe" Cust-Town="London" Cust-hobby="tennis" Cust-purchase="200" Cust-Number = "102" Cust-Name="Mary" Cust-Town="Newyork" Cust-hobby="reading" Cust-purchase="125" Now I want to parse this file (leaving out hobby) and... (10 Replies)
Discussion started by: Balav
10 Replies

9. Shell Programming and Scripting

Copy data to CSV file from txt output

Hi Everyone , Below is output from a TL1 , I want just the NE Name: and beside that the Temperature and the voltages in a csv file , Is this possible? > act-user:AB1S2a:ArshadFO:493::**********; AB1S2a 2016-02-07 10:13:24 M 493 COMPLD "ArshadFO:2016-02-07 10-04-55,0" ;... (11 Replies)
Discussion started by: adgjmpt
11 Replies

10. Programming

Python script to run multiple command and append data in output csv file

Experts, I am writing a script and able to write only small piece of code and not able to collect logic to complete this task. In input file have to look for name like like this (BGL_HSR_901_1AG_A_CR9KTR10) before sh iss neors. Record this (BGL_HSR_901_1AG_A_CR9KTR10) in csv file Now have to... (0 Replies)
Discussion started by: as7951
0 Replies
MooseX::Types::DateTime(3pm)				User Contributed Perl Documentation			      MooseX::Types::DateTime(3pm)

NAME
MooseX::Types::DateTime - DateTime related constraints and coercions for Moose VERSION
version 0.10 SYNOPSIS
Export Example: use MooseX::Types::DateTime qw(TimeZone); has time_zone => ( isa => TimeZone, is => "rw", coerce => 1, ); Class->new( time_zone => "Africa/Timbuktu" ); Namespaced Example: use MooseX::Types::DateTime; has time_zone => ( isa => 'DateTime::TimeZone', is => "rw", coerce => 1, ); Class->new( time_zone => "Africa/Timbuktu" ); DESCRIPTION
This module packages several Moose::Util::TypeConstraints with coercions, designed to work with the DateTime suite of objects. CONSTRAINTS
DateTime A class type for DateTime. from "Num" Uses "from_epoch" in DateTime. Floating values will be used for sub-second precision, see DateTime for details. from "HashRef" Calls "new" in DateTime with the hash entries as arguments. Duration A class type for DateTime::Duration from "Num" Uses "new" in DateTime::Duration and passes the number as the "seconds" argument. Note that due to leap seconds, DST changes etc this may not do what you expect. For instance passing in 86400 is not always equivalent to one day, although there are that many seconds in a day. See "How Date Math is Done" in DateTime for more details. from "HashRef" Calls "new" in DateTime::Duration with the hash entries as arguments. DateTime::Locale A class type for DateTime::Locale::root with the name DateTime::Locale. from "Str" The string is treated as a language tag (e.g. "en" or "he_IL") and given to "load" in DateTime::Locale. from Locale::Maktext The "Locale::Maketext/language_tag" attribute will be used with "load" in DateTime::Locale. DateTime::TimeZone A class type for DateTime::TimeZone. from "Str" Treated as a time zone name or offset. See "USAGE" in DateTime::TimeZone for more details on the allowed values. Delegates to "new" in DateTime::TimeZone with the string as the "name" argument. SEE ALSO
MooseX::Types::DateTime::MoreCoercions DateTime, DateTimeX::Easy AUTHOR
Yuval Kogman <nothingmuch@woobling.org> John Napiorkowski <jjn1056 at yahoo.com> COPYRIGHT
Copyright (c) 2008 Yuval Kogman. All rights reserved This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.18.2 2014-02-03 MooseX::Types::DateTime(3pm)
All times are GMT -4. The time now is 07:18 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy