09-24-2008
Parsing textfile problem with cut
Hi,
I have a textfile with several lines like this:
PHP Code:
text num: USER text (num) num num
I need all these stuff. Problem is, how to get these stuff after ":".
USER is a username and all chars are possible, even whitespace. So I cant use cut. Any ideas?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
whats up all, I am very happy I joined this forum, I have learned alot just going through.
I have a small dilemma... trying to parse a textfile, and sort by 1st feild and add up second feild....
cat textfile.in
1200, 2.50
1200, 1.00
1200, 3.00
1000, 1.00
1000, 2.00
1500, 10.00
1600,... (5 Replies)
Discussion started by: djsal
5 Replies
2. Shell Programming and Scripting
I need to separate out the contents in the string "xyz","1233","cm_asdfasdf" as xyz,1233,cm_asdfasdf
Can anyone help me on this?? (1 Reply)
Discussion started by: Sushir03
1 Replies
3. Shell Programming and Scripting
Hi,
i need to parse a string which looks like this
"xyz","1233","cm_asdfasdf" (2 Replies)
Discussion started by: Sushir03
2 Replies
4. Shell Programming and Scripting
I need to parse a string which looks like
"xyx","sdfsdf","asf_asdf"
into
var1="xyx"
var2="sdfsdf"
var3="asf_asdf" (3 Replies)
Discussion started by: Sushir03
3 Replies
5. Shell Programming and Scripting
i need to cut the string in a textfile but each line has a specific way of cutting it (different lengths)
i have a for loop that gets the string line per line, then each line has to be compared:
for x in `cat tmp2.txt`; do
if; then
echo 'BAC'
elif
... (6 Replies)
Discussion started by: izuma
6 Replies
6. Shell Programming and Scripting
Hi all,
I am having problems parsing the following file:
cat mylist
one,two,three
four
five,six
My goal is to get each number on a seperate line.
one
two
three
four
five
six
I tried this command:
sed -e 's/\,/^M/g' mylist (11 Replies)
Discussion started by: rob11g
11 Replies
7. Shell Programming and Scripting
Hello,
I have a similar problem so I continue this thread.
I have:
my_script_to_format_nicely_bdf.sh | grep "RawData" |tr -s ' '|cut -d' ' -f 4|tr -d '%'
So it supposed to return the percentage used of RawData FS:
80
(Want to use it in a alert script)
However I also have a RawData2 FS so... (17 Replies)
Discussion started by: drbiloukos
17 Replies
8. Shell Programming and Scripting
i am having a text file like below
rama
surya
pandu
latha
singh
raja
i want to get the new file from 3 to 5
i.e
pandu
latha
singh
please help (1 Reply)
Discussion started by: suryanarayana
1 Replies
9. Shell Programming and Scripting
My first post, so don't kill me :)
Say i open some textfile with some example like this.
on the table are handy, bread and wine
Now i know exactly what is in and i want to separate and sorted it in terminal to an existing file with another 2 existing lines in like this:
table
plane ... (3 Replies)
Discussion started by: schwatter
3 Replies
10. Shell Programming and Scripting
Dear all,
I would like to use SQL's log file to extract information from it.
This file can include four different types of instruction with the number of lines involved for each of them:
-> (1) "INSERT" instruction with the number of lines inserted
-> (2) "UPDATE" instruction with the... (4 Replies)
Discussion started by: dae
4 Replies
CUT(1) General Commands Manual CUT(1)
NAME
cut - select out columns of a file
SYNOPSIS
cut [ -b | -c] list [file...]
cut -f list [-d delim] [ -s]
OPTIONS
-b Cut specified bytes
-c Select out specific characters
-d Change the column delimiter to delim
-f Select out specific fields that are separated by the
-i Runs of delimiters count as one
-s Suppres lines with no delimiter characters, when used
EXAMPLES
cut -f 2 file # Extract field 2
cut -c 1-2,5 file # Extract character columns 1, 2, and 5
cut -c 1-5,7- file # Extract all columns except 6
DESCRIPTION
[file...]" delimiter character ( see delim)" with the -f option. Lines with no delimiters are passwd through untouched"
Cut extracts one or more fields or columns from a file and writes them on standard output. If the -f flag is used, the fields are sepa-
rated by a delimiter character, normally a tab, but can be changed using the -d flag. If the -c flag is used, specific columns can be
specified. The list can be comma or BLANK separated. The -f and -c flags are mutually exclusive. Note: The POSIX1003.2 standard requires
the option -b to cut out specific bytes in a file. It is intended for systems with multi byte characters (e.g. kanji), since MINIX uses
only one byte characters, this option is equivalent to -c. For the same reason, the option -n has no effect and is not listed in this man-
ual page.
SEE ALSO
sed(1), awk(9).
CUT(1)