topic Re: seperator in QlikView

?

xyz1 — Sun, 14 Apr 2019 14:51:07 GMT

prma7799 — Wed, 19 Jul 2017 05:37:09 GMT

Have you try this

=Right(FieldName,'19' )

=Right('0122285Y android Android 7.0.0 P8PM','19' )

tresB — Wed, 19 Jul 2017 05:40:48 GMT

May be like:

=Mid([Friendly Name],index([Friendly Name], 'Android'),len([Friendly Name]))

antoniotiman — Wed, 19 Jul 2017 05:48:54 GMT

Maybe

=SubField(Text,'android',-1)

However this works only if Your Field contains 'android' text.

Regards,

Antonio

PrashantSangle — Wed, 19 Jul 2017 05:49:04 GMT

Hi,

If you want all text after 1st space then try

=Mid([Friendly Name],Index([Friendly Name],' '))

regards,