SXI Forum

MarekR

Member

Registered: 21-02-2019

Posts: 19

Rules: RemoveNonNumeric

This is a very simple rule to remove every character in a string except numbers.

EXAPMLE:

Text = “1a 2b 3c”

Notice there are spaces and letters in "Text".

<sxi:Field name="//*[local-name()=’Text’]">
 <sxi:Rules>
   <sxi:RemoveNonNumeric/>
 </sxi:Rules>
 <sxi:OutputField>Text</sxi:OutputField>
</sxi:Field>

After using the above config the text will now look like this:

Text = 123

Last edited by MarekR (15-03-2019 12:51:12)