Visit Our UNIX and Linux User Community


Parsing Problem


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Parsing Problem
# 1  
Old 10-27-2009
Parsing Problem

Hi all,
I am having problems parsing the following file:

cat mylist
Code:
one,two,three
four
five,six

My goal is to get each number on a seperate line.

Code:
one
two
three
four
five
six

I tried this command:

Code:
sed -e 's/\,/^M/g' mylist

I get the following output:

Code:
three
four
sixe

Any ideas ?

Last edited by vgersh99; 10-27-2009 at 07:59 PM.. Reason: code tags, please!
# 2  
Old 10-27-2009
Code:
tr ',' '\n' < myFile

# 3  
Old 10-27-2009
Or awk:
Code:
awk -v RS='[,\n]' '1' file1

# 4  
Old 10-27-2009
Quote:
Originally Posted by scottn
Or awk:
Code:
awk -v RS='[,\n]' '1' file1

Unfortunately, not all awk-s take RS as a regex. And moreover, not all awk-s take more more than 1 char in RS.
Good idea though Smilie
# 5  
Old 10-27-2009
If I was me, I'd use the tr method :-)
# 6  
Old 10-27-2009
Sytax error with this command.

---------- Post updated at 07:06 PM ---------- Previous update was at 07:05 PM ----------

tr: too many arguments
Try `tr --help' for more information.

---------- Post updated at 07:06 PM ---------- Previous update was at 07:06 PM ----------

the awk command did work.
# 7  
Old 10-27-2009
Code:
xargs -n1 -d, <mylist

Code:
sed 's/,/\n/g' mylist

Code:
grep -o '[^,]*' mylist


Last edited by Scrutinizer; 10-27-2009 at 08:14 PM..

Previous Thread | Next Thread
Test Your Knowledge in Computers #848
Difficulty: Medium
The IEEE standardized Bluetooth as IEEE 802.15.1, but IEEE no longer maintains the Bluetooth standard.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk parsing problem

Hello fellow unix geeks, I am having a small dilemna trying to parse a log file I have. Below is a sample of what it will look like: MY_TOKEN1(group) TOKEN(other)|SSID1 MY_TOKEN2(group, group2)|SSID2 What I need to do is only keep the MY_TOKEN pieces and where there are multiple... (7 Replies)
Discussion started by: dagamier
7 Replies

2. Shell Programming and Scripting

Problem parsing

Hi, I want to fetch a text.Clipping. ... (5 Replies)
Discussion started by: protocomm
5 Replies

3. Shell Programming and Scripting

Problem parsing args

Heya Tooltip: Parsing (getopts) for -u successfully sets mode=umnt, but case umnt is not executed, instead it either executes/show help or regular mount screen. I had copy pasted the structure of a getopts 'structure' from Man Page for getopts (posix Section 1) - The UNIX and Linux Forums... (1 Reply)
Discussion started by: sea
1 Replies

4. Shell Programming and Scripting

Parsing problem

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

5. Shell Programming and Scripting

Parsing textfile problem with cut

Hi, I have a textfile with several lines like this: 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? (3 Replies)
Discussion started by: mcW
3 Replies

6. Shell Programming and Scripting

Parsing problem

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

7. Shell Programming and Scripting

Parsing problem

Hi, i need to parse a string which looks like this "xyz","1233","cm_asdfasdf" (2 Replies)
Discussion started by: Sushir03
2 Replies

8. Shell Programming and Scripting

Parsing problem

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

9. Shell Programming and Scripting

awk parsing problem

I need help with a problem that I have not been able to figure out. I have a file that is about 650K lines. Records are seperated by blank lines, fields seperated by new lines. I was trying to make a report that would add up 2 fields and associate them with a CP. example output would be... (11 Replies)
Discussion started by: timj123
11 Replies

10. Shell Programming and Scripting

parsing problem with script

I'm trying to parse the variables out of a comma delimited expression, but i'm having trouble with script: num_var=1 while do a=`echo "a=7, b=8, c=9" | awk '{print $num_var}' | cut -d= -f2` b=`echo $a | cut -d, -f1` echo $b num_var=`expr $num_var + 1`... (5 Replies)
Discussion started by: mike@freddiemac
5 Replies

Featured Tech Videos