How can I make a automatic import with this CSV information available?
Product reference number: 1742366
Outcome must be in long description like this:
Nr. 1 Show Me A Leader - Alter Bridge - Side1 - Duration 5:05 (etc. etc for the lines below)
Nr. 2 The Writing On The Wall - Alter Bridge - Side1 4:28
Nr. 3 The Other Side - Alter Bridge - Side1 5:55
4 My Champion - Alter Bridge 1 4:41
5 Poison In Your Veins - Alter Bridge 1 4:19
6 Cradle To The Grave - Alter Bridge 1 5:41
7 Losing Patience - Alter Bridge 1 4:10
1 This Side Of Fate - Alter Bridge 2 6:48
2 You Will Be Remembered - Alter Bridge 2 4:42
3 Crows On A Wire - Alter Bridge 2 4:27
4 Twilight - Alter Bridge 2 4:15
5 Island Of Fools - Alter Bridge 2 5:01
6 The Last Hero - Alter Bridge 2 6:42
7 Last Of Our Kind (Bonus Track) - Alter Bridge 2 5:34
Product reference number: 1742367
Nr. 1 Show Me A Leader - Alter Bridge - Side1 - Duration 5:05 (etc(etc for the lines below)
2 The Writing On The Wall - Alter Bridge 1 4:28
3 The Other Side - Alter Bridge 1 5:55
4 My Champion - Alter Bridge 1 4:41
5 Poison In Your Veins - Alter Bridge 1 4:19
6 Cradle To The Grave - Alter Bridge 1 5:41
7 Losing Patience - Alter Bridge 1 4:10
1 This Side Of Fate - Alter Bridge 2 6:48
2 You Will Be Remembered - Alter Bridge 2 4:42
3 Crows On A Wire - Alter Bridge 2 4:27
4 Twilight - Alter Bridge 2 4:15
5 Island Of Fools - Alter Bridge 2 5:01
6 The Last Hero - Alter Bridge 2 6:42
7 Last Of Our Kind (Bonus Track) - Alter Bridge 2 5:34
Product reference number: 1742368
Etc. etc.
This far is my knowledge about SQL
"Nr. "[CSV_COL(2)] " - " [CSV_COL(3)] " - Side " [CSV_COL(4)] " - Time " [CSV_COL(5)]
Are you working in Excel or Open/LibreOffice?
On the image it's exactly what I need!! :>))
I'll try it testing a soon as possible because i'm get
every day more the 100 new LP's available!!
Bye,
Jos...
Oct 21, 2016
Joswrote
Hi Volodymyr,
What is it that I'm doing wrong here (file included).