Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have field with values both numbers and text but I want to show only numbers from that.
How can I achieve the same.
Thanks for the help
Try this:
LOAD *
KeepChar(FieldName, '0123456789') as Number
PurgeChar(FieldName, '0123456789') as Name
Resident xyz;
Try,
Keepchar(Name,'0123456789')
Use this as your expression: =If(IsNum(Field), Field)
Hi ,
I am getting blank values while I am using this
Hi,
It works. let me test it completely
Can you post some sample data / script details?
Andy
I think Kush141087 understood your requirement better than I did.
hey sunindia i think question was not structured well.Field values have both numbers and text means you understood correctly. May be i did not understand properly but may be i will lucky
ALT(Field)
HI,
Try this
=purgeChar(Data,'()ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')
Find the sample also.