Forum Discussion
HAL
Advocate I
Advocate ISeparate Text from Numbers in a mixed column
Hello Community: In my data source (csv or Excel), there is a column that contains text, numbers and blanks. I need to do calculations on a subset of the numbers, so I need them in numbers format. I...
HALAdvocate I
Advocate IHere is some sample data from the column:
| 84.000.000 |
| 84.000.000 |
| 84.000.000 |
| *** |
| *** |
| 184.000.000 |
| *** |
| 74.200.000 |
| 184.000.000 |
| 74.200.000 |
| *** |
| *** |
| *** |
| *** |
| 184.000.000 |
| ASY |
| ASY |
| ASY |
In fact, I have a couple of thousand records. Currently the column ist "text" format", but I need to have access to the numeric values in the column and create average, min, max etc. from that. So I thought I create a new column with just the numeric values and format the new coklumn as "number". But I cannot figure out, how to extract the new column.
MattAllington
Community Champion
Community ChampionOk. This is good. You could simply convert the data type of the column to numeric, then "remove errors", and then filter out null values. That would leave you with a column of numbers. Does that work?