Cutting a file with multiple delimiters into columns Post: 302409632

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

cutting columns if delimiter has more than one charecter

Hi, My file looks like abc$%sdfhs$%sdf$%sdfaf$% here as seen delimiter is $%...now how cas i take out second field as cut command expect delimiter as single charecter only.....is there is any other way thanks and regards mahabunta

2. Shell Programming and Scripting

Cutting Columns and Moving in to a file

Guys, Can any one tell me how can we cut the columns and move each column in to a separate file using awk? I have a tab delimited file as shown below, 1213 wattt werree 2345 skhasdjh aasas I want to output this in to three files named a.txt,b.txt and c.txt say a.txt...

3. Shell Programming and Scripting

Cutting columns starting at the end of each line...

Hi Guys, Can you help me with a sed or a csh script that will have an output from the input below. Cutting the columns starting from the end of the line and not from the start of the line? Sample1 - The underscore character "_" is actually a space...i need to put it as underscore here coz...

4. UNIX for Dummies Questions & Answers

cutting columns if delimiter has more than one charecter (|^)

Hi All, I am having a file with the delimiter '|^'. File name:test_dlim.csv I want to cut the first field of this using awk command. I tried with the help of the following link:...

5. Shell Programming and Scripting

Sorting problem: Multiple delimiters, multiple keys

Hello If you wanted to sort a .csv file that was filled with lines like this: <Ticker>,<Date as YYYYMMDD>,<Time as H:M:S>,<Volume>,<Corr> (H : , M, S: ) by date, does anybody know of a better solution than to turn the 3rd and 4th colons of every line into commas, sorting on four keys,...

6. UNIX for Dummies Questions & Answers

cutting multiple columns into multiple files

Hypothetically, suppose that file1 id v1 v2 v3 v4 v5 v6 v7..........v100 1 1 1 1 1 1 2 2 .....50 2 1 1 1 1 1 2 2 .....50 3 1 1 1 1 1 2 2 .....50 4 1 1 1 1 1 2 2 .....50 5 1 1 1 1 1 2 2 .....50 I want to write a loop such that I take the id# and the first 5 columns (v1-v5) into the...

7. Shell Programming and Scripting

Awk match multiple columns in multiple lines in single file

Hi, Input 7488 7389 chr1.fa chr1.fa 3546 9887 chr5.fa chr9.fa 7387 7898 chrX.fa chr3.fa 7488 7389 chr21.fa chr3.fa 7488 7389 chr1.fa chr1.fa 3546 9887 chr9.fa chr5.fa 7898 7387 chrX.fa chr3.fa Desired Output 7488 7389 chr1.fa chr1.fa 2 3546 9887 chr5.fa chr9.fa 2...

8. UNIX for Dummies Questions & Answers

Seperate columns according to delimiters

Hi all I need your help to separate colomns based on "-" delimiter for a very big file 30 millions rows I have a colmun looking like this : clomun 1 1-100000989-A_ATC 1-10000179-AAAAA 1-100002154-TGTTA 1-100002155-GTTAG 1-100002443 1-100002490 1-100002619 I need to separte in three...

9. UNIX for Dummies Questions & Answers

Cutting specific columns from lines

I am trying to remove columns 81-97 from a line that can be as long as 114 characters. Because a number of lines might not have under 80 characters, using the cut command following by paste could be a problem. While sed might work, is there some other utility that could do this more easily? ...

10. Shell Programming and Scripting

Getting fields from a file having multiple delimiters

Hi All, I have a file with a single row having the following text ABC.ABC.ABC,Database,New123,DBNAME,F,ABC.ABC.ABC_APP,"@FUNCTION1("ENT1") ,@FUNCTION2("ENT2")",R, I want an output in the following format ABC.ABC.ABC DBNAME ABC.ABC.ABC_APP '@FUNCTION1("ENT1")...

LEARN ABOUT OPENSOLARIS

rcvpack

RCVPACK(1)                                                           [nmh-1.5]                                                          RCVPACK(1)

NAME

       rcvpack - append message to file

SYNOPSIS

       /usr/lib/mh/rcvpack file [-mbox] [-mmdf] [-version] [-help]

DESCRIPTION

       The rcvpack program will append a copy of the message to the file listed on its command line.

       If the -mbox switch is given (the default), then the messages are separated using mbox (uucp) style delimiters.  This is the format used by
       most mail clients (elm, mailx, etc.).

       If the -mmdf switch is given, then the messages are separated by mmdf style delimiters.  Each message in the  file  is  separated  by  four
       CTRL-A's and a newline.

       rcvpack will correctly lock and unlock the file to serialize access to the file, when running multiple copies of rcvpack .

       In general, its use is obsoleted by the file action of slocal, although it might still have occasional uses in various shell scripts.

FILES

       /etc/nmh/mts.conf          nmh mts configuration file

SEE ALSO

       rcvdist(1), rcvstore(1), rcvtty(1), slocal(1)

BUGS

       Only two return codes are meaningful, others should be.

MH.6.8                                                             11 June 2012                                                         RCVPACK(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

cutting columns if delimiter has more than one charecter

Discussion started by: mahabunta

2. Shell Programming and Scripting

Cutting Columns and Moving in to a file

Discussion started by: Serious Sam

3. Shell Programming and Scripting

Cutting columns starting at the end of each line...

Discussion started by: elmer1503

4. UNIX for Dummies Questions & Answers

cutting columns if delimiter has more than one charecter (|^)

Discussion started by: boopathyvasagam