How to read string and get data from particular value using VBScript

Question

I have below string.

Message GID=1191539226 ID=1191539226-1

How do you retrieve the id value 1191539226-1 only using vbscript split

I used solution given by Ekkehard.Horner

AdrieanKhisbe · Accepted Answer · 2015-04-07 14:26:18Z

1

You can use the split function:

Split(expression[,delimiter[,count[,compare]]])

Default delimiter is a space, so can most easily do this in 2 steps, the first to get ID=1191539226-1, and the second to split on =

For your example:

input = "Message GID=1191539226 ID=1191539226-1"
a = Split(input)
b = Split(a(2), "=")
result = b(1)

AdrieanKhisbe

4,0688 gold badges40 silver badges45 bronze badges

answered Apr 7, 2015 at 14:06

sprague44

1411 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ekkehard.Horner · Accepted Answer · 2015-04-07 14:06:07Z

0

You want the last part separated by "=". So:

>> s = "Message GID=1191539226 ID=1191539226-1"
>> a = Split(s, "=")
>> WScript.Echo a(Ubound(a))
>>
1191539226-1
>>

answered Apr 7, 2015 at 14:06

Ekkehard.Horner

38.8k2 gold badges50 silver badges101 bronze badges