Importing Data

[purceld2]

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

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

 

[jdellasala]

Don't see the line breaks in the 2nd picture, but if there ARE actually line breaks, right click on the column and select Replace Values and use the Replace using special characters under Advanced options to specify a line break #(lf). If that doesn't work, try Carriage Return, Carriage Return and Line Feed, and Non-breaking space (the worst of the lot!).