Community

Hello,

My scenario is : Document Definition fields.

I have a field named Amount which retrieves information from a document and it will be in the given format , GBP14,567 CR. Where GBP is the currency , and CR means credit. 

I want to perform a substring or RegEx so that , the 3 first characters i.e. is assigned to the currency field (default null) and the 2 last characters i.e. CR will be assigned to the CashType field ( default null). And at last, the amount field will contain only 14,567. 

Can someone please guide me through the necessary steps? 

Thank you.