I would like to remove the first column of lines beginning by a character (in my case is an open square bracket) and finishing by a space (or any other delimiter).
Hi, I have a csv file with a key composed by 3 columns and some other numeric fields and I need to obtain the partial amounts by some part of the key. This may be some difficult to understand, so better see an example, where my input file is:
name,surname,department,y2004,y2005,y2006... (6 Replies)
Hi, I have a slight problem in trying to manipulate the text within a file using the "sed" command in that the text i need changed has "/" slashes in.
I have a .sh script that scans the "/db/sybbackup/" directories for any .dmp file older than 2 days and then to >> the information to a file called... (3 Replies)
Hi, Im very new to the world of sed so I'm really not even sure if this is possible. What i need to do is read from a flat file and every time i see this line:
VAL=123,456
I need to change 456 to 457 for every occurence of this line in the file. The numbers 123 and 456 are different for... (6 Replies)
I have a file with a list of about 2500 lines that I'd like to reformat using some regex in notepad++ or sed from my box (FreeBSD 6.3-RELEASE i386) to do the following:
convert from:
mycommand > mydocument0.htmlbcfn
mycommand > mydocument1.htmlcdcsfn
mycommand > mydocument2.htmldechfn... (6 Replies)
dear all,
on solaris10 for x86 i am trying to modify the creation date of a postscript file with sed in a csh script. sed is driving me crazy though...i think due to the spaces in the string i am trying to substitute??
part of the postscript file:
%!PS-Adobe-3.0... (3 Replies)
Hey All,
I need to reorganize a file's text. Here is the source:
host John_Doe
filename "config.cfg";
hardware ethernet 98:10:3d:13:8f:98;
fixed-address 10.10.10.29;
}
host Jane_Doe
filename "config.cfg";
hardware ethernet 98:13:11:fd:5a:57;
fixed-address 10.10.5.24;
}
host... (2 Replies)
Hello Unix Gurus,
I have a request 2 perform several functions on a file, delete columns, delete rows based on column value, and finally move around columns in the final output. Consider the following input file with 12 columns;
... (1 Reply)
Hello,
I have two files to be treated.
First file:
col1 col2 col3 col4
Second file:
colbis
- I try to add the unique column of the file 2 towards the file 1.
- To obtain the following result with a shell script ksh:
col1 col2 col3 col4 colbis (4 Replies)
Hello good afternoon to everyone.
I'm new to the forum and would like to request your help in handling data. I hope my English is clear.
I have a file (Dato01.txt) to contine the following structure.
# Col1 - Col2 - Col3 - Col4
Patricia started Jun 22 05:22:58
Carolina started Jun... (5 Replies)
Discussion started by: kelevra
5 Replies
LEARN ABOUT V7
tr
TR(1) General Commands Manual TR(1)NAME
tr - translate characters
SYNOPSIS
tr [ -cds ] [ string1 [ string2 ] ]
DESCRIPTION
Tr copies the standard input to the standard output with substitution or deletion of selected characters. Input characters found in
string1 are mapped into the corresponding characters of string2. When string2 is short it is padded to the length of string1 by duplicat-
ing its last character. Any combination of the options -cds may be used: -c complements the set of characters in string1 with respect to
the universe of characters whose ASCII codes are 01 through 0377 octal; -d deletes all input characters in string1; -s squeezes all strings
of repeated output characters that are in string2 to single characters.
In either string the notation a-b means a range of characters from a to b in increasing ASCII order. The character `' followed by 1, 2 or
3 octal digits stands for the character whose ASCII code is given by those digits. A `' followed by any other character stands for that
character.
The following example creates a list of all the words in `file1' one per line in `file2', where a word is taken to be a maximal string of
alphabetics. The second string is quoted to protect `' from the Shell. 012 is the ASCII code for newline.
tr -cs A-Za-z '