Substitute Blank Space During Print Follow

0
Avatar
Legacy Poster

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

4 comments

0
Avatar
Shotaro Ito
Comment actions Permalink

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
Avatar
Legacy Poster
Comment actions Permalink

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
Avatar
Shotaro Ito
Comment actions Permalink

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
Avatar
Legacy Poster
Comment actions Permalink

Shotaro,

Thanx!
all your suggestions worked brilliantly.
your help is much appreciated

regards
Pervez

Please sign in to leave a comment.