Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Cutting a file with multiple delimiters into columns
Top Forums Shell Programming and Scripting Cutting a file with multiple delimiters into columns Post 302409613 by steadyonabix on Thursday 1st of April 2010 04:44:58 PM
Old 04-01-2010
Code:
awk -F";;;" -v w=15 ' {
        for ( i = 1; i <=NF; i++ ){
                split ( $i, s, ";" )
                for ( si in s ){
                        if ( s[si] ~ ":|," ){
                                char = (s[si] ~ ",") ?  "," : ":"
                                split( s[si], c, char )
                                for ( ci in c )
                                        printf("%-"w"s", c[ci])
                        }
                        else
                                printf("%-"w"s", s[si])
                }
                printf("\n")
        }
}' $file

Output: -

Code:
EUR            EUR            EUR            USD            USD            USD            
EUR/USD        XAU/AUD        XAU/EUR        XAU/AUD        GBP/BOB        UAD/XAU        
1.11           2.22           3.33           4.44           5.55           6.66

 

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 (9 Replies)
Discussion started by: mahabunta
9 Replies

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 Replies)
Discussion started by: Serious Sam
3 Replies

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

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

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,... (20 Replies)
Discussion started by: Ryan.
20 Replies

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

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

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

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? ... (9 Replies)
Discussion started by: wbport
9 Replies

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")... (3 Replies)
Discussion started by: dev.devil.1983
3 Replies

LEARN ABOUT DEBIAN

gluster

Gluster(8)							   Gluster Inc. 							Gluster(8)

NAME

       gluster - Gluster Console Manager (command line utility)

SYNOPSIS

       gluster

       To run the program and display gluster prompt:

       gluster

       (or)

       To specify a command directly:

       gluster [commands] [options]

DESCRIPTION

       The  Gluster Console Manager is a command line utility for elastic volume management. You can run the gluster command on any export server.
       The command enables administrators to perform cloud operations, such as creating, expanding, shrinking, rebalancing, and migrating  volumes
       without needing to schedule server downtime.

COMMANDS

   Volume Commands
	volume info [all|<VOLNAME>]
	      Display information about all volumes, or the specified volume.

	volume create <NEW-VOLNAME> [stripe <COUNT>] [replica <COUNT>] [transport <tcp|rdma|tcp,rdma>] <NEW-BRICK> ...
	      Create  a  new  volume  of the specified type using the specified bricks and transport type (the default transport type is tcp).	To
	      create a volume with both transports (tcp and rdma), give 'transport tcp,rdma' as an option.

	volume delete <VOLNAME>
	      Delete the specified volume.

	volume start <VOLNAME>
	      Start the specified volume.

	volume stop <VOLNAME> [force]
	      Stop the specified volume.

	volume rename <VOLNAME> <NEW-VOLNAME>
	      Rename the specified volume.

	volume set <VOLNAME> <OPTION> <PARAMETER> [<OPTION> <PARAMETER>] ...
	      Set the volume options.

	volume help
	      Display help for the volume command.

   Brick Commands
	volume add-brick <VOLNAME> <NEW-BRICK> ...
	      Add the specified brick to the specified volume.

	volume remove-brick <VOLNAME> <BRICK> ...
	      Remove the specified brick from the specified volume.

	      Note: If you remove the brick, the data stored in that brick will not be available. You can migrate data from one brick  to  another
	      using replace-brick option.

	volume rebalance-brick <VOLNAME>(<BRICK> <NEW-BRICK>) start
	      Start rebalancing the specified volume.

	volume rebalance <VOLNAME> stop
	      Stop rebalancing the specified volume.

	volume rebalance <VOLNAME> status
	      Display the rebalance status of the specified volume.

	volume replace-brick <VOLNAME> (<BRICK> <NEW-BRICK>) start|pause|abort|status|commit
	      Replace the specified brick.

   Log Commands
	volume log filename <VOLNAME> [BRICK] <DIRECTORY>
	      Set the log directory for the corresponding volume/brick.

	volume log locate <VOLNAME> [BRICK]
	      Locate the log file for corresponding volume/brick.

	volume log rotate <VOLNAME> [BRICK]
	      Rotate the log file for corresponding volume/brick.

   Peer Commands
	peer probe <HOSTNAME>
	      Probe the specified peer.

	peer detach <HOSTNAME>
	      Detach the specified peer.

	peer status
	      Display the status of peers.

	peer help
	      Display help for the peer command.

   Other Commands
	help  Display the command options.

	quit  Exit the gluster command line interface.

FILES

       /etc/glusterd/*

SEE ALSO

       fusermount(1), mount.glusterfs(8), glusterfs(8), glusterd(8)

COPYRIGHT

       Copyright(c) 2006-2011  Gluster, Inc.  <http://www.gluster.com>

07 March 2011						   Gluster command line utility 						Gluster(8)
All times are GMT -4. The time now is 07:27 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy