Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

agrimroquette
Valued Contributor

seperator

Hi,

i want to delimit these values by 'space'-

 

Friendly Name
0122285Y android Android 7.0.0 P8PM
1490117A android Android 6.0.1 RGGN

but i want output as

"Android 7.0.0 P8PM" and "Android 6.0.1 RGGN"

1 Solution

Accepted Solutions
agrimroquette
Valued Contributor

Re: seperator

in script:-  

SubField("Friendly Name", ' ' , 1) as Number,

   SubField("Friendly Name", ' ' , 2) as "Type",

   SubField("Friendly Name", ' ' , 3) as "Andriod/Apple",

   SubField("Friendly Name", ' ' , 4) as "Version",

in fx:-

=("Andriod/Apple") &  ' ' & (Version)

5 Replies
prma7799
Honored Contributor III

Re: seperator

Have you try this

=Right(FieldName,'19' )

Or

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

right.png

MVP
MVP

Re: seperator

May be like:

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

agrimroquette
Valued Contributor

Re: seperator

in script:-  

SubField("Friendly Name", ' ' , 1) as Number,

   SubField("Friendly Name", ' ' , 2) as "Type",

   SubField("Friendly Name", ' ' , 3) as "Andriod/Apple",

   SubField("Friendly Name", ' ' , 4) as "Version",

in fx:-

=("Andriod/Apple") &  ' ' & (Version)

antoniotiman
Honored Contributor III

Re: seperator

Maybe

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

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

Regards,

Antonio

Re: seperator

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.
Community Browser