Sponsored Content
Full Discussion: .csv file manipulation
Top Forums Shell Programming and Scripting .csv file manipulation Post 302907383 by Corona688 on Friday 27th of June 2014 12:19:54 PM
Old 06-27-2014
Your method will fail when given things like stray spaces and the like, which are often present in data people post here despite their misguided efforts to "pretty it up" before posting. There's a reason I used //.
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

csv file manipulation

Hi, I generated a csv file.But i have to manipulate it to make it user friendly. This is the structure of the input csv file. partyfailurereasonnumbercvfrejected12cvfapproved45cvfonhold23mvcunknown98mvconcall17pucapproved78puchold34actunknown19 The first line is the header. The... (6 Replies)
Discussion started by: amit.behera
6 Replies

2. Shell Programming and Scripting

csv manipulation

Hi, I want to delete the null values that are present in all the columns except the last column $ cat x.csv baseball,NULL,8798765,Most played,0,5,12367,NULL,NULL,98,67,Reason is not sufficient baseball,NULL,8928192,Most played,0,4,76893,NULL,RAW,54,78,NULL baseball,NULL,5678945,Most... (6 Replies)
Discussion started by: scripter12
6 Replies

3. Shell Programming and Scripting

Awk to convert a text file to CSV file with some string manipulation

Hi , I have a simple text file with contents as below: 12345678900 971,76 4234560890 22345678900 5971,72 5234560990 32345678900 71,12 6234560190 the new csv-file should be like: Column1;Column2;Column3;Column4;Column5 123456;78900;971,76;423456;0890... (9 Replies)
Discussion started by: FreddyDaKing
9 Replies

4. Shell Programming and Scripting

CSV data format manipulation

Hi There I need a script which will pick up the data from a .CSV file and reformat it as per the requirement and write it to another .CSV file. I am using an application that will only take data in a particular format and need something that will convert without manual intervention. The... (4 Replies)
Discussion started by: rbggbr16
4 Replies

5. Shell Programming and Scripting

Data Manipulation on a .csv file

Hallo Friends, I need you help. My file has 5000 or so lines and currently looks like below(sample). Service Type,Origin,Destination,Rate Per Minute,Minimum Charge,Time Based Rate,Time Based From Day,Time Based To Day,Time Based From Time,Time Based To Time,Destination Prefix List,, VoIS... (3 Replies)
Discussion started by: kekanap
3 Replies

6. Shell Programming and Scripting

Pax1.csv file manipulation

Hallo Team and happy Friday, I have a .csv file attached called MHG_Only_Billing_only_great_201408_SummaryDetails.csv The file is as below: $ cat MHG_Only_Billing_only_great_201408_SummaryDetails.csv... (1 Reply)
Discussion started by: kekanap
1 Replies

7. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies

8. Shell Programming and Scripting

Save output of updated csv file as csv file itself

Hi, all I want to sort a csv file based on timestamp from oldest to newest and save the output as csv file itself. Here is an example of my csv file. test.csv SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0739.JPG,2015:02:17 11:32:21 /home/intannf/foto/IMG_0749.JPG,2015:02:17 11:37:28... (10 Replies)
Discussion started by: refrain
10 Replies

9. Shell Programming and Scripting

Save output of updated csv file as csv file itself, part 2

Hi, I have another problem. I want to sort another csv file by the first field. result.csv SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw /home/intannf/foto5/2015_0313_090651_219.JPG,0.,-7.77223,110.37310,30.75,996.46,148.75,180.94,182.00,63.92 ... (2 Replies)
Discussion started by: refrain
2 Replies
evmpost(1)						      General Commands Manual							evmpost(1)

NAME
evmpost - post events to the EVM daemon SYNOPSIS
msg priority]] | [filename| DESCRIPTION
The command takes a file or stream of text event sources as input and converts them to binary EVM events. By default, the command then posts them to the EVM daemon for distribution. If the option is specified, writes the EVM events to its stream instead of posting them to the daemon. By default, attempts to retrieve event template information from the EVM daemon and merges the template items and environmental items such as and into the output events. If the option is used, the output events contain only the items specified in the source. An event source may contain any number of events. Each event is specified in the manner shown. See the EvmEvent(5) manpage for a more detailed explanation. The command recognizes the following data items in an event source: o o o o o o o o o o All EVM variable types may be specified except for Refer to EvmEvent(5) for details on data items and variables. In the event source, each keyword must be accompanied by a corresponding value. The value must be enclosed in double quotes ("") if it contains white space. The data item keywords that are specified outside the event body are taken as global values. The data item keywords are included in each of the following events which do not have an explicit value defined for that keyword. Comments are indicated by a leading character. Blank lines are ignored. The command builds an EVM event containing the items that are explicitly specified in the source. If the event is posted or if the option is specified without additional environmental items such as the and template items are inserted into the event automatically. The rules for posting an event are more stringent than those for an event simply to exist. Therefore, may display an error when trying to post an an event that cannot be posted, even though the same source is accepted when using the option. For example, do not post an event if it does not contain a name with at least three components because the daemon rejects it. However, such an event can exist, and can create it and pass it to The following example fails because it does not contain a name: The following example is successful, even though it does not display any useful information: The option can verify event source and template files by piping the output into See evmshow(1). Options Does not post the events, but instead passes them directly to as raw EVM events. An error occurs if is directed to a terminal device. When used with the option, causes event template items and environmental values to be merged with the items included in the source. This is the default mode. When used with the option, inhibits the merging of template items and environmental values. Posts an administrator's quick message event with the name and the string msg in a variable data item. If a message contains spaces, the message must be enclosed in quotation marks (""). The event is used to add a message entry in the event log. This option may be used only by privileged users. Posts a user's quick message event with the name and the string msg in a variable data item. If a message contains spaces, the message must be enclosed in quotation marks (""). The event is used to add a message entry in the event log. Assigns priority as the for an administrator's or user's quick message. The priority value must be an integer in the range 0-700. If the priority is not specified, the default of 200 is used. Operands filename Read event sources from filename. If filename is omitted, or is specified as event sources are read from RETURN VALUES
The following exit values are returned: Successful completion. An error occurred. EXAMPLES
o The following example posts an event, provided that a template file containing an event with a matching name has been registered with the EVM daemon. o The following example interprets an event template file, and displays a dump of the contents of each event. Environmental items, such as a timestamp, are not merged into the event. This command checks the syntax and contents of the file. o The following example shows how is used in a shell script to signal completion of some operation: o The following example must be run as to post an administrator's message event. o The following example posts a quick user's message. o This example posts an event that includes a variable. If the template for this event contains the following format data item: then displays this event as: WARNINGS
The command rejects attempts to output raw events to a terminal device. Post only events for which you have posting authorization, and for which a template exists. FILES
Definition of the sockets and protocols used for Internet services Location of the EVM authorization file SEE ALSO
Commands evmget(1), evminfo(1), evmshow(1), evmsort(1), evmwatch(1). Routines EvmEventPost(3). Files evmdaemon.conf(4), evmtemplate(4), services(4). Event Management EVM(5). EVM Events EvmEvent(5). evmpost(1)
All times are GMT -4. The time now is 11:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy