Log in to post
|
Print Thread |
|
|
|
|
Post your own Tips and Tricks here
|
Joined: Oct 2008
Posts: 18,956
Veteran
|
OP
Veteran
Joined: Oct 2008
Posts: 18,956 |
The "Copy List" button is used to export a list of styles into a format that is readable by Excel. Once exported, these data open in Notepad. From there CTRL+A and then CTRL+C will copy all the data to the clipboard and it can be pasted (CTRL+V) directly into Excel. So that the data is interpreted properly, the following needs to occur. Firstly... Make sure that you only have "Tab" selected when asked about the delimiter/separator. Excel doesn't always make the best choice and it seems to also select other delimiters like space and/or comma. (The delimiter is what identifies each cell's data. The BIAB list is Tab-delimited.) Secondly... Once the data are pasted, scrolling down Column A will show a number entries that read "#Name?". This occurs with every style that begins with a "=". (See the original name in the formula bar.) This is because Excel uses the equals sign to indicate that what follows is a formula. To correct this... 1. Click on the "A" column header to select column A. 2. Press CTRL+F to open Find/Replace. 3. In the 'Find' box type in = 4. In the 'Replace' box type in '= The single quotation mark is used by Excel to say "interpret what follows as ordinary text." This character is found beneath the " character. It is not the character that is found beneath the "~" character.5. Select "Replace all" While the image below is using OpenOffice, the principle is the same in Excel. This will correct the "#NAME?" issue. Lastly, if the paste doesn't seem to work properly... If Excel assumes full control during the pasting process so that you cannot select Tab as the only delimiter. Try saving the Notepad file as a .txt file. Then open the .txt file in Excel. Regards, Noel
Last edited by Noel96; 06/26/16 04:48 AM.
MY SONGS...Audiophile BIAB 2024
|
|
|
|
|
|
|
|
|
|
|
|
Post your own Tips and Tricks here
|
Joined: Aug 2011
Posts: 10,149
Veteran
|
Veteran
Joined: Aug 2011
Posts: 10,149 |
Noel,
Thanks for taking the time to explain that. I wondered why I could never get a download to work correctly, now I know. I never thought to use the text identifier symbol. Duh!
Jim Fogle - 2024 BiaB (1111) RB (5) Ultra+ PAK DAWs: Cakewalk by BandLab (CbB) - Standalone: Zoom MRS-8 Laptop: i3 Win 10, 8GB ram 500GB HDD Desktop: i7 Win 11, 12GB ram 256GB SSD, 4 TB HDD Music at: https://fogle622.wix.com/fogle622-audio-home
|
|
|
|
|
|
|
|
|
|
|
|
Post your own Tips and Tricks here
|
Joined: Oct 2008
Posts: 18,956
Veteran
|
OP
Veteran
Joined: Oct 2008
Posts: 18,956 |
Hey Jim,
Glad it's useful information.
All the best, Noel
MY SONGS...Audiophile BIAB 2024
|
|
|
|
|
|
|
|
|
|
|
|
Post your own Tips and Tricks here
|
Joined: Aug 2014
Posts: 7,835
Veteran
|
Veteran
Joined: Aug 2014
Posts: 7,835 |
Awesome.
|
|
|
|
|
|
|
|
|
|
|
|
Ask sales and support questions about Band-in-a-Box using natural language.
ChatPG's knowledge base includes the full Band-in-a-Box User Manual and sales information from the website.
|
|
|
|
|
|
|
|
|
|
|
Band-in-a-Box® 2024 Italian for Windows is Here!
Ci siamo dati da fare e abbiamo aggiunto oltre 50 nuove funzionalità e una straordinaria raccolta di nuovi contenuti, tra cui 222 RealTracks, nuovi RealStyles, MIDI SuperTracks, Instrumental Studies, "Songs with Vocals" Artist Performance Sets, Playable RealTracks Set 3, Playable RealDrums Set 2, due nuovi set di "RealDrums Stems", XPro Styles PAK 6, Xtra Styles PAK 17 e altro ancora!
Tutti Pacchetti | Nuove Caratteristiche
Band-in-a-Box® 2024 French for Windows is Here!
Band-in-a-Box® 2024 apporte plus de 50 fonctions nouvelles ainsi qu'une importante de contenus nouveaux à savoir : 222 RealTracks, des RealStyles nouveaux, des SuperTracks MIDI, des Etudes d'Instruments, des Prestations d'Artistes, des "Morceaux avec Choeurs", un Set 3 de Tracks Jouables, un Set 2 de RealDrums Jouables, deux nouveaux Sets de "RealDrums Stems", des Styles XPro PAK 6, des Xtra Styles PAK 17 et bien plus encore!
Tous Packages | Nouvelles Fonctionnalités
Video: Making a Song with Band-in-a-Box®, ChatGPT, and Synth V
Take your Band-in-a-Box® project to a whole new level when you incorporate ChatGPT and Synth V to add lyrics and vocals to your song!
We wanted to demonstrate how this is done with our video, where we show you how to go from nothing to a finished "radio ready" modern pop song by combining the features of Band-in-a-Box®, ChatGPT, and Synth V!
Listen to the finished song, so you get a listen to the finished product: https://demos.pgmusic.com/misc/behindthefame.m4a
If you like it, watch the video. Either way, let's hear your comments!
Henry Clarke: Revolutionize Your Band-in-Box® Tracks with Regenerating Function
User Video: Next-Level AI Music Editing with ACE Studio and Band-in-a-Box®
Band-in-a-Box® 2024 German for Windows is Here!
Band-in-a-Box® 2024 für Windows Deutsch ist verfügbar!
Wir waren fleißig und haben über 50 neue Funktionen und eine erstaunliche Sammlung neuer Inhalte hinzugefügt, darunter 222 RealTracks, neue RealStyles, MIDI SuperTracks, Instrumental Studies, "Songs with Vocals" Artist Performance Sets, abspielbare RealTracks Set 3, abspielbare RealDrums Set 2, zwei neue Sets von "RealDrums Stems", XPro Styles PAK 6, Xtra Styles PAK 17 und mehr!
Paket | Was ist Neu
Update Your PowerTracks Pro Audio 2024 Today!
|
|
|
|
|
|
|
|
|
|
|
Forums66
Topics81,919
Posts738,851
Members38,616
|
Most Online2,537 Jan 19th, 2020
|
|
|
|
|
|
|
|
|