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?