topic Re: Subfield in App Development

Subfield

jpjust — Tue, 11 Jan 2022 15:50:58 GMT

Hi,

I have an expression in load script as below.

Subfield(AppName,'(',1) as AppName,

I want to apply subfield only for App names like TEST(1) not for App names like TEST(w) or sample(w)

Essentially, don't apply sub field where app names do not contain (1)
How can I achieve it?

Thanks

rwunderlich — Tue, 11 Jan 2022 17:34:18 GMT

if(AppName like '*(1)', Subfield(AppName,'(',1), '') as AppName,

MarcoWedel — Tue, 11 Jan 2022 19:58:05 GMT

another possible solution without subfield()

Left(AppName,Index(AppName,'(1)')-1)

jpjust — Tue, 11 Jan 2022 22:17:44 GMT

Thank you Rob!!

jpjust — Tue, 11 Jan 2022 22:18:06 GMT

Thank you Marco

MarcoWedel — Tue, 11 Jan 2022 23:17:25 GMT

You're welcome.

Please close this thread by accepting a solution.

Thanks