Excel - RS field split from MS List

[Scotster]

I have a list setup in Sharepoint that holds links to various resources. In MS Lists itself, everything appears fine. Each record has a title and a URL option, each being limited to 255 characters.

When viewing through ADODB in Excel the record comes through truncated with the maximum characters being 255 combined total for the title & url. This means that I cannot display the full title when the combination exceeds this total.

Is there a way of splitting the data during the pull via ADODB?

The pull or the record looks like this

rs.Fields("Available Links")

And the output is

Title#http://www.websiteorfilelink.com#

I was wondering if there was an extension that I could use to pull them separately, as an example

rs.Fields("Available Links").title
rs.Fields("Available Links").url

If I access the list using "Get Data" in Excel it all pulls through fine, but I want to be able to upload the information as well, without hitting the 255 limit on upload.

Many thanks

 

[bobsan42]

you can make your own class for this.
Or you can split by #:

    av = Split(rs.Fields("Available Links"), "#")
    avTitle = av(0)
    avLink = av(1)