Copy selected characters from one column into another one

Classic Servoy
1

Hi all,

I have two columns with data type nvarchar that and int.
The one with nvarchar holds data type like D1234.
Is there a way to ignore D and only copy 1234 to the column with int data type?

Thanks for any help,

Abrahim

2

What happens when you set the mask to #?

3

Marcel,

I didn’t mask to #.
Do you have any example of using mask to #?

Thanks,

Abrahim

4

That’s simple, have a look in the properties. You will find the ‘format’ property. When you select the field it bevomes a combobox with sample masks…

And, just maybe, the docs can help you. Under the help menu, index tab ‘Field properties, format [property’…

Have fun. Hope this helps,

Marcel

5

Thanks Marcel!

Abrahim

6

You could try a Regex Expression to strip out any non-numerical characters as you assign the int column… Regex is a bit scary at first but immensely powerful…

Check the Servoy docs.

7

Regex is great, regex rule. I am a huge fan but in the case you want to check the input real time (without having a keydown or whatsoever event) they are not really the solution I guess…

8

The question is about two columns, not two fields…
So RegEx may be the best solution.

9

S* you are right. I recentently started to take a new class ‘how to read effectively’. I think I overdid it only reading the first and last word ;)