topic Extracting String in QlikView

Extracting String

Tue, 29 Jun 2010 17:30:47 GMT

Hi all

I am looking at extracting all of the text up to a full stop in a field called "Comments" - does anyone know the code to do this?

Thanks in advance,

Chris

Tue, 29 Jun 2010 17:35:14 GMT

I assume you're referring to a period character as a 'full stop'

You'll have to handle cases where there is no 'full stop', but this should set you on your way:

Left([your field], FindOneOf([your field], '.'))

sicilianif — Tue, 29 Jun 2010 17:36:40 GMT

If I am reading what you wrote correctly, you could do something like this:

Left(Comments,index(Comments, '#')-1)

Just replace the # with whatever character(s) you want to stop extracting at.

For example, if comments was this: "This is a test#Something Else", the above code would return "This is a test".

Frank

johnw — Wed, 30 Jun 2010 00:36:51 GMT

Or:

subfield(Comments,'.',1)

If there's no full stop, it should return the entire Comments field. I assume that's what you want.

Fri, 02 Jul 2010 14:55:26 GMT

Excellent, thanks for your help