Trimming long text string in Appian

Question

How to trim this text: 
 "UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_Integral_-_MARSHA_BISHOP_-_banking-mb_jfblaw.ca" 
 to 
 Integral_-_MARSHA_BISHOP_-_banking-mb_jfblaw.ca

Stefan Helzle · Answer

Split by the "_", then take the last few items, and add the "_" again.

Harsha Sharma · Answer

Text functions can help you achieve this. One of the way is below. Depending on format you might need to adjust it further using other functions. As, for the question above, this will work. 
 right(local!text,(len(local!text)-find("_Integral",local!text)))

Vyshnavi Naripeddi · Answer

Swati Sharda let me know if this works for you. 
 regexreplaceall(
 "UDI_1_592268_",
 "UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_Integral_-_MARSHA_BISHOP_-_banking-mb_jfblaw.ca",
 ""
)