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
Discussion posts and replies are publicly visible
Split by the "_", then take the last few items, and add the "_" again.
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)))
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", "" )