SongBeamer Forums Forum Index SongBeamer Forums

 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

merging two songs

 
Post new topic   Reply to topic    SongBeamer Forums Forum Index -> General
View previous topic :: View next topic  
Author Message
JesusHaus



Joined: 16 Feb 2012
Posts: 1
Location: Herrnhut, Germany

PostPosted: Thu Feb 16, 2012 12:33 pm    Post subject: merging two songs Reply with quote

Is there an easier way to merge the separate SongSelect files for the German version of a song and the English version of a song than copying and pasting each line one at a time?
Back to top
View user's profile Send private message Visit poster's website
Sebastian
SongBeamer


Joined: 22 Apr 2006
Posts: 198

PostPosted: Thu Feb 16, 2012 1:32 pm    Post subject: Reply with quote

No, unfortunately not.
Back to top
View user's profile Send private message Send e-mail
Juggledad



Joined: 04 Jun 2006
Posts: 27
Location: Massachusetts, USA

PostPosted: Mon Mar 26, 2012 10:35 pm    Post subject: Reply with quote

This may be late but you could speed it up by doing the following
edit the english version and make sure each line ends with a carridge rturn.
copy all the lines from the file
open an spreadsheet
paste the lines into the spreadsheet. This should cause each line to become a row in one column of the spreadsheet

do the same for the Greman version but put them in a new spread sheet.

next add a new column as the first column and paste a incrimental set of numbers in so line one is 1, line two is 2 etc. do this to both spreadsheets.

so you will have something line
1 english line 1
2 english line 2
3 english line 3

and the other spreadsheet will be
1 german line 1
2 german line 2
3 german line 3

Next copy the german spreadsheet into the english one so you will have
1 english line 1
2 english line 2
3 english line 3
1 german line 1
2 german line 2
3 german line 3

Now sort the spread sheet on column A and you will have
1 english line 1
1 german line 1
2 english line 2
2 german line 2
3 english line 3
3 german line 3

now you can copy column b and paste it into a text document and you will ahve your english line and then a german line.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    SongBeamer Forums Forum Index -> General All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group