Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Simple script to write new lines in a text file
Top Forums UNIX for Dummies Questions & Answers Simple script to write new lines in a text file Post 302646977 by torchij on Saturday 26th of May 2012 04:18:55 PM
Old 05-26-2012
Simple script to write new lines in a text file
Hello, I have a comma seperated data sheet with multiple fields of biological data. One column contains the ID name of the sample, where there could be more than one sample separated by a comma. I would like a script that reads this field, and for each sample ID, copies the entire line and writes it below.

For example:

INPUT
Code:
Col1    Col2    Col3                Col4     Col5
data1   data7   NAME1              data11   data15
data2   data8   NAME2              data12   data16
data3   data9   NAME3,NAME4        data13   data17
data4   data10  NAME5              data14   data18
data19  data20  NAME6,NAME7,NAME8  data21   data22

Col3 = sample column (contains up to 15 samples, separated by comma)

OUTPUT
Code:
Col1    Col2    Col3           Col4      Col5
data1   data7   NAME1         data11   data15
data2   data8   NAME2         data12   data16
data3   data9   NAME3         data13   data17
data3   data9   NAME4         data13   data17
data4   data10  NAME5         data14   data18
data19  data20  NAME6         data21   data22
data19  data20  NAME7         data21   data22
data19  data20  NAME8         data21   data22

Any help appreciated!!!
Thanks!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script to read lines in a text file and filter user data

hi all, I have this file with some user data. example: $cat myfile.txt FName|LName|Gender|Company|Branch|Bday|Salary|Age aaaa|bbbb|male|cccc|dddd|19900814|15000|20| eeee|asdg|male|gggg|ksgu|19911216||| aara|bdbm|male|kkkk|acke|19931018||23| asad|kfjg|male|kkkc|gkgg|19921213|14000|24|... (4 Replies)
Discussion started by: srimal
4 Replies

2. Shell Programming and Scripting

how to write shell script to extract lines we want

hi i have a file which is very large . it contains lines in the format below: seed url, html url .... ... seed url, html url i have sort it already. 2010ÄÏ·ÇÊÀ½ç±*_¾º¼¼·ç±©_ÐÂÀËÍø ÕżªÁúרÀ¸£ºÊÀ½ç±*24ÄêµÄ»ØÒä ÆÚÅÎÑÇÖÞδÀ´ÍŽá_2010ÄÏ·ÇÊÀ½ç±*_¾º¼¼·ç±©_ÐÂÀËÍø 2010ÄÏ·ÇÊÀ½ç±*_¾º¼¼·ç±©_ÐÂÀËÍø ¹úÃ×Óë±´ÄáÌØ˹´ï³ÉÐ*Òé... (6 Replies)
Discussion started by: rainboisterous
6 Replies

3. Shell Programming and Scripting

looking for a script that will delete lines in a text file

it will grep for a line and then delete these line. how do i begin to write this script if theres no available one? (3 Replies)
Discussion started by: garfish
3 Replies

4. Shell Programming and Scripting

How to write a script for text file encryption?

Hi All, I have zero knowledge in UNIX, so i desperately need the help from you guys. I need a script which can encrypt all the text files in one shot in a source directory. After all the text files are encrypted, they will be put into a separate folder. Command involve: gpg with -a,... (6 Replies)
Discussion started by: shanbalao
6 Replies

5. Shell Programming and Scripting

how to write multiple lines to a file using shell script?

I need to create an xml using shell script, but i first want to know how can i write multiple lines to file using shell script? (7 Replies)
Discussion started by: vel4ever
7 Replies

6. Shell Programming and Scripting

How to write text file data to excel using UNIX shell script?

Hi All, I have the requirement in unix shell script. I want to write the "ls -ltr" command out put to excel file as below. Input :text file data : drwxr-xr-x 5 root root 4096 Oct 2 12:26 drwxr-xr-x 2 apx aim 4096 Nov 29 18:40 drwxr-xr-x 5 root root 4096 Oct 2 12:26 drwxr-xr-x... (10 Replies)
Discussion started by: Balasankar
10 Replies

7. Shell Programming and Scripting

Bash script - printing range of lines from text file

I'm working on a new exercise that calls for a script that will take in two arguments on the command line (representing the range of line numbers) and will subsequently print those lines from a a specified file. Command line would look like this: ./lines_script.bash 5 15 <file.txt. The script would... (8 Replies)
Discussion started by: ksmarine1980
8 Replies

8. Shell Programming and Scripting

Need help to write a shell script to convert text file to excel file.

Hi Everyone, I want your help to write a script which will take text file as input and on the basis of delimiter ":"script will create excel sheet. Example input: IpAdress:InstanceName:Port:ServerName 10.255.255.1:abc:2232:xyz_abc Output should be an excel sheet like below: Column... (8 Replies)
Discussion started by: akabhinav18
8 Replies

9. Shell Programming and Scripting

Simple script to test mountGpoint for read-write

Guys, need your help urgently. ServerA ServerB ServerA has an email facility and can connect remotely via root using key to ServerB What I am trying to achieve here is ServerA would be able to remotely: 1. Do command 'touch /mnt/testfile.date' on ServerB 2. If touch failed with... (4 Replies)
Discussion started by: jaapar
4 Replies

10. Shell Programming and Scripting

Match text to lines in a file, iterate backwards until text or text substring matches, print to file

hi all, trying this using shell/bash with sed/awk/grep I have two files, one containing one column, the other containing multiple columns (comma delimited). file1.txt abc12345 def12345 ghi54321 ... file2.txt abc1,text1,texta abc,text2,textb def123,text3,textc gh,text4,textd... (6 Replies)
Discussion started by: shogun1970
6 Replies

LEARN ABOUT DEBIAN

netris-sample-robot

netris-sample-robot(6)						Netris Sample Robot					    netris-sample-robot(6)

NAME

       netris-sample-robot - sample robot for netris

SYNOPSIS

       netris-sample-robot [-l]

DESCRIPTION

       The  netris-sample-robot is a sample implementation of the robot protocol. It plays quite well but isn't too hard to beat. The robot should
       be started from netris with the option -r to connect or wait for another player to join. You can also let  two  robots  play  against  each
       other in that way, if you like.

OPTIONS

       -l     Writes some log information into the file log in the current working directory. If it can't it bails out.

EXAMPLES

       To start the netris-sample-robot waiting for another connection with logfile use the following line:
	      netris -w -r 'netris-sample-robot -l'

       You then just have to start netris somewhere else which connects to that robot.

SEE ALSO

       netris(6)

BUGS

       One known bug of the netris-sample-robot is that it hangs quite often.  This was already filed as a bugreport against the package so please
       refrain from doing so again. If you have an idea why this happens or know a solution how to fix it feel free to mail us.

AUTHORS

       Netris was written by Mark H. Weaver <mhw@netris.org>.

       This manual page was written by Gerfried Fuchs <alfie@debian.org> for the Debian GNU/Linux system (but may be used by others).

0.5								    16 Feb 2002 					    netris-sample-robot(6)
All times are GMT -4. The time now is 09:17 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy