• Home
 · 
• String Manipulation
 · 
• String trimmer

String trimmer

Just a little snip of code that lets you trim a specified number of characters from either side of a string.

Inputs
Inputs are (in order): data to trim from, number of characters from left side, number of characters from right side

Returns
The new string, w/o trimmed characters

Rate String trimmer

• 1
• 2
• 3
• 4
• 5

(3(3 Vote))

Function trim_data(data As String, from_left As Integer, from_right As Integer) As String
  'If you try to trim to much, returns an empty string
  If Len(data) <= from_left + from_right Then
    trim_data = ""
  'If not, trim text from sides and return
  Else
    trim_data = Mid(data, from_left + 1, Len(data) - from_left - from_right)
  End If
End Function