Re: seperator - Qlik Community

xyz1 · ‎2017-07-19

.

prma7799 · ‎2017-07-19

Have you try this

=Right(FieldName,'19' )

Or

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

tresesco · ‎2017-07-19

May be like:

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

antoniotiman · ‎2017-07-19

Maybe

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

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

Regards,

Antonio

PrashantSangle · ‎2017-07-19

Hi,

If you want all text after 1st space then try

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

regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

?