Substitute Blank Space During Print

Legacy Poster

• January 10, 2012 22:09

Hi

I currently retrieve my data from an Excel File
the Data is in the foll format:

ABC123%10000-001%15.4

the " % " is a delimiter.

During printing how do I substitute a " blank " space instead of the " % " ?

so the TEXT printed would be as: ABC123 10000-001 15.4

I have checked the HELP and the More Options tab in Data Source

any help appreciated

regards

Pervez

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • January 11, 2012 01:32
  Hi Pervez,
  There's a handy VB script function - Replace.
  In More options > VB Script, enable VB Script and select OnProcessData event. set script below:
  [code]Value = Replace(Value, "%", " ")[/code]
  Hope that helps.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • January 11, 2012 03:21
  Hi Shotaro,
  
  I tried the VB Script you mentioned but it has 1 problem which I did not explain clearly.
  
  I still need the "%" delimiters in the Barcode.
  I only want them replaced in the printed Text below the Barcode.
  the barcode must still be in the format
  ABC123%12345-001%15.4
  
  only during printing on the Label, I want the Text to display
  ABC123 12345-001 15.4
  
  regards
  Pervez

  0
• 

  Shotaro Ito

  ★ BarTender Hero ★

  • January 11, 2012 03:49
  In that case you need to mock human readable text by another text object.
  For the barcode, on Human readable tab, set Visibility to none.
  Create a text below barcode. Select datasource as Label object string of Human readable of the barcode. ("Bar code 1" etc.)
  On the text's more options, you can apply VB Script above.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • January 11, 2012 04:49
  Shotaro,
  
  Thanx!
  all your suggestions worked brilliantly.
  your help is much appreciated
  
  regards
  Pervez

  0

Please sign in to leave a comment.