Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
split the values in url .......................
#1
Solved: 10 Years, 7 Months, 4 Weeks ago
hi

this is my URL which i got from getroproperty


https://cs11.salesforce.com/00QZ0000001J1zV when its fetched i need to split the last 15 characters after.com/

so any one please tell me that code for spliting


a=leadIDtable.GetROProperty("url")
'''' msgbox a
''''
'''' b=right(a,15)
'''' msgbox b
'''' datatable.Value("ID","IDlead")=b


Attached Files Image(s)
   
Reply
#2
Solved: 10 Years, 7 Months, 4 Weeks ago
Hi,
Try this

Code:
Dim a
strURL="https://cs11.salesforce.com/00QZ0000001J1zV"
a=Split(strURL,"/")
Msgbox Ubound(a)

Thanks,
Arul.D
Reply
#3
Solved: 10 Years, 7 Months, 4 Weeks ago
you can use below mentioned method also

Code:
dynamicstring=split(a,".com/")

msgbox dynamicstring(1)
Reply
#4
Solved: 10 Years, 7 Months, 4 Weeks ago
Modifying arul's post..

Code:
Dim a
strURL="https://cs11.salesforce.com/00QZ0000001J1zV"
a=Split(strURL,"/")
Msgbox a(Ubound(a))

Regards,
Ankesh
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Split function in string nidhishnair 13 63,195 07-07-2020, 03:47 PM
Last Post: helmzshelmz
Question Split Function Chaithra N 0 997 12-18-2019, 11:33 AM
Last Post: Chaithra N
  Split a string with multiple delimiters in VBScript nandha 2 7,882 02-10-2018, 06:44 PM
Last Post: nandha
  Problems with URL as Object identifier??? jcraig26 1 3,144 02-27-2013, 05:06 PM
Last Post: anil2u
  Split Function diya 2 5,518 11-28-2012, 08:49 PM
Last Post: diya

Forum Jump:


Users browsing this thread: 1 Guest(s)