Split column based on whether the field contains non...

[domintune]

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?

[Amit_Kumar · Accepted solution]

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. 

[domintune]

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.