Visit Our UNIX and Linux User Community


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?

Previous Thread | Next Thread
Test Your Knowledge in Computers #610
Difficulty: Medium
Compared to Python, Perl has a relatively small Comprehensive Perl Archive Network (CPAN) library.
True or False?

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

Featured Tech Videos