Sponsored Content
Top Forums Shell Programming and Scripting Question about Awk for Data Parsing Post 302301057 by EconResearch on Wednesday 25th of March 2009 07:07:24 PM
Old 03-25-2009
Sure. I apologize for any confusion. I will just make up these strings to simplify it, but the structure is the same as my data set. Basically, I need the first four "cells" and the last "cell" of each line but the position of the last cell varies. Thank you for any help.

Input (via csv file):


Name1, year1, day1, amount1.1, amount1.2, amount1.3}
Name1, year1, day2, amount2.1, amount2.2, amount2.3}
Name2, year1, day1, amount1.1, amount1.2, amount1.3, amount1.4}
Name2, year1, day2, amount2.1, amount2.2, amount2.3, amount2.4}
Name3, year1, day1, amount1.1, amount1.2, amount1.3}
Name3, year1, day2, amount2.1, amount2.2}

Output (via csv file):

Name1, year1, day1, amount1.1, amount1.3}
Name1, year1, day2, amount2.1, amount2.3}
Name2, year1, day1, amount1.1, amount1.4}
Name2, year1, day2, amount2.1, amount2.4}
Name3, year1, day1, amount1.1, amount1.3}
Name3, year1, day2, amount2.1, amount2.2}
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Parsing XML dynamic data via awk?

I am trying to use a line of output in an XML file as input in another new XML file for processing purposes via a shell script. Since I am a newbie though, I'm not sure how to do this since the data is different everytime. I am using this technique with static data right now: echo -n "Running... (5 Replies)
Discussion started by: corwin43
5 Replies

2. Shell Programming and Scripting

Parsing the data

Hi I need to parse the following data using shell script Table ----- stage4n_abc 48 stage4o_abcd 4 adashpg_abc_HeartBeat 1 stage4l_asc 168 Can anyone gimme the solution. I want each value to get stored in an array or variable and want the value to be greped from another file.... (1 Reply)
Discussion started by: Archana.Dheepan
1 Replies

3. Shell Programming and Scripting

Parsing data

Hi all , I have a file with billing CDR records in it. I need to parse that information (row format) . The purpose is to compare full content. The example I have given below is a single line record but it has two portions, (1) the line start with “!” and end with “1.2.1.8” and (2) second part... (5 Replies)
Discussion started by: jaygamini
5 Replies

4. Shell Programming and Scripting

Parsing the data

Hi friends, I need to parse the following data in the given format and get the desired output. I need a function, which takes the input as a parameter and the desired output will be returned from the function. INPUT(single parameter as complete string) A;BCF;DFG;FD ... (3 Replies)
Discussion started by: sumesh.1988
3 Replies

5. Shell Programming and Scripting

Help in Parsing data

I have below string Transaction_ID:SDP-DM-151204679 , Transaction_DateTime:2011-02-11 00:00:15 GMT+05:30 , Transaction_Mode:WAP , Circle_ID:4 , Circle_Name:BJ ,Zone: , CustomerID:B_31563486 , MSISDN:7870904329 , IMSI:405876122068099 , IMEI: , Sub_Profile:Pre-Paid , CPID:Nazara , CPNAME:Nazara ,... (6 Replies)
Discussion started by: poweroflinux
6 Replies

6. Shell Programming and Scripting

Data parsing

Hi, I do have a data file which is divided into compartments by ---------. I would like to extract (parse) some of the data and numbers either using awk or sed The file has the format: CATGC Best GO enrichment: Genes/ORF that have the motifs (genes are sorted by max(pa+pd+po)): ... (6 Replies)
Discussion started by: Lucky Ali
6 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

Parsing cron data with awk

Heya, I'm currently working on a script so I can see which cron jobs, if any, on a system are executing less frequently than 15 minutes (1 - 14 minutes). This is the only data I'm interested in. So far I have the following: #!/bin/bash IFS=$'\n';for line in `ls -f /var/spool/cron/*`; do... (5 Replies)
Discussion started by: Elvirnith
5 Replies

9. Shell Programming and Scripting

Parsing XML (and insert data) then output data (bash / Solaris)

Hi folks I have a script I wrote that basically parses a bunch of config and xml files works out were to add in the new content then spits out the data into a new file. It all works - apart from the xml and config file format in the new file with XML files the original XML (that ends up in... (2 Replies)
Discussion started by: dfinch
2 Replies

10. Shell Programming and Scripting

Another parsing question (awk)

Input File Name of the session: filesrv_quo snap Logical Units UID: 60:06:01:60:01:7B:25:00:C8:86:B0:CA:5B:A2:E0:11 Name of the session: verspn2_at_176_0218 snap Logical Units UID: Name of the session: DRT-ny-iadsql1-c_ny-iadsql2-c snap Logical Units UID: ... (4 Replies)
Discussion started by: greycells
4 Replies
lname(3erl)						     Erlang Module Definition						       lname(3erl)

NAME
lname - Interface that supports the name pseudo-objects. DESCRIPTION
This interface is a part of the names library which is used to hide the representation of names. In Orbers Erlang mapping the pseudo-object names and the real IDL names have the same representation but it is desirable that the clients uses the names library so they will not be dependent of the representation. The lname interface supports handling of names e.g. adding and removing name components. Note that the lname interface in orber does not contain a destroy function because the Names are represented as standard Erlang lists and therefor will be removed by the garbage collector when not in use. The type NameComponent used below is defined as: -record('CosNaming_NameComponent', {id, kind=""}). id and kind are strings. The record is defined in the file CosNaming.hrl and it is included with: -include_lib("orber/COSS/CosNaming/CosNaming.hrl"). EXPORTS
create() -> Return Types Return = [NameComponent] This function returns a new name. insert_component(Name, N, NameComponent) -> Return Types Name = [NameComponent] N = int() Return = Name This function returns a name where the new name component has been inserted as component N in Name. get_component(Name, N) -> Return Types Name = [NameComponent] N = int() Return = NameComponent This function returns the N:th name component in Name. delete_component(Name, N) -> Return Types Name = [NameComponent] N = int() Return = Name This function deletes the N:th name component from Name and returns the new name. num_component(Name) -> Return Types Name = [NameComponent] Return = int() This function returns a the number of name components in Name. equal(Name1, Name2) -> Return Types Name1 = Name2 = [NameComponent] Return = bool() This function returns true if the two names are equal and false otherwise. less_than(Name1, Name2) -> Return Types Name1 = Name2 = [NameComponent] Return = bool() This function returns true if Name1 are lesser than Name2 and false otherwise. to_idl_form(Name) -> Return Types Name = [NameComponent] Return = Name This function just checks if Name is a correct IDL name before returning it because the name representation is the same for pseudo and IDL names in orber. from_idl_form(Name) -> Return Types Name = [NameComponent] Return = Name This function just returns the Name because the name representation is the same for pseudo and IDL names in orber. Ericsson AB orber 3.6.20 lname(3erl)
All times are GMT -4. The time now is 02:07 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy