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:
desire result should be:
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 REDHAT
kaleidescope
Kaleidescpe(1) General Commands Manual Kaleidescpe(1)NAME
Kaleidescope - rotating line segments
SYNOPSIS
kaleidescope [-display host:display.screen] [-foreground color] [-background color] [-window] [-root] [-install] [-visual visual]
[-color_mode mono | nice | greedy] [-nsegments int] [-ntrails int] [-local_rotation int] [-global_rotation int] [-delay usecs] [-redmin
int] [-greenmin int] [-bluemin int] [-redrange int] [-greenrange int] [-bluerange int]
DESCRIPTION
The kaleidescope program draws line segments in a symmetric pattern that evolves over time.
OPTIONS
kaleidescope accepts the following options:
-root Draw on the root window.
-color_mode mono | nice | greedy
Specify how kaleidescope uses colors. Mono uses just the default foreground and background colors. Nice uses one color for each
segment (specified by nsegments). Greedy uses (ntrails * nsegments) + 1 colors.
-install
Install a private colormap for the window.
-visual visual
Specify which visual to use. Legal values are the name of a visual class, or the id number (decimal or hex) of a specific visual.
-nsegments integer
The number of segments to draw. Default is 7.
-ntrails integer
The number of trails to draw. Default is 100.
-local_rotation integer
The rate at which segments rotate around their center. Default is -59.
-global_rotation integer
The rate at which segments rotate around the center of the window. Default is 1.
-redmin, -greenmin, -bluemin, -redrange, -greenrange, -bluerange
All take an integer argument. When colors are randomly chosen, they are chosen from the interval min to min plus range. The mini-
mums default to 30000. The ranges default to 20000.
-delay microseconds
How much of a delay should be introduced between steps of the animation. Default is 20000, or about 5 frames a second.
ENVIRONMENT
DISPLAY to get the default host and display number.
XENVIRONMENT
to get the name of a resource file that overrides the global resources stored in the RESOURCE_MANAGER property.
SEE ALSO X(1), kaleidescope(1)COPYRIGHT
Copyright (C) 1997 by Ron Tapia. Permission to use, copy, modify, distribute, and sell this software and its documentation for any purpose
is hereby granted without fee, provided that the above copyright notice appear in all copies and that both that copyright notice and this
permission notice appear in supporting documentation. No representations are made about the suitability of this software for any purpose.
It is provided "as is" without express or implied warranty.
AUTHOR
Ron Tapia <tapia@nmia.com>, 20-Mar-97.
X Version 11 14-Dec-95 Kaleidescpe(1)