merging two songs

Everything about SongBeamer
Post Reply
JesusHaus
Posts: 1
Joined: Thu Feb 16, 2012 12:30 pm
Location: Herrnhut, Germany
Contact:

merging two songs

Post by JesusHaus »

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?
Sebastian
SongBeamer
Posts: 208
Joined: Sat Apr 22, 2006 10:58 pm

Post by Sebastian »

No, unfortunately not.
Juggledad
Posts: 27
Joined: Sun Jun 04, 2006 7:23 pm
Location: Massachusetts, USA

Post by Juggledad »

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.
Post Reply