cut awk dummy question :)


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers cut awk dummy question :)
# 1  
Old 11-09-2007
cut awk dummy question :)

how to make cut and awk treat "a b" as a single column rather then two separate columns "a and b"?
how to remove " symbol from "a b" so there is only a b?

Please help
Regards
Karol
# 2  
Old 11-09-2007
I would say it depends on the context, the layout of the data, etc. If it is data You want to operate on? Is it in a file? What is before and after Your "a b"? Please be more specific!
# 3  
Old 11-09-2007
By default cut and awk use "space" as the default field separator.

In order to tread "a b" as the same field you will have to define a different field separator using the -F options. This is dependant on your input file format.

example input.file
a b:c d:e:f

awk -F: '{print $1}' input.file

will return
a b
Seer
# 4  
Old 11-09-2007
Quote:
Originally Posted by Seer
By default cut and awk use "space" as the default field separator.
Just to be clear, the default field separator for cut is TAB, and (just guessing here) WHITESPACE for awk.

Your example in cut would sound like...
example input.file
a b:c d:e:f

cut -d":" -f1 input.file

will return
a b

/Der Messerschmidt
# 5  
Old 11-10-2007
Quote:
Originally Posted by sopel39
how to make cut and awk treat "a b" as a single column rather then two separate columns "a and b"?
how to remove " symbol from "a b" so there is only a b?

Please help
Regards
Karol
Code:
awk -F"a b" '{ print $1 }' filename

Could you please post some sample data ?
# 6  
Old 11-10-2007
input sample

input is a file which can contain " symbols
and cut or awk should interpete line like this:
something "some text"
as:
col1 col2 col3
something "some text"
or:
something some text <- this is better i dont have to
remove "
it shouldn't interperte it as:
something "some text"
# 7  
Old 11-10-2007
Quote:
Originally Posted by sopel39
input is a file which can contain " symbols
and cut or awk should interpete line like this...
WOW!
This one almost had my brains boiling but I was set on solving it in bash...
There were problems with read and quotes, if I enter for example on the commandline
Quote:
temp=(qwer "sdfg sdfg" asdf)
it evaluates to three elements but in read or when assigning the read variable to something else, it evaluates to four elements, the quotes are treated as parts of the words they are next to. So I came up with eval, what a nice feature! I use === as separator just to show it more clearly.


Quote:
lakris@ubuntu:~/projekt/scripts$ cat textfile.txt
Male "adam jones" angling
"Not confirmed" "paul higgins" "clothes and music"
Female "kelly lowe" shoes
lakris@ubuntu:~/projekt/scripts$ cat quoted-text.sh
#!/bin/bash
while read line; do
command="slask=($line)"
eval $command
for (( i=0 ; i<${#slask[*]} ; i++ )) ; do
echo -n ${slask[i]} === ;
done
echo
done <textfile.txt
lakris@ubuntu:~/projekt/scripts$ chmod +x quoted-text.sh
lakris@ubuntu:~/projekt/scripts$ ./quoted-text.sh
Male ===adam jones ===angling ===
Not confirmed ===paul higgins ===clothes and music ===
Female ===kelly lowe ===shoes ===
lakris@ubuntu:~/projekt/scripts$
/Lakris
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Dummy Question

Where can I get UNIX? (1 Reply)
Discussion started by: ciao303
1 Replies

2. UNIX for Dummies Questions & Answers

Dummy question on awk

Hi, I have a file which has three columns and 200 rows. I would like to print an extra column say "disco" for every 10 th row starting from 4 th row. How is that possible? Thnx (4 Replies)
Discussion started by: Indra2011
4 Replies

3. IP Networking

DNS dummy question

Hello everyone, I have a some doubt about DNS. We have connected to 2 ISPs /ISP#1 and ISP#2/. Our web site's dns zone is located on ISP#1. If connection to ISP#1 is down clients won't find our website. ISP#1 connection went down few times this month. So we are going to create our website's... (0 Replies)
Discussion started by: sembii
0 Replies

4. UNIX for Dummies Questions & Answers

a dummy question on data processing

Hi, everyone, I have a matrix, let's say: 1 2 3 4 5 6 ... 4 5 6 7 8 9 ... 7 8 9 1 2 3 ... 3 4 5 6 7 8 ... ......... (nxm matrix) Is there a simple command that can take certain specific rows out of the matrix? e.g., I want to take row 2 (4 5 6 7 8 9 ...) and row 4 (3 4 5 6 7 8... (2 Replies)
Discussion started by: kaixinsjtu
2 Replies

5. UNIX for Dummies Questions & Answers

dummy question on data process

I have a file which contains 6 columns. But I only need the first 3 columns. So I need to remove the last 3 columns. I checked 'cut' but it seems not working. So is there a command that could remove certain columns from a file? :( Thanks a lot!! (5 Replies)
Discussion started by: kaixinsjtu
5 Replies

6. UNIX for Dummies Questions & Answers

a dummy question...needs help...

I am trying to use 'cut' to get a line from my file. But it seems that 'cut' recongnizes TAB as default. My file uses space instead. So 'cut' doesn't work. Anybody can tell me how to change the default from TAB to space ? Or how to transform a space-delimited file into tab-delimited file??... (2 Replies)
Discussion started by: kaixinsjtu
2 Replies

7. UNIX for Dummies Questions & Answers

Dummy question about /proc/cpuinfo

Perhaps this is a very dummy question but sorry I don't know other place to do it. We just buy a new cluster of Xeon machines but there is something I don't understand and perhaps someone can help me. The more /proc/cpuinfo produces the following output (just part of it). processor : 0... (1 Reply)
Discussion started by: jhc
1 Replies

8. Filesystems, Disks and Memory

A simple dummy question

Hello Everyone! changing from Microsoft to Macintosh, I connected my hard disk (nearly full) to the apple computer, which could not recognize it. I was prompt to "initialize it", unfortunately I DECIDED YES!!, but just for 1/100 of a second: now I cannot access the hard disk at all. Is still... (1 Reply)
Discussion started by: NETTO68
1 Replies

9. UNIX for Dummies Questions & Answers

question from a dummy

okay so I just started this unix class and understood all the test questions but this "normal" question threy me through a loop :confused:. The question is Why are UNIX commands noninteractive and why is their output not usually preceededby header information? This question has been driving me... (2 Replies)
Discussion started by: cinnamonbear
2 Replies

10. UNIX for Dummies Questions & Answers

Unix dummy's question

:confused: Hi, 2 questions to get some insight. Thanks (1) I would like to add a prefix (XX00) in each row of the line in my text file and save a newly generated file another name. How to go about it. (2) How to insert a blank line into each row in my file. and save the file another name.... (2 Replies)
Discussion started by: merry susana
2 Replies
Login or Register to Ask a Question