☑ This topic is solved.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 11-15-2022 05:00 AM
(654 views)
Hello all,
I have a problem. I have a column address where I have to put blank the rows that contain ONLY numeric variables. Example: the ones that I have highlighted
Any idea how I can proceed?
I cannot use compress because it will remove all other numeric characters from rows that contain both numeric and alphabetical
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Try:
if anyalpha(var) = 0 then var = ' ';
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thank you !! It works 🙂