Script suggestion

 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Script suggestion
# 1  
Old 10-31-2016
Script suggestion

I have a file which looks like

Code:
ant1 1,2,3,4 bat1
ant1 5,6,7,8 bat2

I would like to have an O/p as

Code:
ant1 1 bat1
ant1 2 bat1
ant1 3 bat1
ant1 4 bat1
ant1 5 bat2
ant1 6 bat2
ant1 7 bat2
ant1 8 bat2

Is it possible.

Thanks for any suggestion
# 2  
Old 10-31-2016
Just by replacing any comma with a Field Separator (FS) (here:a space) + last Field of the line ($NF) + Record Separator (RS) (here:line jump) + First field of the line ($1) + Field separator (FS) ( here a space) which gives :

Code:
$ cat mytst
ant1 1,2,3,4 bat1
ant1 5,6,7,8 bat2
$ awk '{c=FS$NF RS$1FS;gsub(/,/,c,$0)}1' mytst
ant1 1 bat1
ant1 2 bat1
ant1 3 bat1
ant1 4 bat1
ant1 5 bat2
ant1 6 bat2
ant1 7 bat2
ant1 8 bat2


Last edited by ctsgnb; 10-31-2016 at 04:34 PM..
This User Gave Thanks to ctsgnb For This Post:
# 3  
Old 10-31-2016
Many many thanks
# 4  
Old 10-31-2016
Hi,

Here is without other text utilities:

Code:
#!/bin/bash

while read a b c 
do
IFS=$','
for i in $b
do
echo $a $i $c
done
IFS=$' '
done < file


Last edited by greet_sed; 10-31-2016 at 05:03 PM.. Reason: Add missing line
This User Gave Thanks to greet_sed For This Post:
# 5  
Old 11-01-2016
Hi, more short in bash:
Code:
while read a b c
do
  printf "$a %s $b\n" ${b//,/ }
done < file

Regards.
# 6  
Old 11-01-2016
I guess you meant to write
Code:
printf "$a %s $c\n" ${b//,/ }

This User Gave Thanks to RudiC For This Post:
# 7  
Old 11-01-2016
Hi,

@ disedorgue: I found that ,
Code:
${string//substring/replacement}
Replace all matches of substring with replacement.

For example, ${b//,/} deletes all comma which is ok.

I still couldnt follow how ${b//,/ } works like a loop to give numbers one by one ?

Can you explain how it works or link for more information ?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

I need Help suggestion for script...

Using the korn shell in ubuntu or fedora, I need to compare two forms, each from different files and do the following, form-1 is the dominant form and must be compared to form-2, if the value in field1 of form-1 matches exactly the pre-filled in value in field1 of form2 then I display 'already... (2 Replies)
Discussion started by: smth333
2 Replies

2. Shell Programming and Scripting

Script Suggestion

I am trying to get output for fcs0 fcs1 side by side with "Date" "FCAdapter_Name" "Last Reset" "DMA_Res" "Adapter_Count" "Command_Res" for all the captured output in fcstat.out Am I missing any thing below, as its just showing same values all the coloums: #!/usr/bin/ksh head -30 fcstat.out... (2 Replies)
Discussion started by: aix_admin_007
2 Replies

3. Shell Programming and Scripting

Suggestion with script to cleanup

I need help with sed and awk scripts to search for Symmetrix ID=000090009902 and then grep its child disk devices associated to the dead paths and display them only, so that those dead devices can be removed. test01:/#powermt display dev=all Pseudo name=hdiskpower0 Symmetrix ID=000090009902... (0 Replies)
Discussion started by: aix_admin_007
0 Replies

4. UNIX for Dummies Questions & Answers

OS suggestion

Hello, I'm working on a Linux 2.6.32-33-server (Ubuntu 4.4.3). I typed in man -k package and got e.g. apt I typed in apt --help and got: The program 'apt' is currently not installed. You can install it by typing: sudo apt-get install openjdk-6-jdkI don't understand where this... (2 Replies)
Discussion started by: daWonderer
2 Replies

5. Shell Programming and Scripting

Suggestion to replace a part of script

I have the part of script: if ; then make_command="make -f $temp_file" print $make_command; err_file="${sym_objdir}error.log" $make_command 2>$err_file; cat $err_file; ] && ] && exit 1; exit 0 fi ... (5 Replies)
Discussion started by: Ajay_84
5 Replies

6. Shell Programming and Scripting

need your suggestion

Hi all: I need your suggestion about how to making this script Purpose:- Monitor log for the system OS: Unix Sun Solaris 10 Hold oracle database 10 g Life time for the system cycle to 48 hours the system working as the follow 1- the system is divided into three steps 2-... (0 Replies)
Discussion started by: dellsh
0 Replies

7. Shell Programming and Scripting

suggestion on shell script on copy with xargs

Hi, i am trying to copy files except the latest, my script goes here #! /bin/bash # to copy control files to a local DR server # copy latest files of archive #modified on 26-03-2009 # --get today date dt=` date +"%Y_%m_%d"` --get yesterdays date adt=`(date --date='1 day ago'... (1 Reply)
Discussion started by: saha
1 Replies

8. Shell Programming and Scripting

Need your suggestion please..

can anyone rite here guide me. i want to know which reference books that all of you recommended for C Shell dummies like me...(beginner) (1 Reply)
Discussion started by: unknown2205
1 Replies

9. Programming

I want a suggestion

I am a student and I love the computer very much , especially in programming. However I know little about programming . I don't know which I should learn (JAVA and C++). Would you like to give me a suggestion ? Thanks! (6 Replies)
Discussion started by: camel
6 Replies

10. Post Here to Contact Site Administrators and Moderators

Suggestion

As I was just pondering to myself I relized that emergency's do happen and there are times when people need an anwser to their problem ASAP. So what i was thinking why not add a live chat to this board this way people could chat amongst each other in real time. I know this could be done with a... (1 Reply)
Discussion started by: tovsky
1 Replies
Login or Register to Ask a Question