It Worked Thankyou.
Task: TempPrecise
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: Read File [
File: Download/CSV File Viewer/hi.txt
To Var: %textfile
Structure Output (JSON, etc): On ]
A4: Variable Search Replace [
Variable: %textfile
Search: \bkey\w*\b
Store Matches In Array: %textkeys ]
A5: Write File [
File: Download/CSV File Viewer/antextbig an.txt
Text: %textkeys()
Add Newline: On ]
A6: Read File [
File: Download/CSV File Viewer/antextbig an.txt
To Var: %textfilewithkeys
Structure Output (JSON, etc): On ]
A7: Variable Set [
Name: %newline
To:
Structure Output (JSON, etc): On ]
A8: Variable Set [
Name: %newspace
To:
Structure Output (JSON, etc): On ]
A9: Variable Search Replace [
Variable: %textfilewithkeys
Search: ,
Replace Matches: On
Replace With: %newspace ]
A10: Variable Search Replace [
Variable: %textfilewithkeys
Search:
Replace Matches: On
Replace With: %newline ]
A11: Variable Set [
Name: %text_data
To: %textfilewithkeys
Structure Output (JSON, etc): On ]
A12: Variable Split [
Name: %text_data
Splitter: %newline ]
A13: Read File [
File: Download/CSV File Viewer/2010.csv
To Var: %csv_data
Structure Output (JSON, etc): On ]
A14: Variable Set [
Name: %to_search
To: %text_data(+/)
Structure Output (JSON, etc): On ]
A15: Stop [ ]
If [ %csv_data.Header3(#?%to_search) eq 0 ]
A16: Array Set [
Variable Array: %indexes_of_matches
Values: %csv_data.Header3(#?%to_search)
Splitter: , ]
A17: Variable Set [
Name: %wrap
To: %indexes_of_matches(#)+1
Do Maths: On
Max Rounding Digits: 3
Structure Output (JSON, etc): On ]
A18: Variable Add [
Name: %Increment
Value: 1
Wrap Around: %wrap ]
A19: Variable Set [
Name: %Increment
To: 1
Structure Output (JSON, etc): On ]
If [ %Increment ~ 0 ]
A20: Variable Set [
Name: %next
To: %indexes_of_matches(%Increment)
Structure Output (JSON, etc): On ]
A21: Flash [
Text: %csv_data.Header3(%next)
Continue Task Immediately: On
Dismiss On Click: On ]
A22: 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 ]
A23: Write File [
File: Download/177.txt
Text: %csv_data.Header3(%next)
Add Newline: On ]
Comments
Post a Comment