topic Re: Text inside a string in QlikView

Text inside a string

mkudis — Tue, 06 Apr 2021 20:55:42 GMT

I have a field (log_message) that is a large string of data that I would like to pull a particular piece of text from, but the string is not always the same values in the same position. Is this possible? An example of the string is:

Status update applied: Branch ID: Texas Tran: 123456-1 Type: XX Orig Status: S New Status: D User jdoe Date/Time Tue Apr 6

then the next row of data may be something like

Related image applied: Branch ID: Texas Tran: 123456-1 User: jdoe Date/Time: Tue Apr 6

So I basically will always need to pull the first 6 digits of information after 'Tran: '

Re: Text inside a string

jwjackso — Tue, 06 Apr 2021 21:16:37 GMT

=SubField (SubField(log_message,'Tran:',2),'-1',1)

Re: Text inside a string

rwunderlich — Wed, 07 Apr 2021 03:59:47 GMT

TextBetween(log_message, 'Tran:', '-')

-Rob

Re: Text inside a string

mkudis — Wed, 07 Apr 2021 16:15:06 GMT

Doesn't seem to be working with either expression. Wondering if it has to do with the string itself, as I would expect this to return it pretty easily.

The issue may be the type of sheet object I am using. What type of sheet object would I use to show this data correctly?

Re: Text inside a string

rwunderlich — Wed, 07 Apr 2021 18:45:51 GMT

Either expression should work in a table object where the Dimension is log_message.

-Rob