LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  truncating string data

    Employee
    Posted 04-29-2014 16:54

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Glenn Q

    Hi,

    I have a string field that I am trying to truncate so I am only left with the first five characters in the string. E.g.

    Currently:
    abcdefghi
    bcdefghij

    I would like to convert this to:
    abcde
    bcdef


    I am unsure how to go about it. Does anyone have any suggestions?

    Any assistance would be greatly appreciated!

    Thanks,

    Glenn


  • 2.  RE: truncating string data

    Employee
    Posted 04-29-2014 22:36

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Glenn Q

    I have just been given the answer:

    emit *
    emit MyString.left(5) as TruncString

    Cheers,

    Glenn