Page 1 of 1

merging two songs

Posted: Thu Feb 16, 2012 12:33 pm
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?

Posted: Thu Feb 16, 2012 1:32 pm
by Sebastian
No, unfortunately not.

Posted: Mon Mar 26, 2012 10:35 pm
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.