topic how to seprate numeric and string values in Filed in QlikView

how to seprate numeric and string values in Filed

Wed, 13 Jul 2016 09:44:56 GMT

I have one filed like below

1529071-OVERSIGHT

15907123-Control

now i want only numeric values

please help

sunny_talwar — Wed, 13 Jul 2016 09:46:10 GMT

May be using SubField function

SubField(FieldName, '-', 1) as FirstPart,

SubField(FieldName, '-', 2) as SecondPart,

amit_saini — Wed, 13 Jul 2016 09:55:16 GMT

Hi,

See the attachment.

Thanks,
AS

arulsettu — Wed, 13 Jul 2016 10:00:06 GMT

stalwar1‌ answer is best one

for alternate

try this

KeepChar('1529071-OVERSIGHT','0123456789') as number

PurgeChar('1529071-OVERSIGHT','0123456789-') as string