Data360 Analyze

 View Only

  • 1.  Find the numbers from set data and return the numeric values

    Posted 08-14-2023 22:05

    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
    ------------------------------


  • 2.  RE: Find the numbers from set data and return the numeric values

    Posted 08-15-2023 02:47

    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
    ------------------------------



  • 3.  RE: Find the numbers from set data and return the numeric values

    Posted 08-15-2023 16:58

    Thanks you Simran



    ------------------------------
    Tevita Fainga
    Tonga Communications Corporation
    Fasi-moe-Afi
    ------------------------------

    Original Message