Add a hyphen before the last 3 characters of variable length string

LukeSnyder

Hi All. I'm looking for some VBScript help (or Python) to add a hyphen before the last 3 characters of variable length string. I can manage with fixed length strings, but not variable ones. 12345 = 12-345 and 123456 = 123-456.

Thanks in advance.

Luke

DanPatterson_Retired

got to love slicing  (EDIT  oooops Sorry Vince ... was playing and didn't see you had posted already)

>>> a = '123456'
>>> out = a[:len(a)-3]+'-'+a[len(a)-3:]
>>> out
'123-456'
>>> a = '12345'
>>> out = a[:len(a)-3]+'-'+a[len(a)-3:]
>>> out
'12-345'
>>>