wow....never tried that before....I would say it's something like use a combination of substr and strstr to walk through each character of a field copying it to a new field, then, have workflow that has a run-if similar to 'field' = [0-9].....and if it passes, copy that character somewhere else, if not, don't...

I've never done anything quite like that before, and the syntax I suggested above might not be 100% right....but it should work fairly similar to that.

Sounds like a job for the regex filter API plugin?

Regular Expression (Regex) AR API Filter Plug-in (v4.1)

good point....I often forget about that powerful option.

I suggest using the capabilities that the DBMS provides by creating a custom function, digitsOnly(inString) --> digitString

On Oracle, this would use the built-in translate function and return the digitString of 0-9.

For SQL server, the implementation would differ slightly.

Or use a series of AR functions (brute-force method):

• UPPER(inString)
• REPLACE(inString, "A", $NULL$)
• REPLACE(inString, "B", $NULL$)
• ...
• REPLACE(inString, "Z", $NULL$)

-Jim

Chakor

with the action set field you can use direct sql.  I’d write an sql that does a  patindex something like:

select [field] from [table.view] where PATINDEX('%[ ~`!@#$%^&*_()=+\|{};",<>/?a-z]%', [field])=0

and return that result to your field.

I would use REGEX in this particular case.

Just found some of my old code and here’s what I did

created a set field ran this sql

SELECT REGEXP_REPLACE('$Remedy Field$', '[^0-9]', '') FROM ViewName

then your set field would equal $1$ which is the value returned from the direct sql.