| Boilerplate text and hidden fields [message #274003] |
Fri, 12 October 2007 11:49  |
brendan_j_moran
Messages: 2
Registered: October 2007
|
Junior Member |
|
|
I have created boilerplate text that references three fields. The end result is supposed to be a barcode that will be read by a mail inserter. However when I string the three fields together I get a space in them. How do I get rid of the spaces? I have f_field_1, f_field_2 and f_field_3 all of which have their visible property set to no. I then have a boilerplate set like this. &f_field_1&f_field_2&f_field_3. The output is this: *000001 01 01. How do I get rid of the spaces? I have also used the <> as per the help (&<f_field_1>&<f_field_2>&<f_field_3>) but that does not remove the spaces.
[Updated on: Fri, 12 October 2007 13:25] Report message to a moderator |
|
|
|
| Re: Boilerplate text and hidden fields [message #274022 is a reply to message #274003] |
Fri, 12 October 2007 15:13  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Don't use 3 fields. Create a FORMULA COLUMN which would return CHARACTER, and its result will be concatenation of those three fields:RETURN (:field_1 || :field_2 || :field_3);
Also, note that you might need to concatenate '*' in front of the returning string and as the terminating character of the same:RETURN ('*' || :field_1 || :field_2 || :field_3 || '*');[Updated on: Fri, 12 October 2007 15:13] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
