concatenating string and variable

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

concatenating string and variable

Logged in as: Guest

arrSession:exec spGetSession 2,3,1464

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> concatenating string and variable
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

concatenating string and variable - 10/13/2004 7:04:39 AM

MsMope

Posts: 1
Score: 0
Joined: 10/13/2004
From: USA
Status: offline

Hello,
I am attempting to concatenate a variable (sID) and the letter "M" the code is as follows:
' Added by BRANDTR
' Category: Scripts for Dynamics and eEnterprise
' Script Type: field Script

'Retrieve the variable that was set in the "Before Integration" script' Added by the IM Script Library
' Category: Scripts for Dynamics and eEnterprise
' Script Type: field Script

sID = SourceFields("ModularDetails.ID")
sResult = ""
sModInvoice= ""
Do While Len(sID)>0

'Isolate the leftmost character of the sPhone string
sCharacter = Left(sID, 1)

'Test to determine whether that character is numeric
'If it is, then add it to the sResult string
If IsNumeric(sCharacter) then
sResult = sResult & sCharacter
End if

'Remove the leftmost character from sPhone and repeat until
'the entire sPhone string has been handled.
sID = Right(sID, Len(sID)-1)

Loop

sModInvoice= "M" & sresult
CurrentField = sresult

However, this does not integrate successfully, eventhough the field shows as M12345

Any suggestions?