Rule to hide "A" within a number row

[dschiller]

Hi PTI Community,

 

ok here is the story,

 

I have field called barcode where a user uploads a specified list of numbers here is an example "A1234567890123A" these number are printed on to ID cards I need a rule that will hide the "A's" so all that gets printed is "1234567890123".

 

Any suggestions?

[Alex Marshall]

Create a text Rule. The script will look like this:

 

return ReplaceSubstring("A1234567890123A" , "A", "");

 

or field name like so:

 

return ReplaceSubstring( Field("Mydatafield") , "A", "");

 

Use this Rule instead of the field and this should produce the desired result

[dschiller]

Thanks Alex,

 

Im still new to all of this.

 

Earl

[dschiller]

One more question,

 

If I have a set of numbers like the following:

 

1234567890123

 

Is there a rule so that I can have an "A" added before and after it, like the follow:

 

A1234567890123A

 

Thanks

[Alex Marshall]

Create a text Rule. The script will look like this:

 

return "A" + "1234567890123A" + "A";

 

or field name like so:

 

return "A" + Field("Mydatafield") + "A";

 

Use this Rule instead of the field and this should produce the desired result

[dschiller]

Create a text Rule. The script will look like this:

 

return "A" + "1234567890123A" + "A";

 

or field name like so:

 

return "A" + Field("Mydatafield") + "A";

 

Use this Rule instead of the field and this should produce the desired result

 

Thank you very much I know that may seem simple but I really struggled with that