Function which remove all characters

[roee1983]

Hi all,

i have in my model a  field calls "accounts" , this field has values with numbers & characters toghther or only characters.

how do i get rid from all the characters  records  ?

for exapmle:

bb_445642  = 445642

sales = delete from the field.

Thanks

Roee

[tresesco · Accepted solution]

try:

purgechar(accounts, '_abcdefghijklmnopqrstuvwxyz')

Not getting easier method yet.

[MayilVahanan]

Hi

Try like this

if(len(Keepchar(accounts, '_1234567890')) > 0, Keepchar(accounts, '_1234567890'), '') as accounts