INPUT :
| field_1 |
| Clearing Currency |
| Rate Count Table Amount Value Value |
| |
| |
| ID Credits Debits |
| |
| Net Merchandise Credit 35,0000 |
| Net Issuer Interchange 23,000DB |
| Net Purchase Amount 10,000 GBP |
Expected Output : it should add | whenever there is 2 spaces but only if contains Net | should be added before amount
i have tried this formula :
IF REGEX_Match([field_1], "^Net") THEN
REGEX_Replace(Trim([field_1]), "(\s{2,}|\t)+", "|") + "|"
ELSE
REGEX_Replace(Trim([field_1]), "(\s{2,}|\t)+", "|")
ENDIF
| field_1 |
| Clearing Currency| |
| Rate|Count|Table|Amount|Value|Value |
| |
| |
| ID|Credits|Debits |
| |
| Net Merchandise Credit|35,000 |
| Net Issuer Interchange|23,000DB |
| Net Purchase Amount|10,000 GBP |
