dont suppose you know the answer to this one as well ??

different vb question

[Edited by velohead66 - 11/5/2002 8:12:13 AM]

 

Say you have a variable called x that is different length of characters each time a next loop is run.
In VB how do you delete the last character.
eg change "20.00-" to "20.00"
and then change "20000.00z" to "20000.00"
on the next loop ????

NB1 Loop might run up to 1,000 times, as it passes down a column of figures
NB2 Character to be deleted will be a different character each time, but always in the same place.

PS-I could use excel functions mid.right,left etc, but I want the VB script please.

Ta

 

If you assign the result to a variable Y then:

y=left(x,len(x)-1))

Here, you are taking the length of the string minus one, and using this to return the left part of your string.

Hope that helps,

Martin.

 

Sounds good, I'll try at work tomorrow. Ta.