Cutting a file with multiple delimiters into columns
Hi All
I have recently had to start using Unix for work and I have hit brick wall with this prob....
I have a file that goes a little something like this....
is it possible to create a script to manipulate this so that it reads each line the once it hits the ;;; begin a new line?
desired output being...
and furthermore, use that script to accept a parameter eg "EUR"
and have it output the columns that the world matches....like a grep by column if you will
Thanks a mil in advance...
LC
Last edited by Scott; 03-31-2010 at 07:56 PM..
Reason: Please use code tags
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)
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)
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)
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)
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)
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)
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)
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
xscavenger
SCAVENGER(6) Games Manual SCAVENGER(6)NAME
scavenger - a plattform game for X
SYNOPSIS
scavenger
DESCRIPTION
Scavenger is like Lode Runner. You've got to run around gathering objects while avoiding enemies. You can dig down through some of the
blocks to get at buried objects. After you've collected everything, ladders may appear. To finish the level you've got to exit through the
top of the screen. If an enemy falls into a dug brick, he is stunned for a while. If the brick fills in with him in it, he is killed, and
he will reappear at the top of the screen.
This version has a level editor for designing your own levels, and a graphics editor for drawing your own artwork.
OPTIONS
This command has no options.
GAME CONTROLS
The default control is with the number pad keys 4-9:
Dig left Move up Dig right
7 8 9
4 5 6
Move left Move down Move right
As of version 1.3 you can remap the controls. In demo mode hit space to get to the menu, then hit F10 to remap the keys. For each key if
you hit escape the key is unchanged.
F8 Skip to next level k Kill player (useful if he's trapped) ESC Exit back to demo mode Pause Pause game
See the file DOC for more details about scavenger.
COPYRIGHT
Copyright by Dave Ashley dash@xdr.com
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
the Free Software Foundation; version 2 dated June, 1991.
AUTHOR
scavenger was written by David Ashley <dash@xdr.com>.
This manual page was written by Marcus Brinkmann <Marcus.Brinkmann@ruhr-uni-bochum.de>, for the Debian GNU/Linux system.
SCAVENGER(6)