topic Subfield Index in QlikView

Subfield Index

Wed, 16 Oct 2013 10:00:59 GMT

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?

CELAMBARASAN — Wed, 16 Oct 2013 10:27:51 GMT

Could you please post the Sample Message text here?

For Example: UserName"FullName

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

jagan — Wed, 16 Oct 2013 10:29:15 GMT

Hi,

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

Regards,

Jagan.

Wed, 16 Oct 2013 11:04:50 GMT

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 — Wed, 16 Oct 2013 17:00:43 GMT

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.