Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try:
purgechar(accounts, '_abcdefghijklmnopqrstuvwxyz')
Not getting easier method yet.
try:
purgechar(accounts, '_abcdefghijklmnopqrstuvwxyz')
Not getting easier method yet.
Hi
Try like this
if(len(Keepchar(accounts, '_1234567890')) > 0, Keepchar(accounts, '_1234567890'), '') as accounts