Please help me to do Vertical an horizontal pivoing in unix in single run.
The input file is like this-
MRKT|PROD|PRD|FACT1|FACT2|FACT3|FACT4
M1|P1|PR1|F11|F12|F13|F14
M1|P1|PR2|F21|F22|F23|F24
M1|P1|PR3|F31|F32|F33|F34
M2|P2|PR1|F41|F42|F43|F44
M2|P2|PR2|F51|F53|F54|F55... (4 Replies)
Hi,
Silly question, if I have an excel file that looks something like this:
................. Subject 1 Subject 2 Subject 3 Subject 4
Fever..............13...........9.............23..........14
Headache.........2............12...........18..........23... (3 Replies)
dear all,
i'm new to unix and i try to figure out the best case for making list of vertical text to become horizontal and skip the line 1 and 2.
example text :
Data DATE XXXXX
MAX
47
53
49
51
48
48
7
46
51
8
25 (6 Replies)
How to move a vertical line to Horizontal line.....Can i use a tr command?
code is:
StudentID
Java
.Net
C#
I want to move this line like this:
StudentID Java .Net C#
Please use
code tags! (3 Replies)
Hi All,
please help to achieve the desired output
Example: I have a file which contains the below data
empname
robert
empid
787
design
consultant
empname
alex
empid
898
design
advocate
Desired output should be
empname empid design
robert 787 consultant (19 Replies)
I need to change data from vertical to horizontal but with condition
input
USA|80
AUS|40
BRA|33
VEGAS|40
KENTUCKY|50
NEWYORK|21
DARWIN|33
ADELAIDE|21
SAOPAOLO|44
RIO|89
GAPIZA|44
BENFLEX|32
AXIS|44
ACRE|56
HEIGHT|22 (5 Replies)
Hi Masters,
I need help to change my vertical data to horisontal
input
2015-04-13|JS|741667
2015-04-13|JSJ|2272
2015-04-13|TMS|107099
2015-04-12|JMD|47945
2015-04-13|TM|760024
2015-04-13|JM|484508
2015-04-14|JMJ|318
2015-04-14|JSD|54436
2015-04-13|JM|15410
Output... (2 Replies)
Source file
Name:hostname1
Masking views : Yes
Storage Group Names : hostname1
device (5):
Name:hostname2
Masking views : Yes
Storage Group Names : hostname2
device (5):
Name:hostname3
Masking views : no
Storage Group Names : hostname3
device (5):... (9 Replies)
Discussion started by: ranjancom2000
9 Replies
LEARN ABOUT HPUX
diff3
diff3(1) General Commands Manual diff3(1)NAME
diff3 - 3-way differential file comparison
SYNOPSIS
file1 file2 file3
DESCRIPTION
compares three versions of a file, and prints disagreeing ranges of text flagged with these codes:
all three files differ
file1 is different
file2 is different
file3 is different
The type of change required to convert a given range of a given file to some other is indicated in one of these ways:
Text is to be appended after line number
n1 in file f, where f = or
Text is to be changed in the range line
n1 through line n2. If n1 = n2, the range can be abbreviated to n1.
The original contents of the range follows immediately after a indication. When the contents of two files are identical, the contents of
the lower-numbered file is suppressed.
Produces a script for the
editor that can be used to incorporate into file1 all changes between file2 and file3 (see ed(1)); i.e., the changes that
normally would be flagged and
Produces a script to incorporate only changes flagged
Produces a script to incorporate only changes flagged
Produces a script that will incorporate all
changes between file2 and file3, but treat overlapping changes (that is, changes that would be flagged with in normal
listing) differently. The overlapping lines in both files will be inserted by the edit script bracketed by and lines.
Produces a script that will incorporate only changes flagged
, but treat these changes in the manner of option.
The following command applies the resulting script to file1.
EXTERNAL INFLUENCES
International Code Set Support
Single- and multi-byte character code sets are supported.
WARNINGS
Text lines that consist of a single period defeat
Files longer than 64K bytes do not work.
FILES SEE ALSO diff(1).
diff3(1)