Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

split one column into multiple columns

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting split one column into multiple columns
# 8  
Old 06-30-2009
Thank you Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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:... (2 Replies)
Discussion started by: sand1234
2 Replies

2. 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... (3 Replies)
Discussion started by: RVSP
3 Replies

3. 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 ... (4 Replies)
Discussion started by: ranjancom2000
4 Replies

4. 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... (11 Replies)
Discussion started by: mmab
11 Replies

5. 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 (8 Replies)
Discussion started by: huiyee1
8 Replies

6. 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 (1 Reply)
Discussion started by: jacobs.smith
1 Replies

7. 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... (3 Replies)
Discussion started by: redse171
3 Replies

8. 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... (1 Reply)
Discussion started by: perekl
1 Replies

9. 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 Replies)
Discussion started by: zaneded
3 Replies

10. 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 Replies)
Discussion started by: rakshit
2 Replies
Login or Register to Ask a Question

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)