BRFplus removing special characters

[Former Member]

Hi All.

I'm just getting started using BRF+.

Does anyone know a way to remove special characters from a string?

I created a formula expression using nested REPLACE_SUBSTRING, but it seems like I should be able to use one REPLACE_SUBSTRING function and give a list where the formula would replace any/all values in the list with the empty string.

Any help would be greatly appreciated!

Thanks,  Mike

[former_member190447 · Accepted solution]

There's no standard formula function available to accomplish this. But you can extend BRFplus by plugging in your own formula functions. If you want to implement this, feel free to add it.

[Former Member]

Thanks Wolfgang and Adepu for pointing me in the right direction!

For some reason I thought I recalled seeing a formula expression that had a list of all special characters where any of them encountered would be replaced by the empty string.

Probably in a dream.

-Mike

[former_member200954]

Hi Michael,

As Wolfgang said you have to plug in your own formulas and if you can't make it happen using formulas you have to create a FM in the back end and and call that (which is the last thing anyone using BRFPlus what). A while ago i had to concat two string separated by space. I had to achieve it through FM.