Text To Bold From Database Field フォローする

0
Avatar
Legacy Poster

hi,

 

I am pulling list of ingredients from MS Acess database and would like data to be checked against a list of allergens.Any allergens found in the data field should be converted to Bold face on print.

 

 

something like this,

  

 

   if "ingredients field" contains any of (list"Milk, Mustard, Peanuts,Fish")

 

     print Bread,Chicken,Milk,Salad

 

could you help me with vb to achieve desired output

 

 

kind regards

10 コメント

0
Avatar
Fernando Ramos Miracle
モデレータ
コメントアクション Permalink

Hello skbhatti,

 

We've created a solution for this precise issue (mainly due to the new EU allergen regulation), but in order to be able to send you this sample I'll need it to be through email. Do you mind sending us an email to Technical Support requesting this sample?

 

http://www.seagullscientific.com/label-software/technical-support.aspx

 

Regards

0
Avatar
Legacy Poster
コメントアクション Permalink

Hi , 

 

 Thanks for quick response. Sent an email yesterday to eurotech@seagullscientific.com now will wait for samples . 

 

 Regards

0
Avatar
Legacy Poster
コメントアクション Permalink

Hello!!
 
I have found some issues using this method :(
1. If i have both "Egg" and "Eggsallad" in my "allergenslist" I haveto write Eggsallad first, otherways only the three first letters of the word "Eggsallad" will be bold.
2. If I use Uppercase letters in as a capitalletter in my "allergenslist" it puts Uppercase letters inside a sentence even if it's not like that in the "Ingredientlist" . 
I tried to enter the allergens both with Uppercase and lowercase letters, but in this case it uses the last one that shows up in the allergenslist.
 
BR// Andy.
0
Avatar
Fernando Ramos Miracle
モデレータ
コメントアクション Permalink

Hello Andreas,

 

Thanks for your feedback.

 

Indeed as the function stands the Allergens need to be ordered from the "longest" to the "shortest" to prevent the kind of issue you found when more than one allergen share common  characters (such as "Egg" and "Eggsallad").

 

Regarding the upper or lower case of the allergens, note that the script searchs for the allergen in your ingredient list and substitute it with the corresponding allergen from the allergen list surrounded with the appropriate tags. Being that the case, you need to be careful to specify the allergens in the format you want them printed.

 

*Note that we hope to improve the script for future release of our software.

 

Many thanks and regards.

0
Avatar
Domingo Rodriguez
モデレータ
コメントアクション Permalink

We now also have a FIC allergen labelling page on our website which covers this:

http://www.seagullscientific.com/label-software/food-and-beverage-fic.aspx

0
Avatar
Legacy Poster
コメントアクション Permalink

Hello Andreas,

 

Thanks for your feedback.

 

Indeed as the function stands the Allergens need to be ordered from the "longest" to the "shortest" to prevent the kind of issue you found when more than one allergen share common  characters (such as "Egg" and "Eggsallad").

 

Regarding the upper or lower case of the allergens, note that the script searchs for the allergen in your ingredient list and substitute it with the corresponding allergen from the allergen list surrounded with the appropriate tags. Being that the case, you need to be careful to specify the allergens in the format you want them printed.

 

*Note that we hope to improve the script for future release of our software.

 

Many thanks and regards.

Hello again!!

 

The problem with the Upper & lower letters persists....

 

If the ingredient is the first word in a sentence, then i want it with a Capital letter, but if it's in the middle of thee sentence then I want it with small letters... Is this duable??

 

BR// Andy.

0
Avatar
Fernando Ramos Miracle
モデレータ
コメントアクション Permalink

Hello Andreas,

 

Please note that we've improved the FIC solution you'll find in our website that cover your issue apart from adding a number of features requested by other users (an exception list, different language support,...).

 

You'll find our solution on the following webpage:

http://www.seagullscientific.com/label-software/food-and-beverage-fic.aspx

 

Regards.

0
Avatar
Legacy Poster
コメントアクション Permalink

Hello! 

we are using BT10.0 SP4, do you also provide a template for this build? Or are we forced to do an upgrade?

Kind regards

Tobias

0
Avatar
Fernando Ramos Miracle
モデレータ
コメントアクション Permalink

Hello Tobias,

 

The sample from our website requires features that are only available on v10.1.

 

Do note that it's possible for the script to work on v10.0, as the latter also uses HTML markup containers; but in this case you would need to adapt the script to make up for the lack of features of your version (something you would need to devise yourself).

 

*Main features that in this case affect the older version are: "external file" type data source, and independent named data sources (not contained in any label object).

 

Regards.

0
Avatar
Legacy Poster
コメントアクション Permalink

Thank you for your reply Fernando! 

ログインしてコメントを残してください。