Substitute Blank Space During Print フォローする
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 コメント
0

Shotaro Ito
コメントアクション
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.
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.
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
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
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.
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.
Shotaro,
Thanx!
all your suggestions worked brilliantly.
your help is much appreciated
regards
Pervez
Thanx!
all your suggestions worked brilliantly.
your help is much appreciated
regards
Pervez
サインインしてコメントを残してください。