Skip to Content
0
Former Member
Nov 05, 2012 at 03:11 PM

Trim characters from rightside in universe

1231 Views

Hi

I have a column with values like

Contact = abc

Contact = aaaaaaaaaaaaaaabbbbbbbbbb

Contact = mamamamammamam

Contact = lkjdfl

Contact = ttttt

I want the output to be

abc

aaaaaaaaaaaaaaabbbbbbbbbb

mamamamammamam

lkjdfl

ttttt

ie; I have to get only the values from the right side.I have to edit the field in the universe but I couldnt find what the command is to remove some characters from the left side.

I would appreciate if you could help me out here.I am using BOXI 3.1 SP3.

Cheers!