• Replies 3 replies
  • Subscribers 336 subscribers
  • Views 17 views
  • Users 0 members are here
Related

Trim field in Infomaker?

Former Member
Former Member $organization

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

Parents
  • Former Member
    Former Member $organization

    Where in Infomaker do I indicate this? 

     

    Penny

     

    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.

     

    Mo

    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 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




    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!




    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!

Reply
  • Former Member
    Former Member $organization

    Where in Infomaker do I indicate this? 

     

    Penny

     

    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.

     

    Mo

    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 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




    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!




    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!

Children
No Data