G
Guest
How do I trim the "Source_" from Source_Mydata value.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
fredg
How do I trim the "Source_" from Source_Mydata value.
NewStringRight = Mid(OldString,InStr(OldString,"_")+1)
NewStringLeft = Left(OldString,InStr(OldString,"_")-1)
G
Guest
More specifically, I want to trim "Source_" from Source_02-06 Audio Center
download
download
G
Guest
x = "Source_02-06 Audio Center download"
x=right(x,len(x) - instr(x,"_"))
x=right(x,len(x) - instr(x,"_"))
D
Douglas J. Steele
Or, perhaps simpler,
x = "Source_02-06 Audio Center download"
x = Mid(x, InStr(x, "_") + 1)
x = "Source_02-06 Audio Center download"
x = Mid(x, InStr(x, "_") + 1)