Skip to main content
domintune
domintune
Level 2
Jan 16, 2020 10:43 AM UTC
Solved

Split column based on whether the field contains non numeric values

Hi,

 

I'm working on an import workflow, the data I'm receiving isn't clean. I need to map a string field into a long field. However the source RDBMS field contains values that has non numeric. I'm trying to manage this with either a split or a test but I'm getting nowhere as ISNAN(fieldname) isn't supported (apparently).

 

Does anyone know how to work with this?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Amit_Kumar
Amit_KumarAccepted solution
Level 10
Jan 16, 2020 3:15 PM UTC

use something Query: stringFieldName not like '%[^0-9.]%'

 

if you use this query you can filter the values in the split.

 

Note: This is only tested with Postgres as the underlying database. 

View in thread

2 replies

Amit_Kumar
Amit_KumarAccepted solution
Level 10
Jan 16, 2020 3:15 PM UTC

use something Query: stringFieldName not like '%[^0-9.]%'

 

if you use this query you can filter the values in the split.

 

Note: This is only tested with Postgres as the underlying database. 

Translate
domintune
domintuneAuthor
Level 2
Jan 29, 2020 6:14 PM UTC

I was unable to fix this permanently, I was forced to query the RDBMS for values not containing ":" for example. This is a mere bandaid for what I was trying to achieve but at least we can run BAU import again.

Translate
Terms & ConditionsAccessibility statement

Loading footer...