topic Subfield in App Development

Subfield

ritumishra01 — Fri, 15 Nov 2024 21:29:53 GMT

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

completed

started

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

Lisa_P — Fri, 11 Aug 2023 01:00:36 GMT

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

MayilVahanan — Fri, 11 Aug 2023 01:29:58 GMT

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 — Fri, 11 Aug 2023 01:38:17 GMT

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 — Mon, 14 Aug 2023 16:57:55 GMT

Hi,

another expression might be

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

hope this helps

Marco