Subfield

[ritumishra01]

I have 

completed/inprogess/started

completed /started/

completed//

started//

as status now i want to get last value only in my expression using if condition 

i need

started

started

completed 

started

last value everytime it should give me how can i achieve this .

[Lisa_P]

here is some script logic that works either in a chart or in the data load editor

[MayilVahanan]

Hi

Try like below

Temp:
LOAD *, SubField(F1, '/') as F2, RowNo() as F3 INLINE [
F1
completed/inprogess/started

completed /started/

completed//

started//
];

Inner Join
Load F1, Max(If(Len(F2)>0, F3)) as F3 Resident Temp Group by F1;

[MayilVahanan]

hi

Suppose, if you want in front end expression alone, then try like below

If(Right(F1, 2) = '//', SubField(F1, '//',1), If(Right(F1, 1)='/', SubField(F1, '/',2), SubField(F1, '/',3)))

but not sure, is it suit for all ur data.. 

[MarcoWedel]

Hi,

another expression might be

SubField(Replace(Replace(Trim(Replace(Replace(status,' ','<space>'),'/',' ')),' ','/'),'<space>',' '),'/',-1)

hope this helps

Marco