Hi,

I have been trying to understand what is wrong with this custom function that I found in

http://www.briandunning.com/cf/957

I have a simple database with about 100,000 records with numbers like 1200103792893 this function works well except that some secuences are not encoded properly. They turn into an invalid character represented as  with all the barcode fonts I've tried.

For example these numbers give me an error, 1200103380473, 1200103382093, 1200103552193 while others like 1200103817993, 1200103819193 and 1200103819693 works fine.

I can post or send by email an example of the database.

I will apreciate any help regarding this issue please.

Thank you in advance,

Julio.

Did you notice the "Discuss" at the bottom?

Running OS X & FM Pro 11, this function works except that spaces are not encoded properly. They turn into an invalid character (represented as  with all the barcode fonts I've tried).

As a quick solution (I was in a hurry) I just added a substitute line to substitute spaces for the  characters and it seems to work fine.

Kevin OShea, San Jose

April 26, 2011 10:46am

Hi Lee, thank you for your reply.

I saw it but I dont understand the fix, sorry...

Thank you,

Julio.

You can change the CF used in the calculation from

cfCode128 ( pString; pCodeSet )

to

cfCode128 ( Substitute ( pString ; " " ; "_" ) ; pCodeSet )

BTW, what I know about BARCODES structure you could put into thimble. I noticed that this fix didn't work with your example set of numbers with out the SBN preceding them, and it also added to the end some characters.

Lee

You are right, the fix doesnt work, what do you mean about the SBN?

The example given in the custom function used SBM in the data entry

cfCode128 ( "SBM16672_2008_08_25"; "B" )