Hi Tevita,
You can do this by using regex matching to find the numeric values in the string and then output those values on another field. The D360 Transform node can be used to do this. Please see the attached screenshots. Hope this helps!
- Simran
------------------------------
Simran Vaswani
Logiclear
Melbourne VIC
------------------------------
Original Message:
Sent: 08-14-2023 22:04
From: Tevita Fainga
Subject: Find the numbers from set data and return the numeric values
How to find the numbers from the set data and return the numeric values on a new field.
|
| Home Family Bonus 30GB |
| SME Lite - 110GB Bonus |
| SME Lite - 110GB Bonus |
| Home Lite-Bonus 15GB |
| SME Lite - 110GB Bonus |
| Home Family Bonus - 25GB |
| Corporate Lite - Bonus 310GB |
| Home Lite-Bonus 15GB |
| Home Family Bonus - 25GB |
| Home Heavy Bonus - 55GB |
| SME Lite - 110GB Bonus |
| SME Lite - 110GB Bonus |
| TCC Staff 50GB |
| SME Lite - 110GB Bonus |
| Kalianet Internet Access Fee |
| Economy Pack 9GB |
------------------------------
Tevita Fainga
Tonga Communications Corporation
Fasi-moe-Afi
------------------------------