Split columns into rows Post: 302969802

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

split rows

Hi I wanted to split rows based on the number of 1's present in 21st field(21st field is 40 length field) so I wrote the below awk code. However, the tool that I am using to invoke the command is not recognising the command. So, could you please help me to translate this command to sed? awk...

2. Shell Programming and Scripting

Split rows

Hi all, I need a simple bin/sh script FILE1: ab1 gegege swgdeyedg ac2 jxjjxjxjxxjxjx ad3 ae4 xjxjxj zhzhzh ahahs af5 sjsjsjs ssjsjsjsj sjsjsj ag6 shshshshs sjjssj shhshshs myScript.sh has to return: ROW ab1 ROW ac2 ROW ad3 ROW ae4 In other words: "ROW " + the first world...

3. Shell Programming and Scripting

Split single rows to multiple rows ..

Hi pls help me out to short out this problem rm PAB113_011.out rm: PAB113_011.out: override protection 644 (yes/no)? n If i give y it remove the file. But i added the rm command as a part of ksh file and i tried to remove the file. Its not removing and the the file prompting as...

4. Shell Programming and Scripting

split paste them in rows

Hi, I have a file as ABC 123_456_789 234_678_901 XYZ 1100_1250_1580_1680 1175_1440_1620_1890 so on What I want my output file to look is "split by underscore and then place the contents in rows" output ABC 123 234 ABC 456 678 ABC 789 901 XYZ 1100 1175 XYZ 1250 1440...

5. Shell Programming and Scripting

Deleting all the fields(columns) from a .csv file if all rows in that columns are blanks

Hi Friends, I have come across some files where some of the columns don not have data. Key, Data1,Data2,Data3,Data4,Data5 A,5,6,,10,, A,3,4,,3,, B,1,,4,5,, B,2,,3,4,, If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and...

6. Shell Programming and Scripting

Evaluate 2 columns, add sum IF two columns match on two rows

Hi all, I know this sounds suspiciously like a homework course; but, it is not. My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I...

7. Shell Programming and Scripting

Compare 2 csv files by columns, then extract certain columns of matcing rows

Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns. I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'...

8. Shell Programming and Scripting

awk split columns after matching on rows and summing the last column

input: chr1 1 2 3 chr1 1 2 4 chr1 2 4 5 chr2 3 6 9 chr2 3 6 10 Code: awk '{a+=$4}END{for (i in a) print i,a}' input Output: chr112 7 chr236 19 chr124 5 Desired output: chr1 1 2 7 chr2 3 6 19 chr1 2 4 5

9. Shell Programming and Scripting

How to split all columns into multiple columns?

Hi, all. How can I split all columns into multiple columns separated by tab? Input: qq ee TT 12 m1 aa gg GG 34 2u zz dd hh 56 4h ww cc JJ 78 5y ss ff kk 90 j8 xx pp mm 13 p0 Output: q q e e T T 1 2 m 1 a a g g G G 3 4 2 u z z d d h h 5 6 4 h w w c c J J 7 8 5 y

10. Shell Programming and Scripting

Split multi columns line to 2 columns

I have data like this 1 a,b,c 2 a,c 3 b,d 4 e,f would like convert like this 1 a 1 b 1 c 2 a 2 c 3 b 3 d 4 e 4 f Please help me out

LEARN ABOUT SUSE

pfspad

pfspad(1)						      General Commands Manual							 pfspad(1)

NAME

       pfspad - Add borders to a frame in PFS stream

SYNOPSIS

       pfspad  [--left	<columns>]  [--right <columns>] [--top <rows>] [--bottom <rows>] [--width <new_width>] [--height <new_height>] [--R <val>]
       [--G <val>] [--B <val>] [--Y <val>] [--help]

DESCRIPTION

       Add borders to each frame in PFS stream. User specifies size of left, right, top and bottom border or size of an  output  image.  Color	of
       borders can be specified as well.

OPTIONS

       --left <columns>, -l <columns>
	      Width in pixels of the left border.

       --right <columns>, -r <columns>
	      Width in pixels of the right border.

       --top <rows>, -t <rows>
	      Height in pixels of the top border.

       --bottom <rows>, -b <rows>
	      Height in pixels of the bottom border.

       --width <new_width>, -W <new_width>
	      Width of an output image. Note that --width can be mixed with either --left or --right option.

       --height <new_height>, -H <new_height>
	      Height of an output image. Note that --height can be mixed with either --top or --bottom option.

       --R <val>, -R <val>, --G <val>, -G <val>, --B <val>, -B <val>
	      Color of borders in RGB mode. Default color is black, and if some of the components is not specified, its value is set to 0.0.

       --Y <val>, -Y <val>
	      Color of borders in luminance mode.

       --help, -h
	      Print a list of commandline options.

EXAMPLES

       pfsin image.hdr | pfspad --left 50 --bottom 20 | pfsout out.hdr
	      Add 50 columns to the left and 20 rows to the bottom side of image.hdr.  Color of borders is default black.

       pfsin image.hdr | pfspad --top 20 --height 500 --width 400 --R 1.0 | pfsout out.hdr
	      Add 20 rows to the top side of image.hdr and create output image out.hdr 500 pixels in height and 400 pixels in width. Color of bor-
	      ders is set to red.

SEE ALSO

       pfsin(1) pfsout(1)

BUGS

       Please report bugs and comments to Dorota Zdrojewska <dzdrojewska@wi.ps.pl>.

																	 pfspad(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

split rows

Discussion started by: ahmedwaseem2000

2. Shell Programming and Scripting

Split rows

Discussion started by: ric79

3. Shell Programming and Scripting

Split single rows to multiple rows ..

Discussion started by: sri_aue

4. Shell Programming and Scripting

split paste them in rows

Discussion started by: Diya123