Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have one filed like below
1529071-OVERSIGHT
15907123-Control
now i want only numeric values
please help
May be using SubField function
SubField(FieldName, '-', 1) as FirstPart,
SubField(FieldName, '-', 2) as SecondPart,
May be using SubField function
SubField(FieldName, '-', 1) as FirstPart,
SubField(FieldName, '-', 2) as SecondPart,
Hi,
See the attachment.
Thanks,
AS
stalwar1 answer is best one
for alternate
try this
KeepChar('1529071-OVERSIGHT','0123456789') as number
PurgeChar('1529071-OVERSIGHT','0123456789-') as string