Split column based on whether the field contains non numeric values

Avatar

Avatar

domintune

Avatar

domintune

domintune

16-01-2020

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

Amit_Kumar
MVP

16-01-2020

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. 

Answers (1)

Answers (1)

Avatar

Avatar

domintune

Avatar

domintune

domintune

29-01-2020

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.