How to truncate a text value?

Comments

3 comments

  • Ganesh Shankar

    Found the answer :), thanks

    0
    Comment actions Permalink
  • Manuel Garcia

    You need to create a Calculation Field and write

    str = @Large Text
    truncate_string = str.substring(0,100)
    truncate_string

    100 it's de number of caracthers

    0
    Comment actions Permalink
  • Troy Muir

    I'm trying to do this and its not working - can you please elaborate?

    I'm trying to take a local mobile phone number (@phone in podio) entered by the customers as '0411222333' - substring the last 9 digits eg. '411222333' and then add in the international code for Australia '61' so it becomes a full international dialing number eg. '61411222333' - so it can then be used by Twilio etc.

    Can you please help?

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk