Hidding value in Field

[#1]

Hi All

I have a list box which I would like to display without the first value and a delimeter.

I would like to sort the field by the the value to the left of "~" sign (Week), then only display data to the right right of the "~" in the front end. e.g 01-04 Week 1 Of Jan. How can I do this?

[reshmakala]

Please find the attached solution.

Go to List box properties and Sort tab.

Sort by expression to get the desired result.

[#3]

Hi

The sorting is done, but how do I remove the "~" and values to the left in the front end?

Mine does not go away after usinmg the same expression as yours.

[reshmakala · Accepted solution]

Use this expression

=mid(F1,Index(F1,'~')+1)

[#5]

Thank you so much!