separating comma delimited words


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting separating comma delimited words
# 1  
Old 08-28-2009
CPU & Memory separating comma delimited words

Hi,

I have file with text

________________________________
GROUP:firstname1.lastname1,first_name2.last_name2,first_name3.last_name3
HEAD:firstname.lastname
________________________________


I need help to pick the names separately ie..

Need out put
as
var1 =firstname1.lastname1
Var2=first_name2.last_name2
..
var n=firstname.lastname

or keep them in a array
array[names]


Please help
# 2  
Old 08-28-2009
for ENTRY in `grep -i group <file> | cut -f2 -d: | tr ',' '\012'`; do echo $ENTRY; done

replace "echo $ENTRY" by whatever suits ur needs, e.g.

ARRAY[$INDEX]=${ENTRY}
((INDEX=${INDEX}+1))
# 3  
Old 08-29-2009

Code:
line=GROUP:firstname1.lastname1,first_name2.last_name2,first_name3.last_name3
data=${line#GROUP:}
IFS=, read -a array <<.        ## Bash; use -A for ksh
$data
.

# 4  
Old 08-31-2009
perl:
Code:
my @arr;
open FH,"<a.txt";
while(<FH>){
  chomp;
  my @tmp=split("[:,]",$_);
  @arr=(@arr,@tmp[1..$#tmp]);
}
print join "\n", @arr;

# 5  
Old 09-02-2009
Quote:
Originally Posted by sb008
for ENTRY in `grep -i group <file> | cut -f2 -d: | tr ',' '\012'`; do echo $ENTRY; done

replace "echo $ENTRY" by whatever suits ur needs, e.g.

ARRAY[$INDEX]=${ENTRY}
((INDEX=${INDEX}+1))

I have a small problem, Instead of text file, I have the text coming as an o/p of an other script i.e something similar to
Code:
for ENTRY in `/workspace/script3.sh "$arg1" |grep -i  group |
 cut -f2 -d: | tr ',' '\012'`;

but I don't see the same result as the original code. Please can you correct me?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awkscript to reduce words delimited with comma on right hand to columns

I have a large database with the following structure: Indicword,Indicword,Indicword=English on a line. Not all lines will have this structure. Some might have a single word mapping to a single word in Indic. An example will make this clear ... (4 Replies)
Discussion started by: gimley
4 Replies

2. Shell Programming and Scripting

Help/Advise please for converting space delimited string variable to comma delimited with quote

Hi, I am wanting to create a script that will construct a SQL statement based on a a space delimited string that it read from a config file. Example of the SQL will be For example, it will read a string like "AAA BBB CCC" and assign to a variable named IN_STRING. I then concatenate... (2 Replies)
Discussion started by: newbie_01
2 Replies

3. Shell Programming and Scripting

Separating words in a line

Hi I have the following file # cat red it.d-state = 50988 41498 45 0 0 0 it.age_buffer= 1500 it.dir = 1 I need to grep lines that are present after "=" But when I do so, few lines has more than one value and some has one How to parse the line I have used the follwing... (6 Replies)
Discussion started by: Priya Amaresh
6 Replies

4. Homework & Coursework Questions

ASCII comma-delimited

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: Hi Guys, I am new on the scripting world and would like ask for help if you can. Here are my questions... (1 Reply)
Discussion started by: mahiwaga
1 Replies

5. Shell Programming and Scripting

Need a script to convert comma delimited files to semi colon delimited

Hi All, I need a unix script to convert .csv files to .skv files (changing a comma delimited file to a semi colon delimited file). I am a unix newbie and so don't know where to start. The script will be scheduled using cron and needs to convert each .csv file in a particular folder to a .skv... (4 Replies)
Discussion started by: CarpKing
4 Replies

6. Shell Programming and Scripting

Separating list of input files (*.file) with a comma in bash script

Hi all, I'm trying to get a bash script working for a program (bowtie) which takes a list of input files (*.fastq) and assembles them to an output file (outfile.sam). All the .fastq files are in one folder in my home directory (~/infiles). The problem is that the 'bowtie' requires that... (7 Replies)
Discussion started by: TuAd
7 Replies

7. Shell Programming and Scripting

Keeping Null's as it is and separating them by Comma

Hi, I am having source (Oracle) as given below. SourceOBJECT_NAMESUBOBJECT_NAMEOBJECT_IDDATA_OBJECT_IDOBJECT_TYPECREATEDLAST_DDL_TIMESTAMPSTATUSTGSTEST 336559336559TABLE4/15/2009 10:374/15/2009 10:372009-04-15:10:37:57VALIDNNNUNIX 336559336559TABLE4/15/2009 10:374/15/2009... (3 Replies)
Discussion started by: arunvasu2
3 Replies

8. Shell Programming and Scripting

Separating delimited file by pattern with exclusion list

I have a file with the contents below jan_t=jan;feb_t=feb;mar_t=mar;year=2010 jan_t=null;feb_t=feb;mar_t=mar;year=2010 jan_t=jan;feb_t=feb;mar_t=mar;year=2010 I want to extract out all the fields values ending with "_t" , however, i want to exclude feb_t and mar_t from the results In... (6 Replies)
Discussion started by: alienated
6 Replies

9. Shell Programming and Scripting

Merging files into a single tab delimited file with a space separating

I have a folder that contains say 50 files in a sequential order: cdf_1.txt cdf_2.txt cdf_3.txt cdf_3.txt . . . cdf_50.txt. I need to merge these files in the same order into a single tab delimited file. I used the following shell script: for x in {1..50}; do cat cdf_${x}.txt >>... (3 Replies)
Discussion started by: Lucky Ali
3 Replies

10. Shell Programming and Scripting

Converting Tab delimited file to Comma delimited file in Unix

Hi, Can anyone let me know on how to convert a Tab delimited file to Comma delimited file in Unix Thanks!! (22 Replies)
Discussion started by: charan81
22 Replies
Login or Register to Ask a Question