Sponsored Content
Top Forums Shell Programming and Scripting Split column into two on first occurence of any number Post 302949127 by Khanaza on Tuesday 7th of July 2015 11:54:53 AM
Old 07-07-2015
Strange ,I am getting below

Code:
$cat a
abc def 1 xyz zzz
bca cde 2 yyy xxx
$sed -e 's/\(.*\)\([[:digit:]]\)\(.*\)/\1\|\2\3/' a
abc def |1 xyz zzz
bca cde |2 yyy xxx
$

This User Gave Thanks to Khanaza For This Post:
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

grep the number of first occurence

File1.txt ....... ....... OMC LA OMC LK OMC LS ........ ........ Above is the content of File1.txt, i want to get the Number of Occurence to order, lets say if OMC LA = 1, OMC LS=3, and OMC LK=2.. omc_ident="OMC LA" or "OMC LK" or "OMC LS" omc_num=`grep '^OMC' File1.txt| grep... (4 Replies)
Discussion started by: neruppu
4 Replies

2. Shell Programming and Scripting

Split single file into multiple files based on the number in the column

Dear All, I would like to split a file of the following format into multiple files based on the number in the 6th column (numbers 1, 2, 3...): ATOM 1 N GLY A 1 -3.198 27.537 -5.958 1.00 0.00 N ATOM 2 CA GLY A 1 -2.199 28.399 -6.617 1.00 0.00 ... (3 Replies)
Discussion started by: tomasl
3 Replies

3. Shell Programming and Scripting

Number each occurence using sed

hi, I need to number each occurrence of a pattern within a file using sed. Given object 0000 object 111 object 222 I need following 1.object 0000 2.object 111 3.object 222 (5 Replies)
Discussion started by: xerox
5 Replies

4. Shell Programming and Scripting

awk code to ignore the first occurence unknown number of rows in a data column

Hello experts, Shown below is the 2 column sample data(there are many data columns in actual input file), Key, Data A, 1 A, 2 A, 2 A, 3 A, 1 A, 1 A, 1 I need the below output. Key, Data A, 2 A, 2 A, 3 A, 1 A, 1 A, 1 (2 Replies)
Discussion started by: ks_reddy
2 Replies

5. Shell Programming and Scripting

Split a fixed length file bases on last occurence of string

Hi, I need to split a file based on last occurece of a string. PFB the explanation I have a file in following format aaaaaaaaaaaaaaaaaaaaaaaaaaa bbbbbbbbbbbbbbbbbbbbbbbbbbb ccccccccccccccccccccccccccc ddddddddddddddddddddddddddd 3186rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr... (4 Replies)
Discussion started by: Neelkanth
4 Replies

6. UNIX for Dummies Questions & Answers

Add number of occurence

Good morning, I need help to add number of occurence based on column 1 & column 5 file input 81161267334|1|100000|81329998077|20150902 81161267334|1|50000|82236060161|20150902 81161268637|1|25000|81329012229|20150911 81161269307|1|25000|81327019134|20150901... (3 Replies)
Discussion started by: radius
3 Replies

7. Shell Programming and Scripting

Split column data if the table has n number of column's

please write a shell script Table -------------------------- 1 2 3 a b c 3 4 5 c d e 7 8 9 f g h Output should be like this --------------- 1 2 3 3 4 5 7 8 9 a b c c d e f g h (1 Reply)
Discussion started by: Priti2277
1 Replies

8. Shell Programming and Scripting

Split column data if the table has n number of column's with some record

Split column data if the table has n number of column's with some record then how to split n number of colmn's line by line with records Table --------- Col1 col2 col3 col4 ....................col20 1 2 3 4 .................... 20 a b c d .................... v ... (11 Replies)
Discussion started by: Priti2277
11 Replies

9. Shell Programming and Scripting

Print occurence number

Hi folks, I have a file with lots of lines in a text file,i need to print the occurence number after sorting based on the first column as shown below, thanks in advance. sam,dallas,20174 sam,houston,20175 sam,atlanta,20176 jack,raleigh,457865 jack,dc,7845 john,sacramento,4567 ... (4 Replies)
Discussion started by: tech_frk
4 Replies

10. 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
MAIRIXRC(5)							File Formats Manual						       MAIRIXRC(5)

NAME
mairixrc - configuration file for mairix(1) SYNOPSIS
$HOME/.mairixrc DESCRIPTION
The mairixrc file tells mairix where your mail folders are located. It also tells mairix where the results of searches are to be written. mairix searches for this file at $HOME/.mairixrc unless the -f option is used. The directives base, mfolder, and database must always appear in the file. There must also be some folder definitions (using the maildir, mh, or mbox) directives. Comments Any line starting with a '#' character is treated as a comment. Directives base=base-directory This defines the path to the common parent directory of all your maildir folders. If the path is relative, it is treated as relative to the location of the mairixrc file. maildir=list-of-folder-specifications This is a colon-separated list of the Maildir folders (relative to `base') that you want indexed. Any entry that ends `...' is recursively scanned to find any Maildir folders underneath it. More than one line starting with `maildir' can be included. In this case, mairix joins the lines together with colons as though a single list of folders had been given on a single very long line. Each colon-separated entry may be a wildcard. See the discussion under mbox (below) for the wildcard syntax. For example maildir=zzz/foo*... will match maildir folders like these (relative to the base-directory) zzz/foobar/xyz zzz/fooquux zzz/foo zzz/fooabc/u/v/w and maildir=zzz/foo[abc]* will match maildir folders like these (relative to the folder_base) zzz/fooa zzz/fooaaaxyz zzz/foobcd zzz/fooccccccc If a folder name contains a colon, you can write this by using the sequence ':' to escape the colon. Otherwise, the backslash character is treated normally. (If the folder name actually contains the sequence ':', you're out of luck.) mh=list-of-folder-specifications This is a colon-separated list of the MH folders (relative to `base') that you want indexed. Any entry that ends '...' is recur- sively scanned to find any MH folders underneath it. More than one line starting with 'mh' can be included. In this case, mairix joins the lines together with colons as though a single list of folders had been given on a single very long line. Each colon-separated entry may be a wildcard, see the discussion under maildir (above) and mbox (below) for the syntax and semantics of specifying wildcards. recognizes the types of MH folders created by the following email applications: * xmh * sylpheed * claws-mail * evolution * NNML * Mew mbox=list-of-folder-specifications This is a colon-separated list of the mbox folders (relative to `base') that you want indexed. Each colon-separated item in the list can be suffixed by '...'. If the item matches a regular file, that file is treated as a mbox folder and the '...' suffix is ignored. If the item matches a directory, a recursive scan of everything inside that directory is made, and all regular files are initially considered as mbox folders. (Any directories found in this scan are themselves scanned, since the scan is recursive.) Each colon-separated item may contain wildcard operators, but only in its final path component. The wildcard operators currently supported are * Match zero or more characters (each character matched is arbitrary) ? Match exactly one arbitrary character [abcs-z] Character class : match a single character from the set a, b, c, s, t, u, v, w, x, y and z. To include a literal ']' in the class, place it immediately after the opening '['. To include a literal '-' in the class, place it immediately before the closing ']'. If these metacharacters are included in non-final path components, they have no special meaning. Here are some examples mbox=foo/bar* matches 'foo/bar', 'foo/bar1', 'foo/barrrr' etc mbox=foo*/bar* matches 'foo*/bar', 'foo*/bar1', 'foo*/barrrr' etc mbox=foo/* matches 'foo/bar', 'foo/bar1', 'foo/barrrr', 'foo/foo', 'foo/x' etc mbox=foo... matches any regular file in the tree rooted at 'foo' mbox=foo/*... same as before mbox=foo/[a-z]*... matches 'foo/a', 'foo/aardvark/xxx', 'foo/zzz/foobar', 'foo/w/x/y/zzz', but not 'foo/A/foobar' Regular files that are mbox folder candidates are examined internally. Only files containing standard mbox 'From ' separator lines will be scanned for messages. If a regular file has a name ending in '.gz', and gzip support is compiled into the mairix binary, the file will be treated as a gzipped mbox. If a regular file has a name ending in '.bz2', and bzip support is compiled into the mairix binary, the file will be treated as a bzip2'd mbox. More than one line starting with 'mbox' can be included. In this case, mairix joins the lines together with colons as though a sin- gle list of folders had been given on a single very long line. mairix performs no locking of mbox folders when it is accessing them. If a mail delivery program is modifying the mbox at the same time, it is likely that one or messages in the mbox will never get indexed by mairix (until the database is removed and recreated from scratch, anyway.) The assumption is that mairix will be used to index archive folders rather than incoming ones, so this is unlikely to be much of a problem in reality. mairix can support a maximum of 65536 separate mboxes, and a maximum of 65536 messages within any one mbox. omit=list-of-glob-patterns This is a colon-separated list of glob patterns for folders to be omitted from the indexing. This allows wide wildcards and recur- sive elements to be used in the maildir,mh, andmbox directives, with the omit option used to selectively remove unwanted folders from the folder lists. Within the glob patterns, a single '*' matches any sequence of characters other than '/'. However '**' matches any sequence of characters including '/'. This allows glob patterns to be constructed which have a wildcard for just one directory component, or for any number of directory components. The _omit_ option can be specified as many times as required so that the list of patterns doesn't all have to fit on one line. As an example, mbox=bulk... omit=bulk/spam* will index all mbox folders at any level under the 'bulk' subdirectory of the base folder, except for those folders whose names start 'bulk/spam', e.g. 'bulk/spam', 'bulk/spam2005' etc. In constrast, mbox=bulk... omit=bulk/spam** will index all mbox folders at any level under the 'bulk' subdirectory of the base folder, except for those folders whose names start 'bulk/spam', e.g. 'bulk/spam', 'bulk/spam2005', 'bulk/spam/2005', 'bulk/spam/2005/jan' etc. nochecks This takes no arguments. If a line starting with nochecks is present, it is the equivalent of specifying the -Q flag to every indexing run. mfolder=match-folder-name This defines the name of the folder (within the directory specified by base) into which the search mode writes its output. (If the mformat used is 'raw' or 'excerpt', then this setting is not used and may be omitted.) The mfolder setting may be over-ridden for a particular search by using the -o option to mairix. mairix will refuse to output search results to a folder that appears to be amongst those that are indexed. This is to prevent acci- dental deletion of emails. If the first character of the mfolder value is '/' or '.', it is taken as a pathname in its own right. This allows you to specify absolute paths and paths relative to the current directory where the mfolder should be written. Otherwise, the value of mfolder is appended to the value of base, in the same way as for the source folders. mformat=format This defines the type of folder used for the match folder where the search results go. There are four valid settings for format, namely 'maildir', 'mh', 'mbox', 'raw' or 'excerpt'. If the 'raw' setting is used then mairix will just print out the path names of the files that match and no match folder will be created. If the 'excerpt' setting is used, mairix will also print out the To:, Cc:, From:, Subject: and Date: headers of the matching messages. 'maildir' is the default if this option is not defined. The set- ting is case-insensitive. database=path-to-database This defines the path where mairix's index database is kept. You can keep this file anywhere you like. Currently, mairix will place a single database file at the location indicated by path-to-database. However, a future version of mairix may instead place a directory containing several files at this location. path-to-database should be an absolute pathname (starting with '/'). If a relative pathname is used, it will be interpreted rela- tive to the current directory at the time mairix is run, (not relative to the location of the mairixrc file or anything like that.) Expansions The part of each line in '.mairixrc' following the equals sign can contain the following types of expansion: Home directory expansion If the sequence '~/' appears at the start of the text after the equals sign, it is expanded to the user's home directory. Example: database=~/Mail/mairix_database Environment expansion If a '$' is followed by a sequence of alpha-numeric characters (or '_'), the whole string is replaced by looking up the correspond- ing environment variable. Similarly, if '$' is followed by an open brace ('{'), everything up to the next close brace is looked up as an environment variable and the result replaces the entire sequence. Suppose in the shell we do export FOO=bar and the '.mairixrc' file contains maildir=xxx/$FOO mbox=yyy/a${FOO}b this is equivalent to maildir=xxx/bar mbox=yyy/abarb If the specified environment variable is not set, the replacement is the empty string. NOTES
An alternative path to the configuration file may be given with the -f option to mairix(1). January 2006 MAIRIXRC(5)
All times are GMT -4. The time now is 03:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy