Strip hostname from field 1

[penguin69]

Here is my code,

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open Application("SourceFile_ConnectionString") 
Set RS = Conn.Execute ("SELECT * From input.csv")

Dim iCnt
Do Until RS.EOF
iCnt = iCnt + 1
message = RS("message")
	author = RS("author")
	phone = RS("phone")
	email = RS("email")
	picture = RS("picture")
	category = RS("category")
	
RS.MoveNext
Loop
RS.Close
Conn.Close
%>

After picture is read from CSV file, I need to trim the string but keep the same variable name.

http://hostname.domain.org/folder1/folder2/folder3/picture.jpg

would end up as

folder3/picture.jpg

I couldn't thank you enough for any assistance....

Ken

 

[PHV]

One way:

' picture="[URL unfurl="true"]http://hostname.domain.org/folder1/folder2/folder3/picture.jpg"[/URL]
a=Split(picture,"/")
u=UBound(a)
strippedpicture=a(u-1) & "/" & a(u)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[penguin69]

Works perfectly. Thanks so much!