splitting a serial number to 2 lines based on a certain character S’abonner



I would like to know if there is an easy VB script that could split my GRN | Serial number from one line of text to two if a certain character is present?

For example, we have parts that have a GRN value and some parts have GRN and a Serial number.

Our Excel database sheet always has both combined but with a "|" character separator. So I want to have two separate lines of values on the Label, one for GRN and one for Serial Number with the script splitting it up when the "|" character is present.


Any help would be appreciated.

Thank you.

1 commentaires

Pete Thane
Actions pour les commentaires Permalien

No need to use VB, just use the Transforms> Seach and Replace option

Vous devez vous connecter pour laisser un commentaire.