Forum Discussion
Replace value containing alphabets to blank values
Hi, How can I replace all the rows in a column containing a combination of alphabets and numbers with Blank values? Goal is to - old new 111 - 111 222 - 222 333 - 333 ...
Hi,
you can:
- duplicate column
- change type to whole number
- then in transform replace errors to null
If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !
serpiva64
Solution Sage
Solution SageHi,
you can:
- duplicate column
- change type to whole number
- then in transform replace errors to null
If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !