how to seprate numeric and string values in Filed

[#1]

Hi

I have one filed like below

1529071-OVERSIGHT

15907123-Control

now i want only numeric values

please help

[sunny_talwar · Accepted solution]

May be using SubField function

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

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

[amit_saini]

Hi,

See the attachment.

Thanks,
AS

[arulsettu]

stalwar1‌ answer is best one

for alternate

try this

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

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