Internationalization

Tags: #<Tag:0x00007fbe9541e438>

Hi!
I have read many different topics about internationalization, otherwise could not get the right approach how to handle different values copied from Excel, which can contain special symbols and extra spaces.
E.g. “100 000,00 ₽”
Should I use beforePaste hook and clean it manually?

Thanks

Hi @r.glinkov

Yes, you can use the beforePaste hook to replace data. Here’s an example https://jsfiddle.net/dw0r8cag/3/ the chars to be removed/replaced is a matter of picking the correct regex. In my example the rule will only apply to a single value (if user pastes one value at once). If allow pasting more values you’d need to build a loop.

1 Like

Thank you)