Hi
I have a issue importing data from a text file.
After analysing the data that has been exported from program into a Txt file The program is reporting duplicate audio files issue is it reports them on one line in the Txt file (see below)
H:\New Music Library\000 Music Selected To Play WhatsApp Group\Aretha Franklin\15 - Oh No Not My Baby.mp3 H:\New Music Library\New CD\11. 11 Oh No Not My Baby.mp3 H:\New Music Library\0000 New Music Feb 2021 No 5\Oh No Not My Baby.mp3
When I attempt to import into a spreadsheet I would like imported as displayed below
I have Office 2021 and no matter what I try it imports as follows
I note form the data that the line braks are either 2 spaces or the H:\ string. How can I get it to work on this basis?
Regards
Desmond
I have a issue importing data from a text file.
After analysing the data that has been exported from program into a Txt file The program is reporting duplicate audio files issue is it reports them on one line in the Txt file (see below)
H:\New Music Library\000 Music Selected To Play WhatsApp Group\Aretha Franklin\15 - Oh No Not My Baby.mp3 H:\New Music Library\New CD\11. 11 Oh No Not My Baby.mp3 H:\New Music Library\0000 New Music Feb 2021 No 5\Oh No Not My Baby.mp3
When I attempt to import into a spreadsheet I would like imported as displayed below
Duplicate Export Perfect Tunes.xlsx | |||
---|---|---|---|
A | |||
1 | H:\New Music Library\000 Music Selected To Play WhatsApp Group\Aretha Franklin\15 - Oh No Not My Baby.mp3 | ||
2 | H:\New Music Library\New CD\11. 11 Oh No Not My Baby.mp3 | ||
3 | H:\New Music Library\0000 New Music Feb 2021 No 5\Oh No Not My Baby.mp3 | ||
4 | H:\New Music Library\test\Aretha Franklin - Oh No Not My Baby.mp3 | ||
5 | H:\New Music Library\test\Aretha Franklin - Oh No Not My Baby - 1.mp3 | ||
6 | H:\New Music Library\0000 New Music Feb 2021 No 5\Aretha Franklin - Oh No Not My Baby.mp3 | ||
Sheet1_Transpose1 |
I have Office 2021 and no matter what I try it imports as follows
Duplicate Export Perfect Tunes.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | ||
2 | H:\New Music Library\000 Music Selected To Play WhatsApp Group\Aretha Franklin\15 - Oh No Not My Baby.mp3 | H:\New Music Library\New CD\11. 11 Oh No Not My Baby.mp3 | H:\New Music Library\0000 New Music Feb 2021 No 5\Oh No Not My Baby.mp3 | H:\New Music Library\test\Aretha Franklin - Oh No Not My Baby.mp3 | H:\New Music Library\test\Aretha Franklin - Oh No Not My Baby - 1.mp3 | H:\New Music Library\0000 New Music Feb 2021 No 5\Aretha Franklin - Oh No Not My Baby.mp3 | ||
_AREE8 tmp |
I note form the data that the line braks are either 2 spaces or the H:\ string. How can I get it to work on this basis?
Regards
Desmond