This is likely an easy question for you folks out there, but does anyone know how to trim a field in Infomaker to remove the trailing white spaces on the right, essentially a RTRIM in SQL?
Penny
There are many different ways to do it depending on where you want to add this function. You can do it from the Format tab on the right. Click the little square shape button while in the Format tab, it will open the Expression dialog box and also display all the available functions. You can also add a column as a Computed Field from Insert>Control menu which will right away open the Expression dialog box. You can also add it from the General tab’s Text box if you are inserting a text. Hope this makes sense.
Mo
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Penny Tabor Sent: Friday, September 23, 2011 2:16 PM To: Mohiuddin Faruqe Subject: RE: [Tessitura Technical Forum] Trim field in Infomaker?
Where in Infomaker do I indicate this?
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Mohiuddin Faruqe Sent: Friday, September 23, 2011 2:11 PM To: Tabor, Penny Subject: RE: [Tessitura Technical Forum] Trim field in Infomaker?
Penny, you can use the TRIM(string) function. It returns a given string after removing leading and trailing spaces.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Penny Tabor Sent: Friday, September 23, 2011 1:56 PM To: Mohiuddin Faruqe Subject: [Tessitura Technical Forum] Trim field in Infomaker?
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!