split one column into multiple columns Post: 302329736

10 More Discussions You Might Find Interesting

1. Web Development

split the fields in a column into 3 columns

Have a column "address" which is combination of city, region and postal code like. Format is : city<comma><space>region<space>postal code abc, xyz 123456 All these three city, region and postal code are not mandatory. There can be any one of the above. In that case a nell...

2. UNIX for Dummies Questions & Answers

split one column into multiple columns

hey guys... Im looking to do the following: 1 2 3 4 5 6 7 8 9 Change to: 1 4 7 2 5 8 3 6 9 Did use | perl -lpe'$\=$.%3?$":"\n"' , but it doesnt give me the matrix i want.

3. UNIX for Dummies Questions & Answers

Split a column into multiple columns at certain character count

Hey everyone, I have an issue with a client that is passing me a list of values in one column, and occasionally the combination of all the values results in more than an 255 character string. My DB has a 255 character limit, so I am looking to take the column (comma delimited file), and if it...

4. Shell Programming and Scripting

Split text separated by ; in a column into multiple columns

Hi, I need help to split a long text in a column which is separated by ; and i need to print them out in multiple columns. My input file is tab-delimited and has 11 columns as below:- aRg02004 21452 asdfwf 21452 21452 4.6e-29 5e-29 -1 3 50 ffg|GGD|9009 14101.10 High class -node. ; ffg|GGD|969...

5. 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

6. 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

7. UNIX for Dummies Questions & Answers

Split 1 column into numerous columns based on patterns

Hi, I have a text file 'Item_List.txt' containing only 1 column. This column lists different products, each separated by the same generic string header "NEW PRODUCT, VERSION 1.1". After this the name of the product is given, then a delimiter string "PRODUCT FIELD", and then the name of the...

8. Shell Programming and Scripting

awk split columns to row after N number of column

I want to split this with every 5 or 50 depend on how much data the file will have. And remove the comma on the end Source file will have 001,0002,0003,004,005,0006,0007,007A,007B,007C,007E,007F,008A,008C Need Output from every 5 tab and remove the comma from end of each row ...

9. UNIX for Beginners Questions & Answers

Split into multiple files by using Unique columns in a UNIX file

I have requirement to split below file (sample.csv) into multiple files by using the unique columns (first 3 are unique columns) sample.csv 123|22|56789|ABCDEF|12AB34|2019-07-10|2019-07-10|443.3400|1|1 123|12|5679|BCDEFG|34CD56|2019-07-10|2019-07-10|896.7200|1|2...

10. UNIX for Beginners Questions & Answers

Using awk to split a column into two columns

Hi, I am trying to split the following output into two columns, where each column has Source: Destination: OUTPUT TO FILTER $ tshark -r Capture_without_mtr.pcap -V | awk '/ (Source|Destination): /' | more Source: x.x.x.x Destination: x.x.x.x Source:...

LEARN ABOUT CENTOS

secolor.conf

secolor.conf(8) 					      System Manager's Manual						   secolor.conf(8)

NAME

       secolor.conf - The SELinux color configuration file

DESCRIPTION

       The  /etc/selinux/{SELINUXTYPE}/secolor.conf  configuation file controls the color to be associated to the context components associated to
       the raw context passed by selinux_raw_context_to_color(3), when context related information is to be displayed in color by an SELinux-aware
       application.

       selinux_raw_context_to_color(3)	obtains  this  color  information  from  the  active  policy secolor.conf file as returned by selinux_col-
       ors_path(3).

FILE FORMAT

       The file format is as follows:
	      color color_name = #color_mask
	      [...]

	      context_component string = fg_color_name bg_color_name
	      [...]

       Where:
       color
	      The color keyword. Each color entry is on a new line.
       color_name
	      A single word name for the color (e.g. red).
       color_mask
	      A color mask starting with a hash (#) that describes the hexadecimal RGB colors with black being #000000 and white being #ffffff.
       context_component
	      The context component name that must be one of the following:
		     user, role, type or range
	      Each context_component string ...  entry is on a new line.
       string
	      This is the context_component string that will be matched with the raw context component passed by selinux_raw_context_to_color(3).
	      A wildcard '*' may be used to match any undefined string for the user, role and type context_component entries only.

       fg_color_name
	      The color_name string that will be used as the foreground color.	A color_mask may also be used.
       bg_color_name
	      The color_name string that will be used as the background color.	A color_mask may also be used.

EXAMPLES

       Example 1 entries are:
	      color black  = #000000
	      color green  = #008000
	      color yellow = #ffff00
	      color blue   = #0000ff
	      color white  = #ffffff
	      color red    = #ff0000
	      color orange = #ffa500
	      color tan    = #D2B48C

	      user * = black white
	      role * = white black
	      type * = tan orange
	      range s0-s0:c0.c1023 = black green
	      range s1-s1:c0.c1023 = white green
	      range s3-s3:c0.c1023 = black tan
	      range s5-s5:c0.c1023 = white blue
	      range s7-s7:c0.c1023 = black red
	      range s9-s9:c0.c1023 = black orange
	      range s15:c0.c1023   = black yellow

       Example 2 entries are:
	      color black  = #000000
	      color green  = #008000
	      color yellow = #ffff00
	      color blue   = #0000ff
	      color white  = #ffffff
	      color red    = #ff0000
	      color orange = #ffa500
	      color tan    = #d2b48c

	      user unconfined_u = #ff0000 green
	      role unconfined_r = red #ffffff
	      type unconfined_t = red orange
	      user user_u	= black green
	      role user_r	= white black
	      type user_t	= tan red
	      user xguest_u	= black yellow
	      role xguest_r	= black red
	      type xguest_t	= black green
	      user sysadm_u	= white black
	      range s0:c0.c1023 = black white
	      user *		= black white
	      role *		= black white
	      type *		= black white

SEE ALSO

       mcstransd(8), selinux_raw_context_to_color(3), selinux_colors_path(3)

SELinux API documentation					   08 April 2011						   secolor.conf(8)

10 More Discussions You Might Find Interesting

1. Web Development

split the fields in a column into 3 columns

Discussion started by: rakshit

2. UNIX for Dummies Questions & Answers

split one column into multiple columns

Discussion started by: zaneded

3. UNIX for Dummies Questions & Answers

Split a column into multiple columns at certain character count

Discussion started by: perekl

4. Shell Programming and Scripting

Split text separated by ; in a column into multiple columns

Discussion started by: redse171