Column data- Any one help me please

[#1]

Dear All

My source is

Name	Message
Sankar	Accounts/SH1
Ram	Accounts/SH2

I want Display data as below

Name	Message
Sankar	SH1
Ram	SH2

[SunilChauhan · Accepted solution]

in dimension take

Name

expression  write

subfield(Message,'/',2)

or

in script

subfield(Message,'/',2) as message

[#3]

Use

Mid(Message,10,len(Message))

[#4]

Thank Q