To make it easier, i gave following example. It is not homework or classwork. Instead, i have a huge csv file dump from tsql with 15 columns and around 300 rows. I was able to extract content that needs to be really converted. Here is the extract:
Code:
ES FP,B1ES FP,70000,I,SL22,SL22 (70000)
ES FP,B2ES FP,80000,I,XX22,XX22 (80000)
VIL SJ,B1VIL SJ,20000,I,SL22,SL22 (20000)
VIL SJ,B2VIL SJ,20000,I,XX22,XX22 (20000)
VIL SJ,S3VIL SJ,25040222,N,SL22,SL22 (25040222)
VIL SJ,S4VIL SJ,25040222,N,XX22,XX22 (25040222)
MING NO,B1MING NO,240000,I,SL22,SL22 (240000)
MING NO,B2MING NO,240000,I,XX22,XX22 (240000)
BCHN SE,B1BCHN SE,20000,I,SL22,SL22 (20000)
BCHN SE,B2BCHN SE,20000,I,XX22,XX22 (20000)
desire result should be:
Code:
ES FP,I,SL22 (70000)|XX22 (80000)
VIL SJ,I,SL22 (20000)|,XX22 (20000)
VIL SJ,N,SL22 (25040222)|XX22 (25040222)
MING NO,I,SL22 (240000)|XX22 (240000)
BCHN SE,I,SL22 (20000)|XX22 (20000)
based on sorting of field f4.
to make it simple, I created two files using grep for I and N but don't know how to append the third column if f1,f2 are same using comma as delim.
=========================
UNIX compare, sort lines and append difference
Hi,
Hi all
i am very new to shell scripting,hope u guys can help
i need to replace,sort and append character for the file that look like this:
1007032811010001000100000001X700026930409
1007032811010001000200000002X700026930409
1007032711020001000300000003X700026930409... (2 Replies)
I need to write a Shell Script to compare two files & display the result. If the two files are different append them and store them in a new file. How do i proceed...can someone give me a coding ? (3 Replies)
I have two files like this:
#FILE 1
ABCD 4322 26485
JMTJ 5311 97248
XMPJ 4321 58978
#FILE 2
ABCD 4321 26485
JMTJ 5311 97248
XMPJ 4321 68978
What to do: Compare the two files and find those lines that doesn't match. And have a new file like this:
#FILE 3
"from file 1"
ABCD 4322 26485... (11 Replies)
Hi,
I am using some codes that have been ported from unix to linux, and now the sorting no longer results in the desired ordering. I'm hoping to find a way to mimic the unix sort command in linux. The input file is structured the following:
$> cat file.txt... (6 Replies)
Hello all -
I am to this forum and fairly new in learning unix and finding some difficulty in preparing a small shell script. I am trying to make script to sort all the files given by user as input (either the exact full name of the file or say the files matching the criteria like all files... (3 Replies)
I have output like this:
USER_ID
12/31/69 19:00:00
12/31/69 19:00:00
USER_ID
12/31/69 19:00:00
12/31/69 19:00:00
USER_ID
12/31/69 19:00:00
12/31/69 19:00:00
USER_ID
12/31/69 19:00:00
12/31/69 19:00:00
...
where USER_ID is a unique user login followed by their login timestamp and... (6 Replies)
To make it easier, i gave following example. It is not homework or classwork. Instead, i have a huge csv file dump from tsql with 15 columns and around 300 rows. I was able to extract content that needs to be really converted. Here is the extract:
ES FP,B1ES FP,70000,I,SL22,SL22 (70000)
ES... (8 Replies)
Hello,
I have two files file 1 and file 2 each having result of a query on certain database tables and need to compare for Col1 in file1 with Col3 in file2, compare Col2 with Col4 and output the value of Col1 from File1 which is a) not present in Col3 of File2 b) value of Col2 is different from... (2 Replies)
Hi,
Could anyone kindly show me a link or explain the difference between
sort -n -k2 -k3 & sort -n -k2,3
Also, if I like to remove the row with repetition at both $2 and $3, Can I safely use
sort -u -k2 -k3
Example;
100 20 30
100 20 30
So, both $2 and $3 are same and I... (2 Replies)
Discussion started by: Indra2011
2 Replies
LEARN ABOUT OPENDARWIN
latency
LATENCY(1) BSD General Commands Manual LATENCY(1)NAME
latency -- monitors scheduling and interrupt latency
SYNOPSIS
latency [-rt] [-c codefile] [-l logfile] [-st threshold] [-it threshold] [-s sleep_in_usecs] [-d decrementer_in_usecs] [-n kernel]
DESCRIPTION
The latency utility provides scheduling and interrupt latency statistics. It requires root privileges due to the kernel tracing facility it
uses to operate.
The arguments are as follows:
-rt Set real time scheduling policy. Default policy is timeshare.
-c When the -c option is specified, it takes a path to a codefile that contains the mappings for the system calls. This option over-
rides the default location of the system call codefile which is found in /usr/share/misc/trace.codes.
-l Specifies a logfile that is written to when either the interrupt or scheduling latency is exceeded.
-st Set the scheduler latency threshold in microseconds. If latency exceeds this, and a logfile has been specified, a record of what
occurred during this time is recorded.
-it Set the interrupt latency threshold in microseconds. If latency exceeds this, and a logfile has been specified, a record of what
occurred during this time is recorded.
-s The -s option sets the timer. It takes microseconds as an argument, the default timer is set to 1000 microseconds.
-d The -d option sets the decrementer. It takes microseconds as an argument. The decrementer is set back to the system default on
exit.
-n By default, latency acts on the default /mach_kernel. This option allows you to specify an alternate booted kernel.
The data columns displayed are as follows:
SCHEDULER The number of context switches that fall within the described delay.
INTERRUPTS The number of interrupts that fall within the described delay.
The latency utility is also SIGWINCH savvy, so adjusting your window geometry will change the list of delay values displayed.
SAMPLE USAGE
latency -rt -st 20000 -it 1000 -l /var/tmp/latency.log
The latency utility will set the realtime scheduling policy. The threshold for the scheduler is set to 20000 microseconds. The threshold
for interrupts is set to 1000 microseconds. Latencies that exceed these thresholds will be logged in /var/tmp/latency.log.
SEE ALSO top(1), fs_usage(1), sc_usage(1)Mac OS X March 28, 2000 Mac OS X
08-13-2013
UNIX compare, sort lines and append difference
