Sponsored Content
Full Discussion: Duplicate values merge
Top Forums Shell Programming and Scripting Duplicate values merge Post 302768709 by jiam912 on Saturday 9th of February 2013 08:44:59 AM
Old 02-09-2013
Duplicate values merge

Dear Gents,

Please can you help me to solve this problem.

Input file...

Code:
22057485  ,219 ,1050
22057485  ,223 ,1050
21897425  ,278 ,1050
21897425  ,279 ,1050
21897425  ,287 ,1050
20497465  ,602 ,1051
20517500  ,677 ,1051
20517500  ,681 ,1051
20577555  ,775 ,1052
20577555  ,778 ,1052
20357560  ,778 ,1052
20357560  ,780 ,1052
23717535  ,794 ,1053
23717535  ,805 ,1053
23657530  ,797 ,1053
23657530  ,798 ,1053
23657530  ,799 ,1053

I would like to get something like it:

output file

Code:
1050  22057485    219    223    
1050  21897425    278    279    287
1051  20497465    602    603    605
1051  20517500    677    681    
1052  20577555    775    778    
1052  20357560    778    780    
1053  23717535    794    805    
1053  23657530    797    798    799

Thanks in advance
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

merge files with same row values

Hi everyone, I'm just wondering how could I using awk language merge two files by comparison of one their row. I mean, I have one file like this: file#1: 21/07/2009 11:45:00 100.0000000 27.2727280 21/07/2009 11:50:00 75.9856644 25.2492676 21/07/2009 11:55:00 51.9713287 23.2258072... (4 Replies)
Discussion started by: tonet
4 Replies

2. Shell Programming and Scripting

Awk: How to merge duplicate lines and print in a single

The input file: >cat module1 200611051053 95 200523457498 35 200617890187 57 200726098123 66 200645676712 71 200744556590 68 >cat module2 200645676712 ... (10 Replies)
Discussion started by: winter9
10 Replies

3. Shell Programming and Scripting

duplicate values

Hi, How to enumerate duplicate values, without sorting the file. example 1 1 2 1 3 1 1 2 2 2 3 2 1 3 2 3 3 3 Where the first column have the repetead values without sorting, I would like to get the value of the times that the value is repetead , as I show... (2 Replies)
Discussion started by: jiam912
2 Replies

4. Shell Programming and Scripting

Extract values of duplicate keys

I have two questions that are related, so it would be great if you can help me with both! Question1: I have a file A that looks like this: a x b y b z c w I want to get something like: a x b y; z c w Given that a,b,c has no spaces. But the other letters might contain spaces. ... (2 Replies)
Discussion started by: Viernes
2 Replies

5. Shell Programming and Scripting

Append values of duplicate entries

My input file is: LOC_Os01g01870 GO:0006139 LOC_Os01g01870 GO:0009058 LOC_Os01g02570 GO:0006464 LOC_Os01g02570 GO:0009987 LOC_Os01g02570 GO:0008152 LOC_Os01g04380 GO:0006950 LOC_Os01g04380 GO:0009628 I want to append the duplicate values in a tab/space... (2 Replies)
Discussion started by: Sanchari
2 Replies

6. Shell Programming and Scripting

Remove duplicate values with condition

Hi Gents, Please can you help me to get the desired output . In the first column I have some duplicate records, The condition is that all need to reject the duplicate record keeping the last occurrence. But the condition is. If the last occurrence is equal to value 14 or 98 in column 3 and... (2 Replies)
Discussion started by: jiam912
2 Replies

7. Shell Programming and Scripting

How to merge two files with unique values matching.?

I have one script as below: #!/bin/ksh Outputfile1="/home/OutputFile1.xls" Outputfile2="/home/OutputFile2.xls" InputFile1="/home/InputFile1.sql" InputFile2="/home/InputFile2.sql" echo "Select hobby, class, subject, sports, rollNumber from Student_Table" >> InputFile1 echo "Select rollNumber... (3 Replies)
Discussion started by: Sharma331
3 Replies

8. Shell Programming and Scripting

Find duplicate values in specific column and delete all the duplicate values

Dear folks I have a map file of around 54K lines and some of the values in the second column have the same value and I want to find them and delete all of the same values. I looked over duplicate commands but my case is not to keep one of the duplicate values. I want to remove all of the same... (4 Replies)
Discussion started by: sajmar
4 Replies

9. Shell Programming and Scripting

Join and merge multiple files with duplicate key and fill void columns

Join and merge multiple files with duplicate key and fill void columns Hi guys, I have many files that I want to merge: file1.csv: 1|abc 1|def 2|ghi 2|jkl 3|mno 3|pqr file2.csv: (5 Replies)
Discussion started by: yjacknewton
5 Replies
Tt/tt_c.h(file formats) 												   Tt/tt_c.h(file formats)

NAME
Tt/tt_c.h -- ToolTalk definitions SYNOPSIS
#include <Tt/tt_c.h> DESCRIPTION
The Tt/tt_c.h header includes typedefs for the following callback functions: typedef Tt_filter_action (*Tt_filter_function)(const char *nodeid, void *context, void *accumulator); typedef Tt_callback_action (*Tt_message_callback)(Tt_message m, Tt_pattern p); To enable developers to write multithreaded applications, the header defines typedef enum tt_feature { _TT_FEATURE_MULTITHREADED = 1, // Thread-safety _TT_FEATURE_LAST // Enum end marker } Tt_feature; Note that the TT_FEATURE_MULTITHREADED value will be part of the libtt binary interface. These would be accessed by calling code with corresponding #define constants: #define TT_FEATURE_MULTITHREADED _TT_FEATURE_MULTITHREADED in order that that calling code can then use cpp directives to control their use of features: #if defined(TT_FEATURE_MULTITHREADED) .... #endif The header defines the TT_VERSION constant with the value 10200, indicating the version of the ToolTalk API. The header defines the Tt_status enumeration data type, with the following members and specific values: typedef enum tt_status { TT_OK = 0, TT_WRN_NOTFOUND = 1, TT_WRN_STALE_OBJID = 2, TT_WRN_STOPPED = 3, TT_WRN_SAME_OBJID = 4, TT_WRN_START_MESSAGE = 5, TT_WRN_APPFIRST = 512, TT_WRN_LAST = 1024, TT_ERR_CLASS = 1025, TT_ERR_DBAVAIL = 1026, TT_ERR_DBEXIST = 1027, TT_ERR_FILE = 1028, TT_ERR_INVALID = 1029, TT_ERR_MODE = 1031, TT_ERR_ACCESS = 1032, TT_ERR_NOMP = 1033, TT_ERR_NOTHANDLER = 1034, TT_ERR_NUM = 1035, TT_ERR_OBJID = 1036, TT_ERR_OP = 1037, TT_ERR_OTYPE = 1038, TT_ERR_ADDRESS = 1039, TT_ERR_PATH = 1040, TT_ERR_POINTER = 1041, TT_ERR_PROCID = 1042,//The specified process identifier is out of date or invalid TT_ERR_PROPLEN = 1043, TT_ERR_PROPNAME = 1044, TT_ERR_PTYPE = 1045, TT_ERR_DISPOSITION = 1046, TT_ERR_SCOPE = 1047, TT_ERR_SESSION = 1048, TT_ERR_VTYPE = 1049, TT_ERR_NO_VALUE = 1050, TT_ERR_INTERNAL = 1051, TT_ERR_READONLY = 1052, TT_ERR_NO_MATCH = 1053, TT_ERR_UNIMP = 1054, TT_ERR_OVERFLOW = 1055, TT_ERR_PTYPE_START = 1056, TT_ERR_CATEGORY = 1057, TT_ERR_DBUPDATE = 1058, TT_ERR_DBFULL = 1059, TT_ERR_DBCONSIST = 1060, TT_ERR_STATE = 1061, TT_ERR_NOMEM = 1062, TT_ERR_SLOTNAME = 1063, TT_ERR_XDR = 1064, TT_ERR_NETFILE = 1065, TT_DESKTOP_ = 1100, TT_DESKTOP_EPERM = 1101, TT_DESKTOP_ENOENT = 1102, TT_DESKTOP_EINTR = 1104, TT_DESKTOP_EIO = 1105, TT_DESKTOP_EAGAIN = 1111, TT_DESKTOP_ENOMEM = 1112, TT_DESKTOP_EACCES = 1113, TT_DESKTOP_EFAULT = 1114, TT_DESKTOP_EEXIST = 1117, TT_DESKTOP_ENODEV = 1119, TT_DESKTOP_ENOTDIR = 1120, TT_DESKTOP_EISDIR = 1121, TT_DESKTOP_EINVAL = 1122, TT_DESKTOP_ENFILE = 1123, TT_DESKTOP_EMFILE = 1124, TT_DESKTOP_ETXTBSY = 1126, TT_DESKTOP_EFBIG = 1127, TT_DESKTOP_ENOSPC = 1128, TT_DESKTOP_EROFS = 1130, TT_DESKTOP_EMLINK = 1131, TT_DESKTOP_EPIPE = 1132, TT_DESKTOP_ENOMSG = 1135, TT_DESKTOP_EDEADLK = 1145, TT_DESKTOP_ECANCELED = 1147, TT_DESKTOP_ENOTSUP = 1148, TT_DESKTOP_ENODATA = 1161, TT_DESKTOP_EPROTO = 1171, TT_DESKTOP_ENOTEMPTY = 1193, TT_DESKTOP_ETIMEDOUT = 1245, TT_DESKTOP_EALREADY = 1249, TT_DESKTOP_UNMODIFIED = 1299, TT_MEDIA_ERR_SIZE = 1300, TT_MEDIA_ERR_FORMAT = 1301, TT_ERR_APPFIRST = 1536, TT_ERR_LAST = 2047, TT_STATUS_LAST = 2048 } Tt_status; Specific values are required because they can be communicated between ToolTalk clients on different platforms, usually via tt_message_sta- tus_set(3) and tt_message_status(3). The header defines the following enumeration data types, with at least the following members: Tt_filter_action TT_FILTER_CONTINUE, TT_FILTER_LAST, TT_FILTER_STOP Tt_callback_action TT_CALLBACK_CONTINUE, TT_CALLBACK_LAST, TT_CALLBACK_PROCESSED Tt_mode TT_IN, TT_INOUT, TT_MODE_LAST, TT_MODE_UNDEFINED, TT_OUT Tt_scope TT_BOTH, TT_FILE, TT_FILE_IN_SESSION, TT_SCOPE_NONE, TT_SESSION Tt_class TT_CLASS_LAST, TT_CLASS_UNDEFINED, TT_NOTICE, TT_REQUEST Tt_category TT_CATEGORY_LAST, TT_CATEGORY_UNDEFINED, TT_HANDLE, TT_OBSERVE Tt_address TT_ADDRESS_LAST, TT_HANDLER, TT_OBJECT, TT_OTYPE, TT_PROCEDURE Tt_disposition TT_DISCARD, TT_QUEUE, TT_START Tt_state TT_CREATED, TT_FAILED, TT_HANDLED, TT_QUEUED, TT_REJECTED, TT_SENT, TT_STARTED, TT_STATE_LAST The header defines the following as opaque data types: Tt_message, Tt_pattern. The header declares the following as functions: char *tt_X_session(const char *xdisplaystring); Tt_status tt_bcontext_join(const char *slotname, const unsigned char *value, int length); Tt_status tt_bcontext_quit(const char *slotname, const unsigned char *value, int length); Tt_status tt_close(void); Tt_status tt_context_join(const char *slotname, const char *value); Tt_status tt_context_quit(const char *slotname, const char *value); char *tt_default_file(void); Tt_status tt_default_file_set(const char *docid); char *tt_default_procid(void); Tt_status tt_default_procid_set(const char *procid); char *tt_default_ptype(void); Tt_status tt_default_ptype_set(const char *ptid); char *tt_default_session(void); Tt_status tt_default_session_set(const char *sessid); int tt_error_int(Tt_status ttrc); void *tt_error_pointer(Tt_status ttrc); int tt_fd(void); Tt_status tt_file_copy(const char *oldfilepath, const char *newfilepath); Tt_status tt_file_destroy(const char *filepath); Tt_status tt_file_join(const char *filepath); Tt_status tt_file_move(const char *oldfilepath, const char *newfilepath); char *tt_file_netfile(const char *filename); Tt_status tt_file_objects_query(const char *filepath, Tt_filter_function filter, void *context, void *accumulator); Tt_status tt_file_quit(const char *filepath); void tt_free(caddr_t p); char *tt_host_file_netfile(const char *host, const char *filename); char *tt_host_netfile_file(const char *host, const char *netfilename); Tt_status tt_icontext_join(const char *slotname, int value); Tt_status tt_icontext_quit(const char *slotname, int value); char *tt_initial_session(void); Tt_status tt_int_error(int return_val); int tt_is_err(Tt_status s); caddr_t tt_malloc(size_t s); int tt_mark(void); Tt_status tt_message_accept(Tt_message m); Tt_address tt_message_address(Tt_message m); Tt_status tt_message_address_set(Tt_message m, Tt_address a); Tt_status tt_message_arg_add(Tt_message m, Tt_mode n, const char *vtype, const char *value); Tt_status tt_message_arg_bval(Tt_message m, int n, unsigned char **value, int *len); Tt_status tt_message_arg_bval_set(Tt_message m, int n, const unsigned char *value, int len); Tt_status tt_message_arg_ival(Tt_message m, int n, int *value); Tt_status tt_message_arg_ival_set(Tt_message m, int n, int value); Tt_mode tt_message_arg_mode(Tt_message m, int n); char *tt_message_arg_type(Tt_message m, int n); char *tt_message_arg_val(Tt_message m, int n); Tt_status tt_message_arg_val_set(Tt_message m, int n, const char *value); Tt_status tt_message_arg_xval(Tt_message m, int n, xdrproc_t xdr_proc, void **value); Tt_status tt_message_arg_xval_set(Tt_message m, int n, xdrproc_t xdr_proc, void *value); int tt_message_args_count(Tt_message m); Tt_status tt_message_barg_add(Tt_message m, Tt_mode n, const char *vtype, const unsigned char *value, int len); Tt_status tt_message_bcontext_set(Tt_message m, const char *slotname, const unsigned char *value, int length); Tt_status tt_message_callback_add(Tt_message m, Tt_message_callback f); Tt_class tt_message_class(Tt_message m); Tt_status tt_message_class_set(Tt_message m, Tt_class c); Tt_status tt_message_context_bval(Tt_message m, const char *slotname, unsigned char **value, int *len); Tt_status tt_message_context_ival(Tt_message m, const char *slotname, int *value); Tt_status tt_message_context_set(Tt_message m, const char *slotname, const char *value); char *tt_message_context_slotname(Tt_message m, int n); char *tt_message_context_val(Tt_message m, const char *slotname); Tt_status tt_message_context_xval(Tt_message m, const char *slotname, xdrproc_t xdr_proc, void **value); int tt_message_contexts_count(Tt_message m); Tt_message tt_message_create(void); Tt_message tt_message_create_super(Tt_message m); Tt_status tt_message_destroy(Tt_message m); Tt_disposition tt_message_disposition(Tt_message m); Tt_status tt_message_disposition_set(Tt_message m, Tt_disposition r); Tt_status tt_message_fail(Tt_message m); char *tt_message_file(Tt_message m); Tt_status tt_message_file_set(Tt_message m, const char *file); gid_t tt_message_gid(Tt_message m); char *tt_message_handler(Tt_message m); char *tt_message_handler_ptype(Tt_message m); Tt_status tt_message_handler_ptype_set(Tt_message m, const char *ptid); Tt_status tt_message_handler_set(Tt_message m, const char *procid); Tt_status tt_message_iarg_add(Tt_message m, Tt_mode n, const char *vtype, int value); Tt_status tt_message_icontext_set(Tt_message m, const char *slotname, int value); char *tt_message_id(Tt_message m); char *tt_message_object(Tt_message m); Tt_status tt_message_object_set(Tt_message m, const char *objid); char *tt_message_op(Tt_message m); Tt_status tt_message_op_set(Tt_message m, const char *opname); int tt_message_opnum(Tt_message m); char *tt_message_otype(Tt_message m); Tt_status tt_message_otype_set(Tt_message m, const char *otype); Tt_pattern tt_message_pattern(Tt_message m); char *tt_message_print(Tt_message *m); Tt_message tt_message_receive(void); Tt_status tt_message_reject(Tt_message m); Tt_status tt_message_reply(Tt_message m); Tt_scope tt_message_scope(Tt_message m); Tt_status tt_message_scope_set(Tt_message m, Tt_scope s); Tt_status tt_message_send(Tt_message m); Tt_status tt_message_send_on_exit(Tt_message m); char *tt_message_sender(Tt_message m); char *tt_message_sender_ptype(Tt_message m); Tt_status tt_message_sender_ptype_set(Tt_message m, const char *ptid); char *tt_message_session(Tt_message m); Tt_status tt_message_session_set(Tt_message m, const char *sessid); Tt_state tt_message_state(Tt_message m); int tt_message_status(Tt_message m); Tt_status tt_message_status_set(Tt_message m, int status); char *tt_message_status_string(Tt_message m); Tt_status tt_message_status_string_set(Tt_message m, const char *status_str); uid_t tt_message_uid(Tt_message m); void *tt_message_user(Tt_message m, int key); Tt_status tt_message_user_set(Tt_message m, int key, void *v); Tt_status tt_message_xarg_add(Tt_message m, Tt_mode n, const char *vtype, xdrproc_t xdr_proc, void *value); Tt_status tt_message_xcontext_join(const char *slotname, xdrproc_t xdr_proc, void *value); Tt_status tt_message_xcontext_set(Tt_message m, const char *slotname, xdrproc_t xdr_proc, void *value); char *tt_netfile_file(const char *netfilename); int tt_objid_equal(const char *objid1, const char *objid2); char *tt_objid_objkey(const char *objid); Tt_message tt_onotice_create(const char *objid, const char *op); char *tt_open(void); Tt_message tt_orequest_create(const char *objid, const char *op); char *tt_otype_base(const char *otype); char *tt_otype_derived(const char *otype, int i); int tt_otype_deriveds_count(const char *otype); Tt_mode tt_otype_hsig_arg_mode(const char *otype, int sig, int arg); char *tt_otype_hsig_arg_type(const char *otype, int sig, int arg); int tt_otype_hsig_args_count(const char *otype, int sig); int tt_otype_hsig_count(const char *otype); char *tt_otype_hsig_op(const char *otype, int sig); int tt_otype_is_derived(const char *derivedotype, const char *baseotype); Tt_status tt_otype_opnum_callback_add(const char *otid, int opnum, Tt_message_callback f); Tt_mode tt_otype_osig_arg_mode(const char *otype, int sig, int arg); char *tt_otype_osig_arg_type(const char *otype, int sig, int arg); int tt_otype_osig_args_count(const char *otype, int sig); int tt_otype_osig_count(const char*otype); char *tt_otype_osig_op(const char *otype, int sig); Tt_status tt_pattern_address_add(Tt_pattern p, Tt_address d); Tt_status tt_pattern_arg_add(Tt_pattern p, Tt_mode n, const char *vtype, const char *value); Tt_status tt_pattern_barg_add(Tt_pattern m, Tt_mode n, const char *vtype, const unsigned char *value, int len); Tt_status tt_pattern_bcontext_add(Tt_pattern p, const char *slotname, const unsigned char *value, int length); Tt_status tt_pattern_callback_add(Tt_pattern m, Tt_message_callback f); Tt_category tt_pattern_category(Tt_pattern p); Tt_status tt_pattern_category_set(Tt_pattern p, Tt_category c); Tt_status tt_pattern_class_add(Tt_pattern p, Tt_class c); Tt_status tt_pattern_context_add(Tt_pattern p, const char *slotname, const char *value); Tt_pattern tt_pattern_create(void); Tt_status tt_pattern_destroy(Tt_pattern p); Tt_status tt_pattern_disposition_add(Tt_pattern p, Tt_disposition r); Tt_status tt_pattern_file_add(Tt_pattern p, const char *file); Tt_status tt_pattern_iarg_add(Tt_pattern m, Tt_mode n, const char *vtype, int value); Tt_status tt_pattern_icontext_add(Tt_pattern p, const char *slotname, int value); Tt_status tt_pattern_object_add(Tt_pattern p, const char *objid); Tt_status tt_pattern_op_add(Tt_pattern p, const char *opname); Tt_status tt_pattern_opnum_add(Tt_pattern p, int opnum); Tt_status tt_pattern_otype_add(Tt_pattern p, const char *otype); char *tt_pattern_print(Tt_pattern *p); Tt_status tt_pattern_register(Tt_pattern p); Tt_status tt_pattern_scope_add(Tt_pattern p, Tt_scope s); Tt_status tt_pattern_sender_add(Tt_pattern p, const char *procid); Tt_status tt_pattern_sender_ptype_add(Tt_pattern p, const char *ptid); Tt_status tt_pattern_session_add(Tt_pattern p, const char *sessid); Tt_status tt_pattern_state_add(Tt_pattern p, Tt_state s); Tt_status tt_pattern_unregister(Tt_pattern p); void *tt_pattern_user(Tt_pattern p, int key); Tt_status tt_pattern_user_set(Tt_pattern p, int key, void *v); Tt_status tt_pattern_xarg_add(Tt_pattern m, Tt_mode n, const char *vtype, xdrproc_t xdr_proc, void *value); Tt_status tt_pattern_xcontext_add(Tt_pattern p, const char *slotname, xdrproc_t xdr_proc, void *value); Tt_message tt_pnotice_create(Tt_scope scope, const char *op); Tt_status tt_pointer_error(void *pointer); Tt_message tt_prequest_create(Tt_scope scope, const char *op); Tt_status tt_ptr_error(pointer); Tt_status tt_ptype_declare(const char *ptid); Tt_status tt_ptype_exists(const char *ptid); Tt_status tt_ptype_opnum_callback_add(const char *ptid, int opnum, Tt_message_callback f); Tt_status tt_ptype_undeclare(const char *ptid); void tt_release(int mark); Tt_status tt_session_bprop(const char *sessid, const char *propname, int i, unsigned char **value, int *length); Tt_status tt_session_bprop_add(const char *sessid, const char *propname, const unsigned char *value, int length); Tt_status tt_session_bprop_set(const char *sessid, const char *propname, const unsigned char *value, int length); Tt_status tt_session_join(const char *sessid); char *tt_session_prop(const char *sessid, const char *propname, int i); Tt_status tt_session_prop_add(const char *sessid, const char *propname, const char *value); int tt_session_prop_count(const char *sessid, const char *propname); Tt_status tt_session_prop_set(const char *sessid, const char *propname, const char *value); char *tt_session_propname(const char *sessid, int n); int tt_session_propnames_count(const char *sessid); Tt_status tt_session_quit(const char *sessid); Tt_status tt_session_types_load(const char *session, const char *filename); Tt_status tt_spec_bprop(const char *objid, const char *propname, int i, unsigned char **value, int *length); Tt_status tt_spec_bprop_add(const char *objid, const char *propname, const unsigned char *value, int length); Tt_status tt_spec_bprop_set(const char *objid, const char *propname, const unsigned char *value, int length); char *tt_spec_create(const char *filepath); Tt_status tt_spec_destroy(const char *objid); char *tt_spec_file(const char *objid); char *tt_spec_move(const char *objid, const char *newfilepath); char *tt_spec_prop(const char *objid, const char *propname, int i); Tt_status tt_spec_prop_add(const char *objid, const char *propname, const char *value); int tt_spec_prop_count(const char *objid, const char *propname); Tt_status tt_spec_prop_set(const char *objid, const char *propname, const char *value); char *tt_spec_propname(const char *objid, int n); int tt_spec_propnames_count(const char *objid); char *tt_spec_type(const char *objid); Tt_status tt_spec_type_set(const char *objid, const char *otid); Tt_status tt_spec_write(const char *objid); char *tt_status_message(Tt_status ttrc); int tt_trace_control(int onoff); Tt_status tt_xcontext_quit(const char *slotname, xdrproc_t xdr_proc, void *value); Tt/tt_c.h(file formats)
All times are GMT -4. The time now is 04:41 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy