Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Subfield Index

Hi!
I took a look at Subfield function in QlikView help, and additionaly I tried to find some examples and explanations o the Internet.

Unfortunately I did not found anything what gives a nice overview on how to use this function.


Anyway, I am using this function to get the [Full Name] and to concatenate this filed with ]Message] field

here is the code:

trim(Message) & ' (' & applymap('MapUsername2FullName', upper(subfield(Message,'"',4)) , upper(subfield(Message,'"',4))) & ')' as [New Message]

I am not getting [Full Name]

Has anybody any suggestion?

4 Replies
CELAMBARASAN

Could you please post the Sample Message text here?

For Example: UserName"FullName

SubField('UserName"FullName', '"', 2) will give you the FullName

jagan
Luminary Alumni
Luminary Alumni

Hi,

Can you attach some sample values, so that it would be easier to understand your requirement and solve.

Regards,

Jagan.

Not applicable
Author

Yes, cerainly.

Here is an example of a Message item:

Call allocation: All XX licensed Named CALs are allocated. No CAL assigned to user "DOMAIN/abc123" - usage. denied.

I have to extract the following: DOMAIN/abc123

Gysbert_Wassenaar

If the username is always between double quotes you can use the textbetween function:

textbetween(Message, '"','"') as UserName

The '"' is a double quote character between two single quotes.


talk is cheap, supply exceeds demand