Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal reports help please

Hi All,

I have data for string like this.

KKK.Tier2TechSvcs.Web Portal Apps.SOND

SSS.Tier2TechSvcs.Web Portal Apps.SOND

AAA.Tier2TechSvcs.Web Portal Apps.SOND

I want to show like this

Web Portal Apps.SOND

Web Portal Apps.SOND

Web Portal Apps.SOND




Meaning I need to exclude data which is for 1st 2 dots.

Please help

Tags:
Former Member
replied

Try:

stringvar s := {database_field};

local stringvar temp := Mid(s,Instr(s,'.')+1);

if instr(temp,'.') > 0 then

(

    local stringvar temp2 := Mid(temp,Instr(temp,'.')+1);

            Mid(temp2,1);

);

-Abhilash

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question