Skip to main content

Search

Search

Left Trim Leading Zeroes

Comments

1 comment

  • Avatar
    Shotaro Ito
    [quote name='AquaDN' timestamp='1336758615' post='2394']
    On my label (.btw) there is a character (alpha) database field that contains numbers. I would like to remove all leading zeroes and when the label is printed, only the true numeric value is printed.
    [/quote]
    For BarTender 10, On the datasource, change data type to "Number". You can apply various number format.

    For BarTender 9.4 or older, you need a tiny bit of scripting -
    Create a text with database field source. Datasource tab > More Options > VB Script > OnProcessData event, apply this
    [code]If IsNumeric(Value) Then Value = 0 + Value[/code]

    Hope that helps!
    0

Please sign in to leave a comment.