topic Re: Exclude data in a field after (-) in QlikView

Exclude data in a field after (-)

alec1982 — Thu, 10 Jan 2013 17:03:42 GMT

Hi Guys,

How can i do this in the script.

I have a field and the values in it like this

FieldName

New York - ABC

Atlanta - ABCD

Miami - RF

How can I get a field to be like

Field Name1

New York

Atlanta

Miami

So basically i want to exclude anything after from the dash and over.

Thxs for your help

Alec

Re: Exclude data in a field after (-)

Nicole-Smith — Thu, 10 Jan 2013 17:14:09 GMT

subfield(FieldName, '-', 1)

Re: Exclude data in a field after (-)

disqr_rm — Thu, 10 Jan 2013 17:14:11 GMT

Load subfield(FieldName, '-', 1) as NewField

Re: Exclude data in a field after (-)

Thu, 10 Jan 2013 17:15:14 GMT

Probably something like this would suit you best:

LEFT(FieldName, index(FieldName,' -') ) as FieldName1,

Keep in mind this has a space before the - assuming you have that in your example above. If you don't simply change the inside of the index part to '-'

Hope this helps!

Re: Exclude data in a field after (-)

alec1982 — Thu, 10 Jan 2013 17:18:17 GMT

I guess I found it but just in case someone else needs a solution I used

SubField(FieldName,'-',1)

Thxs,

Alec