Truncate if first 10characters in text string are digits

Steven Hou

• August 14, 2023 09:38
• Edited

Hi,
In a field we print a text string. Sometimes the first 10 characters are numerical and I'd like to strip these away from printing. 

I understand this can be done using VB scripting but am very novice in this area. 
I might be on to something here but it's incorrect. What's wrong? Maybe I need a If-Then statement?

If IsNumeric(Left(String,10)) Then
   Replace(Left(String,10, Find, "")
End If

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • August 15, 2023 08:04

  If it is just alpha characters you want to print you could use the Truncation>Character Filter> Alpha only option instead

  

  0
• 

  Steven Hou

  ★ BarTender Hero ★

  • August 15, 2023 09:52

  Nevermind.. I solved it :)

   

  If IsNumeric(Left(Format.NamedSubStrings("BlanksH").Value,10)) Then
     BlanksH = Mid(Format.NamedSubStrings("BlanksH").Value, 11)
  End If

  1

Please sign in to leave a comment.