int and str in one column

Timo97

Hello everybody,

does somebody know how i can detect or select only str/int in one column.

i have numbers and words in there....

would be really happy if someone could help me with this 🙂

LG Timo

Workflow

Accepted answers

mst3k

you will need the regex tool

https://help.alteryx.com/20213/designer/regex-tool

you will need to learn how to set up the pattern to match what your data looks like and what you're trying to do. you can use this tool to pick only text characters or only numbers or a lot of other patterns

atcodedog05

Hi @Timo97

If you want to split number and strings. Here is how you can do it.

Workflow:

Hope this helps : )

num and str.yxmd

danilang

@atcodedog05

Isinteger() tries to convert the number. IsNumber() checks the field type.

Btw. The regex examples above need to be modified to check for an optional "-" in the case of negative integers.

REGEX_Match([Field1],"-{0,1}\d+")

Dan

All comments

mst3k

you will need the regex tool

https://help.alteryx.com/20213/designer/regex-tool

Emil_Kos

Hi @Timo97,

One column can have only one data type. Maybe you can create two new columns. Use a select tool in order to change the data type to the number and if some of them become empty when you change the data type you should create a new column with text but only for those positions that are empty.