Crystal reports help please

[Former Member]

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

[abhilash_kumar · Accepted solution]

Hi Ramesh,

Could you share some more info on what 'part' of the string are you looking for extract?

E.g: Everything after the second period or everything after/including the word 'Web'.

-Abhilash

[Former Member · Accepted solution]

Hi Abhi,

So Here is my data

GEUC.Tier2TechSvcs.Web Portal Apps.SOND

GEUC.Tier2TechSvcs.SFTSRVC.Bomgar

GEUC.Tier2TechSvcs.Sftsrvc.Other

I want  like this

Meaning after 2nd dot I want data

Web Portal Apps.SOND

SFTSRVC.Bomgar

Sftsrvc.Other

[abhilash_kumar · Accepted solution]

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

[Former Member · Accepted solution]

Thanks Abhilash it would helpful to me