Count the Occurrence of a word in String



  • HI,

    I have a requirement where I need to count the occurrence of a word i.e. "DownloadServlet" in Message field by each date.I have highlight the word below shown example. I have used delimiter as "space" to create the following fields as input Metadata Date, Mins, TPProcessor, JVMCode,MiscCode,Type and Message.
    1)Output should be Date, Count of DownloadServelt(occurrences of word DownloadServelt will tell me the count)

    1. If above is achieved then need to show which file is downloaded from below example i.e. file name : I want to know what would be the function I should be using in Reformat and Aggregation.Really Appreciate your help.

    Please help.

    I didn't find the right solution from the Internet.

    References:
    https://forum.cloveretl.com/viewtopic.php?t=6826
    Business video company

    Thanks!


Log in to reply
 

Looks like your connection to GXChain Community was lost, please wait while we try to reconnect.