Click here to Skip to main content
15,887,425 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
I would like to ask someone who can help me, I have one URL address which has the code below and i want to trim from string
https://scontent
to
rid=289298631140853
, so how can i do? please help me about it .

What I have tried:

<a href="https://scontent.xx.fbcdn.net/v/t39.25447-2/10000000_6431054706943551_3203837429521491984_n.mp4?_nc_cat=1&vs=9a2c9c3d6622741&_nc_vs=HBksFQAYJEdJQ1dtQUEtcGxhYkF0a1dBQkNvdXVBcVVYWXNibWRqQUFBRhUAAsgBABUAGCRHSk0xaGhWa3V4VWN1UFlBQUdvcWY0b2U4NEZ6YnY0R0FBQUYVAgLIAQBLB4gScHJvZ3Jlc3NpdmVfcmVjaXBlATENc3Vic2FtcGxlX2ZwcwAQdm1hZl9lbmFibGVfbnN1YgAgbWVhc3VyZV9vcmlnaW5hbF9yZXNvbHV0aW9uX3NzaW0AKGNvbXB1dGVfc3NpbV9vbmx5X2F0X29yaWdpbmFsX3Jlc29sdXRpb24AHXVzZV9sYW5jem9zX2Zvcl92cW1fdXBzY2FsaW5nABFkaXNhYmxlX3Bvc3RfcHZxcwAVACUAHIwXQAAAAAAAAAAREQAAACa8zIPgkNx0FQIoAkMzGAt2dHNfcHJldmlldxwXQILu5WBBiTcYIGRhc2hfdjRfNXNlY2dvcF9ocTJfZnJhZ18yX3ZpZGVvEgAYGHZpZGVvcy52dHMuY2FsbGJhY2sucHJvZDgSVklERU9fVklFV19SRVFVRVNUGwqIFW9lbV90YXJnZXRfZW5jb2RlX3RhZwZvZXBfaGQTb2VtX3JlcXVlc3RfdGltZV9tcwEwDG9lbV9jZmdfcnVsZQd1bm11dGVkE29lbV9yb2lfcmVhY2hfY291bnQGMTkwNTE0EW9lbV9pc19leHBlcmltZW50AAxvZW1fdmlkZW9faWQQMjc5MzEyOTkwNDE2MTk2OBJvZW1fdmlkZW9fYXNzZXRfaWQPMTA2MDM0OTkyNTczNzYzFW9lbV92aWRlb19yZXNvdXJjZV9pZA8yNTY2Njk0OTM3ODUzNzQcb2VtX3NvdXJjZV92aWRlb19lbmNvZGluZ19pZA8zMDkxMTk2NDgxNDU2ODQOdnRzX3JlcXVlc3RfaWQAJQIcACXEARsHiAFzBDgxODMCY2QKMjAyMy0wNy0yMANyY2IGMTkwNTAwA2FwcAVWaWRlbwJjdBlDT05UQUlORURfUE9TVF9BVFRBQ0hNRU5UE29yaWdpbmFsX2R1cmF0aW9uX3MHNjA1Ljg4OAJ0cxVwcm9ncmVzc2l2ZV9lbmNvZGluZ3MA&ccb=1-7&_nc_sid=f97d39&efg=eyJ2ZW5jb2RlX3RhZyI6Im9lcF9oZCJ9&_nc_eui2=AeGdgPDzwjLaSGTONQoxW_5viTB_e75YaNCJMH97vlho0Mj4EgsT0Pr_E4RSt7Q3odM&_nc_ohc=S1DrBydfcBcAX8ZoN97&_nc_ht=scontent.fpnh10-1.fna&oh=00_AfB6TOrRCm9tACMC2Bxrx7H57ItjPcZgbJSjFL9yhIELSQ&oe=64BF38C8&_nc_rid=289298631140853">https://scontent.xx.fbcdn.net/v/t39.25447-2/10000000_6431054706943551_3203837429521491984_n.mp4?_nc_cat=1&vs=9a2c9c3d6622741&_nc_vs=HBksFQAYJEdJQ1dtQUEtcGxhYkF0a1dBQkNvdXVBcVVYWXNibWRqQUFBRhUAAsgBABUAGCRHSk0xaGhWa3V4VWN1UFlBQUdvcWY0b2U4NEZ6YnY0R0FBQUYVAgLIAQBLB4gScHJvZ3Jlc3NpdmVfcmVjaXBlATENc3Vic2FtcGxlX2ZwcwAQdm1hZl9lbmFibGVfbnN1YgAgbWVhc3VyZV9vcmlnaW5hbF9yZXNvbHV0aW9uX3NzaW0AKGNvbXB1dGVfc3NpbV9vbmx5X2F0X29yaWdpbmFsX3Jlc29sdXRpb24AHXVzZV9sYW5jem9zX2Zvcl92cW1fdXBzY2FsaW5nABFkaXNhYmxlX3Bvc3RfcHZxcwAVACUAHIwXQAAAAAAAAAAREQAAACa8zIPgkNx0FQIoAkMzGAt2dHNfcHJldmlldxwXQILu5WBBiTcYIGRhc2hfdjRfNXNlY2dvcF9ocTJfZnJhZ18yX3ZpZGVvEgAYGHZpZGVvcy52dHMuY2FsbGJhY2sucHJvZDgSVklERU9fVklFV19SRVFVRVNUGwqIFW9lbV90YXJnZXRfZW5jb2RlX3RhZwZvZXBfaGQTb2VtX3JlcXVlc3RfdGltZV9tcwEwDG9lbV9jZmdfcnVsZQd1bm11dGVkE29lbV9yb2lfcmVhY2hfY291bnQGMTkwNTE0EW9lbV9pc19leHBlcmltZW50AAxvZW1fdmlkZW9faWQQMjc5MzEyOTkwNDE2MTk2OBJvZW1fdmlkZW9fYXNzZXRfaWQPMTA2MDM0OTkyNTczNzYzFW9lbV92aWRlb19yZXNvdXJjZV9pZA8yNTY2Njk0OTM3ODUzNzQcb2VtX3NvdXJjZV92aWRlb19lbmNvZGluZ19pZA8zMDkxMTk2NDgxNDU2ODQOdnRzX3JlcXVlc3RfaWQAJQIcACXEARsHiAFzBDgxODMCY2QKMjAyMy0wNy0yMANyY2IGMTkwNTAwA2FwcAVWaWRlbwJjdBlDT05UQUlORURfUE9TVF9BVFRBQ0hNRU5UE29yaWdpbmFsX2R1cmF0aW9uX3MHNjA1Ljg4OAJ0cxVwcm9ncmVzc2l2ZV9lbmNvZGluZ3MA&ccb=1-7&_nc_sid=f97d39&efg=eyJ2ZW5jb2RlX3RhZyI6Im9lcF9oZCJ9&_nc_eui2=AeGdgPDzwjLaSGTONQoxW_5viTB_e75YaNCJMH97vlho0Mj4EgsT0Pr_E4RSt7Q3odM&_nc_ohc=S1DrBydfcBcAX8ZoN97&_nc_ht=scontent.fpnh10-1.fna&oh=00_AfB6TOrRCm9tACMC2Bxrx7H57ItjPcZgbJSjFL9yhIELSQ&oe=64BF38C8&_nc_rid=289298631140853</a>[<a href="https://scontent.xx.fbcdn.net/v/t39.25447-2/10000000_6431054706943551_3203837429521491984_n.mp4?_nc_cat=1&vs=9a2c9c3d6622741&_nc_vs=HBksFQAYJEdJQ1dtQUEtcGxhYkF0a1dBQkNvdXVBcVVYWXNibWRqQUFBRhUAAsgBABUAGCRHSk0xaGhWa3V4VWN1UFlBQUdvcWY0b2U4NEZ6YnY0R0FBQUYVAgLIAQBLB4gScHJvZ3Jlc3NpdmVfcmVjaXBlATENc3Vic2FtcGxlX2ZwcwAQdm1hZl9lbmFibGVfbnN1YgAgbWVhc3VyZV9vcmlnaW5hbF9yZXNvbHV0aW9uX3NzaW0AKGNvbXB1dGVfc3NpbV9vbmx5X2F0X29yaWdpbmFsX3Jlc29sdXRpb24AHXVzZV9sYW5jem9zX2Zvcl92cW1fdXBzY2FsaW5nABFkaXNhYmxlX3Bvc3RfcHZxcwAVACUAHIwXQAAAAAAAAAAREQAAACa8zIPgkNx0FQIoAkMzGAt2dHNfcHJldmlldxwXQILu5WBBiTcYIGRhc2hfdjRfNXNlY2dvcF9ocTJfZnJhZ18yX3ZpZGVvEgAYGHZpZGVvcy52dHMuY2FsbGJhY2sucHJvZDgSVklERU9fVklFV19SRVFVRVNUGwqIFW9lbV90YXJnZXRfZW5jb2RlX3RhZwZvZXBfaGQTb2VtX3JlcXVlc3RfdGltZV9tcwEwDG9lbV9jZmdfcnVsZQd1bm11dGVkE29lbV9yb2lfcmVhY2hfY291bnQGMTkwNTE0EW9lbV9pc19leHBlcmltZW50AAxvZW1fdmlkZW9faWQQMjc5MzEyOTkwNDE2MTk2OBJvZW1fdmlkZW9fYXNzZXRfaWQPMTA2MDM0OTkyNTczNzYzFW9lbV92aWRlb19yZXNvdXJjZV9pZA8yNTY2Njk0OTM3ODUzNzQcb2VtX3NvdXJjZV92aWRlb19lbmNvZGluZ19pZA8zMDkxMTk2NDgxNDU2ODQOdnRzX3JlcXVlc3RfaWQAJQIcACXEARsHiAFzBDgxODMCY2QKMjAyMy0wNy0yMANyY2IGMTkwNTAwA2FwcAVWaWRlbwJjdBlDT05UQUlORURfUE9TVF9BVFRBQ0hNRU5UE29yaWdpbmFsX2R1cmF0aW9uX3MHNjA1Ljg4OAJ0cxVwcm9ncmVzc2l2ZV9lbmNvZGluZ3MA&ccb=1-7&_nc_sid=f97d39&efg=eyJ2ZW5jb2RlX3RhZyI6Im9lcF9oZCJ9&_nc_eui2=AeGdgPDzwjLaSGTONQoxW_5viTB_e75YaNCJMH97vlho0Mj4EgsT0Pr_E4RSt7Q3odM&_nc_ohc=S1DrBydfcBcAX8ZoN97&_nc_ht=scontent.fpnh10-1.fna&oh=00_AfB6TOrRCm9tACMC2Bxrx7H57ItjPcZgbJSjFL9yhIELSQ&oe=64BF38C8&_nc_rid=289298631140853" target="_blank" title="New Window">^</a>]
Posted
Updated 21-Jul-23 0:32am

Expanding on @OriginalGriff solution ....

Once you have the url, you need to clean/decode and then parse the QueryString part of the URL.

1. Decode
VB
Dim rawUrl = "https://scontent.xx.fbcdn.net/v/t39.25447-2/10000000_6431054706943551_3203837429521491984_n.mp4?_nc_cat=1&vs=9a2c9c3d6622741&_nc_vs=HBksFQAYJEdJQ1dtQUEtcGxhYkF0a1dBQkNvdXVBcVVYWXNibWRqQUFBRhUAAsgBABUAGCRHSk0xaGhWa3V4VWN1UFlBQUdvcWY0b2U4NEZ6YnY0R0FBQUYVAgLIAQBLB4gScHJvZ3Jlc3NpdmVfcmVjaXBlATENc3Vic2FtcGxlX2ZwcwAQdm1hZl9lbmFibGVfbnN1YgAgbWVhc3VyZV9vcmlnaW5hbF9yZXNvbHV0aW9uX3NzaW0AKGNvbXB1dGVfc3NpbV9vbmx5X2F0X29yaWdpbmFsX3Jlc29sdXRpb24AHXVzZV9sYW5jem9zX2Zvcl92cW1fdXBzY2FsaW5nABFkaXNhYmxlX3Bvc3RfcHZxcwAVACUAHIwXQAAAAAAAAAAREQAAACa8zIPgkNx0FQIoAkMzGAt2dHNfcHJldmlldxwXQILu5WBBiTcYIGRhc2hfdjRfNXNlY2dvcF9ocTJfZnJhZ18yX3ZpZGVvEgAYGHZpZGVvcy52dHMuY2FsbGJhY2sucHJvZDgSVklERU9fVklFV19SRVFVRVNUGwqIFW9lbV90YXJnZXRfZW5jb2RlX3RhZwZvZXBfaGQTb2VtX3JlcXVlc3RfdGltZV9tcwEwDG9lbV9jZmdfcnVsZQd1bm11dGVkE29lbV9yb2lfcmVhY2hfY291bnQGMTkwNTE0EW9lbV9pc19leHBlcmltZW50AAxvZW1fdmlkZW9faWQQMjc5MzEyOTkwNDE2MTk2OBJvZW1fdmlkZW9fYXNzZXRfaWQPMTA2MDM0OTkyNTczNzYzFW9lbV92aWRlb19yZXNvdXJjZV9pZA8yNTY2Njk0OTM3ODUzNzQcb2VtX3NvdXJjZV92aWRlb19lbmNvZGluZ19pZA8zMDkxMTk2NDgxNDU2ODQOdnRzX3JlcXVlc3RfaWQAJQIcACXEARsHiAFzBDgxODMCY2QKMjAyMy0wNy0yMANyY2IGMTkwNTAwA2FwcAVWaWRlbwJjdBlDT05UQUlORURfUE9TVF9BVFRBQ0hNRU5UE29yaWdpbmFsX2R1cmF0aW9uX3MHNjA1Ljg4OAJ0cxVwcm9ncmVzc2l2ZV9lbmNvZGluZ3MA&ccb=1-7&_nc_sid=f97d39&efg=eyJ2ZW5jb2RlX3RhZyI6Im9lcF9oZCJ9&_nc_eui2=AeGdgPDzwjLaSGTONQoxW_5viTB_e75YaNCJMH97vlho0Mj4EgsT0Pr_E4RSt7Q3odM&_nc_ohc=S1DrBydfcBcAX8ZoN97&_nc_ht=scontent.fpnh10-1.fna&oh=00_AfB6TOrRCm9tACMC2Bxrx7H57ItjPcZgbJSjFL9yhIELSQ&oe=64BF38C8&_nc_rid=289298631140853"
Dim decodedUrl As String = WebUtility.HtmlDecode(rawUrl)

I have manually pulled the url so we have something to work with.

2.Next is to get the QueryString
VB
Dim uri = New Uri(decodedUrl)
Dim queryString = HttpUtility.ParseQueryString(uri.Query)

3. Now that we have the QueryString we can easily access the key/value pairs
VB
For Each key As String In queryString.Keys
    Console.WriteLine($"{key} = {queryString.Item(key)}")
Next

And here is the output:
_nc_cat = 1
vs = 9a2c9c3d6622741
_nc_vs = HBksFQAYJEdJQ1dtQUEtcGxhYkF0a1dBQkNvdXVBcVVYWXNibWRqQUFBRhUAAsgBABUAGCRHSk0xaGhWa3V4VWN1UFlBQUdvcWY0b2U4NEZ6YnY0R0FBQUYVAgLIAQBLB4gScHJvZ3Jlc3NpdmVfcmVjaXBlATENc3Vic2FtcGxlX2ZwcwAQdm1hZl9lbmFibGVfbnN1YgAgbWVhc3VyZV9vcmlnaW5hbF9yZXNvbHV0aW9uX3NzaW0AKGNvbXB1dGVfc3NpbV9vbmx5X2F0X29yaWdpbmFsX3Jlc29sdXRpb24AHXVzZV9sYW5jem9zX2Zvcl92cW1fdXBzY2FsaW5nABFkaXNhYmxlX3Bvc3RfcHZxcwAVACUAHIwXQAAAAAAAAAAREQAAACa8zIPgkNx0FQIoAkMzGAt2dHNfcHJldmlldxwXQILu5WBBiTcYIGRhc2hfdjRfNXNlY2dvcF9ocTJfZnJhZ18yX3ZpZGVvEgAYGHZpZGVvcy52dHMuY2FsbGJhY2sucHJvZDgSVklERU9fVklFV19SRVFVRVNUGwqIFW9lbV90YXJnZXRfZW5jb2RlX3RhZwZvZXBfaGQTb2VtX3JlcXVlc3RfdGltZV9tcwEwDG9lbV9jZmdfcnVsZQd1bm11dGVkE29lbV9yb2lfcmVhY2hfY291bnQGMTkwNTE0EW9lbV9pc19leHBlcmltZW50AAxvZW1fdmlkZW9faWQQMjc5MzEyOTkwNDE2MTk2OBJvZW1fdmlkZW9fYXNzZXRfaWQPMTA2MDM0OTkyNTczNzYzFW9lbV92aWRlb19yZXNvdXJjZV9pZA8yNTY2Njk0OTM3ODUzNzQcb2VtX3NvdXJjZV92aWRlb19lbmNvZGluZ19pZA8zMDkxMTk2NDgxNDU2ODQOdnRzX3JlcXVlc3RfaWQAJQIcACXEARsHiAFzBDgxODMCY2QKMjAyMy0wNy0yMANyY2IGMTkwNTAwA2FwcAVWaWRlbwJjdBlDT05UQUlORURfUE9TVF9BVFRBQ0hNRU5UE29yaWdpbmFsX2R1cmF0aW9uX3MHNjA1Ljg4OAJ0cxVwcm9ncmVzc2l2ZV9lbmNvZGluZ3MA
ccb = 1-7
_nc_sid = f97d39
efg = eyJ2ZW5jb2RlX3RhZyI6Im9lcF9oZCJ9
_nc_eui2 = AeGdgPDzwjLaSGTONQoxW_5viTB_e75YaNCJMH97vlho0Mj4EgsT0Pr_E4RSt7Q3odM
_nc_ohc = S1DrBydfcBcAX8ZoN97
_nc_ht = scontent.fpnh10-1.fna
oh = 00_AfB6TOrRCm9tACMC2Bxrx7H57ItjPcZgbJSjFL9yhIELSQ
oe = 64BF38C8
_nc_rid = 289298631140853

Note: I created a .NetFramework 4.7.1 console app and added the NuGet Gallery | NETStandard.Library 2.0.3[^] library for the HttpUtility.ParseQueryString[^].

Here is the complete code:
VB.NET
Imports System.Net
Imports System.Web

Module Module1

    Sub Main()

        Dim rawUrl = "https://scontent.xx.fbcdn.net/v/t39.25447-2/10000000_6431054706943551_3203837429521491984_n.mp4?_nc_cat=1&vs=9a2c9c3d6622741&_nc_vs=HBksFQAYJEdJQ1dtQUEtcGxhYkF0a1dBQkNvdXVBcVVYWXNibWRqQUFBRhUAAsgBABUAGCRHSk0xaGhWa3V4VWN1UFlBQUdvcWY0b2U4NEZ6YnY0R0FBQUYVAgLIAQBLB4gScHJvZ3Jlc3NpdmVfcmVjaXBlATENc3Vic2FtcGxlX2ZwcwAQdm1hZl9lbmFibGVfbnN1YgAgbWVhc3VyZV9vcmlnaW5hbF9yZXNvbHV0aW9uX3NzaW0AKGNvbXB1dGVfc3NpbV9vbmx5X2F0X29yaWdpbmFsX3Jlc29sdXRpb24AHXVzZV9sYW5jem9zX2Zvcl92cW1fdXBzY2FsaW5nABFkaXNhYmxlX3Bvc3RfcHZxcwAVACUAHIwXQAAAAAAAAAAREQAAACa8zIPgkNx0FQIoAkMzGAt2dHNfcHJldmlldxwXQILu5WBBiTcYIGRhc2hfdjRfNXNlY2dvcF9ocTJfZnJhZ18yX3ZpZGVvEgAYGHZpZGVvcy52dHMuY2FsbGJhY2sucHJvZDgSVklERU9fVklFV19SRVFVRVNUGwqIFW9lbV90YXJnZXRfZW5jb2RlX3RhZwZvZXBfaGQTb2VtX3JlcXVlc3RfdGltZV9tcwEwDG9lbV9jZmdfcnVsZQd1bm11dGVkE29lbV9yb2lfcmVhY2hfY291bnQGMTkwNTE0EW9lbV9pc19leHBlcmltZW50AAxvZW1fdmlkZW9faWQQMjc5MzEyOTkwNDE2MTk2OBJvZW1fdmlkZW9fYXNzZXRfaWQPMTA2MDM0OTkyNTczNzYzFW9lbV92aWRlb19yZXNvdXJjZV9pZA8yNTY2Njk0OTM3ODUzNzQcb2VtX3NvdXJjZV92aWRlb19lbmNvZGluZ19pZA8zMDkxMTk2NDgxNDU2ODQOdnRzX3JlcXVlc3RfaWQAJQIcACXEARsHiAFzBDgxODMCY2QKMjAyMy0wNy0yMANyY2IGMTkwNTAwA2FwcAVWaWRlbwJjdBlDT05UQUlORURfUE9TVF9BVFRBQ0hNRU5UE29yaWdpbmFsX2R1cmF0aW9uX3MHNjA1Ljg4OAJ0cxVwcm9ncmVzc2l2ZV9lbmNvZGluZ3MA&ccb=1-7&_nc_sid=f97d39&efg=eyJ2ZW5jb2RlX3RhZyI6Im9lcF9oZCJ9&_nc_eui2=AeGdgPDzwjLaSGTONQoxW_5viTB_e75YaNCJMH97vlho0Mj4EgsT0Pr_E4RSt7Q3odM&_nc_ohc=S1DrBydfcBcAX8ZoN97&_nc_ht=scontent.fpnh10-1.fna&oh=00_AfB6TOrRCm9tACMC2Bxrx7H57ItjPcZgbJSjFL9yhIELSQ&oe=64BF38C8&_nc_rid=289298631140853"
        Dim decodedUrl As String = WebUtility.HtmlDecode(rawUrl)
        Dim uri = New Uri(decodedUrl)
        Dim queryString = HttpUtility.ParseQueryString(uri.Query)
        For Each key As String In queryString.Keys
            Console.WriteLine($"{key} = {queryString.Item(key)}")
        Next

    End Sub

End Module
 
Share this answer
 
v2
Comments
Mr.Kim2050 21-Jul-23 9:51am    
it seem not works well, can you propose other solution ?
Graeme_Grant 21-Jul-23 9:58am    
I have posted the complete console app. It works. I show you the output. I also show you how to do it in 3 lines of code.

Create a new console application, add the nuget package mention, then copy and paste the code. Once done, compile and run and you will see the same as I have shown above, like you are not wanting the rid field, you want the _nc_rid field from the URL given in your example.

Did you add the nuget package?
Did you use a valid URL that would work if posted in a web browser?
Did you use the html that contains the URL as the URL??? You need to extract the URL, I was clear about that.

What does not work? Be specific! If there is a error, post the full error message.
You have to extract the requested substring; an effective way for accomplishing such a task is using regular expressions. See .NET Regular Expressions | Microsoft Learn[^].
 
Share this answer
 
I'd use the HtmlAgility Pack and parse the whole HTML document: it can extract individual attributes for a particular tag on a page.
Visual Studio Package manager will find and install it for you, and there is loads of stuff on the net about how to use it.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900