Updated Code

     Task: Temp

    Settings: Run Both Together

    

    A1: AutoNotification Query [

         Configuration: Persistency Type: Both

         Notification Apps: FairEmail

         Get All Fields : true

         Timeout (Seconds): 20

         Structure Output (JSON, etc): On ]

    

    A2: Write File [

         File: Download/CSV File Viewer/hi.txt

         Text: %antextbig()

         Add Newline: On ]

    

    A3: AutoNotification Cancel [

         Configuration: Id: %anid

         Notification Apps: FairEmail

         Package Name: %anpackage

         Timeout (Seconds): 20

         Structure Output (JSON, etc): On ]

    

    A4: Read File [

         File: Download/CSV File Viewer/hi.txt

         To Var: %textfile

         Structure Output (JSON, etc): On ]

    

    A5: Variable Search Replace [

         Variable: %textfile

         Search: \bkey\w*\b

         Store Matches In Array: %textkeys ]

    

    A6: Write File [

         File: Download/CSV File Viewer/antextbig an.txt

         Text: %textkeys()

         Add Newline: On ]

    

    A7: Read File [

         File: Download/CSV File Viewer/antextbig an.txt

         To Var: %textfilewithkeys

         Structure Output (JSON, etc): On ]

    

    A8: Variable Set [

         Name: %newline

         To: 

         

         Structure Output (JSON, etc): On ]

    

    A9: Variable Set [

         Name: %newspace

         To:  

         Structure Output (JSON, etc): On ]

    

    A10: Variable Search Replace [

          Variable: %textfilewithkeys

          Search: ,

          Replace Matches: On

          Replace With: %newspace ]

    

    A11: Variable Search Replace [

          Variable: %textfilewithkeys

          Search:  

          Replace Matches: On

          Replace With: %newline ]

    

    A12: Variable Set [

          Name: %text_data

          To: %textfilewithkeys

          Structure Output (JSON, etc): On ]

    

    A13: Variable Split [

          Name: %text_data

          Splitter: %newline ]

    

    A14: Read File [

          File: Download/CSV File Viewer/2010.csv

          To Var: %csv_data

          Structure Output (JSON, etc): On ]

    

    A15: Variable Set [

          Name: %to_search

          To: %text_data(+/)

          Structure Output (JSON, etc): On ]

    

    A16: Stop [ ]

        If  [ %csv_data.Header3(#?%to_search) eq 0 ]

    

    A17: Array Set [

          Variable Array: %indexes_of_matches

          Values: %csv_data.Header3(#?%to_search)

          Splitter: , ]

    

    A18: Flash [

          Text: %indexes_of_matches()

          Continue Task Immediately: On

          Dismiss On Click: On ]

    

    A19: Variable Search Replace [

          Variable: %csv_data

          Search: \Q%csv_data.Header1(%first_match),%csv_data.Header2(%first_match),%csv_data.Header3(%first_match)\E

          Replace Matches: On

          Replace With: $0,find ]

    

    A20: Write File [

          File: Download/CSV File Viewer/hihi.txt

          Text: %indexes_of_matches()

          Add Newline: On ]

    

    A21: Text/Image Dialog [

          Title: Result

          Text: %csv_data

          Button 1: Ok

          Close After (Seconds): 120 ]

    

    

Comments

Popular posts from this blog

It Worked Thankyou.

If Statement Not Working and Splitter ',' within the FOR loop also not working.