Bar Code Help

Yahoo Archive
1
Perfect.

Thank you.

--- In vantage@yahoogroups.com, Dan Shallbetter <dans@s...> wrote:
> Kelly,
>
> If you are trying to delete spaces in front of the sequence number
you might
> try something like this "*"+ trimleft(JobMtl.AsmSeq) + "*"
>
> Dan Shallbetter
> States Electric Mfg.
>
>
> -----Original Message-----
> From: Kelly Wendorff [mailto:kelly.wendorff@s...]
> Sent: Thursday, July 01, 2004 1:58 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Bar Code Help
>
>
> I am trying to barcode the JobMtl.AsmSeq field on our Traveler.
>
> This field is a 4 character string. After using a formula to insert
> asterisk around the field, the bar code looks like this
>
> *___1* (3 spaces before the numeric character).
>
> Crystal displays this field as two serpate bar coded fields (with a
space
> between) which my gun (PSC Powerscan LR) won't read. If I replace
the
> spaces with commas (*,,,1*), it works.
>
> Ideally, I would like the field to look appear as *1* or *12* if a
two
> character field.
>
> I'm sure that I need to convert this string to another type of
field, but
> that's the extent of my knowledge.
>
> Can anyone help?
>
> TIA,
>
> Kelly Wendorff
> Cost Accounting Manager
> SteelCraft Corporation
> 105 SteelCraft Drive
> Hartford, WI 53027
> 262.673.6770
> 262.673.4380 (Fax)
> www.scc-wi.com
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
2
I am trying to barcode the JobMtl.AsmSeq field on our Traveler.

This field is a 4 character string. After using a formula to insert
asterisk around the field, the bar code looks like this

*___1* (3 spaces before the numeric character).

Crystal displays this field as two serpate bar coded fields (with a space
between) which my gun (PSC Powerscan LR) won't read. If I replace the
spaces with commas (*,,,1*), it works.

Ideally, I would like the field to look appear as *1* or *12* if a two
character field.

I'm sure that I need to convert this string to another type of field, but
that's the extent of my knowledge.

Can anyone help?

TIA,

Kelly Wendorff
Cost Accounting Manager
SteelCraft Corporation
105 SteelCraft Drive
Hartford, WI 53027
262.673.6770
262.673.4380 (Fax)
www.scc-wi.com
3
Kelly,

If you are trying to delete spaces in front of the sequence number you might
try something like this "*"+ trimleft(JobMtl.AsmSeq) + "*"

Dan Shallbetter
States Electric Mfg.


-----Original Message-----
From: Kelly Wendorff [mailto:kelly.wendorff@...]
Sent: Thursday, July 01, 2004 1:58 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Bar Code Help


I am trying to barcode the JobMtl.AsmSeq field on our Traveler.

This field is a 4 character string. After using a formula to insert
asterisk around the field, the bar code looks like this

*___1* (3 spaces before the numeric character).

Crystal displays this field as two serpate bar coded fields (with a space
between) which my gun (PSC Powerscan LR) won't read. If I replace the
spaces with commas (*,,,1*), it works.

Ideally, I would like the field to look appear as *1* or *12* if a two
character field.

I'm sure that I need to convert this string to another type of field, but
that's the extent of my knowledge.

Can anyone help?

TIA,

Kelly Wendorff
Cost Accounting Manager
SteelCraft Corporation
105 SteelCraft Drive
Hartford, WI 53027
262.673.6770
262.673.4380 (Fax)
www.scc-wi.com









[Non-text portions of this message have been removed]