How to convert the text tables from email body to HTML tables

[MeenaRK]

Hi Team,

Is there a way to convert the text tables to html table and extract only the required rows based on condition 

The condition is "%Used" column >50 from the below sample body of email screenshot.

Screenshot

[VJR]

Hello @MeenaRK 

Could you check out any of the existing actions are showing the near about results.

Also try out other options like writing that data from the email to Excel and then see if it arranges itself in a better way.

PS: the image in the screenshot is not clear when opened. 




-------------------------------------------
Help fellow beings find relevant posts.
Upvote to a supporting response.
Mark as solution to an answer.

[MeenaRK]

This is the format of the text tables: 

**********************************************

CLF database tablepace and datafile usage report at Mon Sep 20 16:00:00 IST 2021

**********************************************

Tablespace SIZE (MB) FREE (MB) % Free % Used
------------------------------- ------------ ------------ ------------ ------------
XDB 50 50 100 0
TOOLS 95 95 100 0
PERFSTAT 8,000 7,998 100 0
CLARIFY_CLEANUP 100 100 100 0
CLARIFY_INTERACT03 243 243 100 0
CLARIFY_INTERACT04 300 300 100 0
CLARIFY_INTERACT01 400 400 100 0
CLARIFY_ARC_INDEX 350 350 100 0
TEMP1 47,473 47,470 100 0
UNDOTBS1 49,000 48,447 99 1
CLARIFY_ARC_DATA 355 353 99 1
UNDOTBS2 27,566 26,555 96 4
CLARIFY_LOOKUP_DATA 86,062 82,590 96 4
SYSTEM 11,540 10,911 95 5
USERS 2,168 2,027 93 7
DELANO 45 39 87 13
CLARIFY_LOOKUP_INDEX 8,271 6,358 77 23
TERA_DATA 1,000 678 68 32
CLARIFY_INTERACT_INDEX02 79,758 53,337 67 33
CLARIFY_INTERACT_INDEX01 105,873 67,151 63 37
CLARIFY_INTERACT02 83,276 50,700 61 39
CLARIFY_CONFIG_INDEX 110 56 51 49
AUDIT_TS 639 255 40 60
CLARIFY_CONFIG_DATA 1,506 605 40 60
CLARIFY_RETENTION_DATA 194 67 34 66
CLARIFY_TRANS_INDEX 207,656 53,799 26 74
CLARIFY_TRANS_DATA 439,698 71,047 16 84

27 rows selected.

TABLESPACE CURRENT_DATAFILES_SIZE (MB) MAX_DATAFILES_SIZE (MB)
------------------------------ --------------------------- -----------------------
AUDIT_TS 639 3,339
CLARIFY_ARC_DATA 355 8,305
CLARIFY_ARC_INDEX 350 8,300
CLARIFY_CLEANUP 100 6,000
CLARIFY_CONFIG_DATA 1,506 3,006
CLARIFY_CONFIG_INDEX 110 1,100
CLARIFY_INTERACT01 400 25,200
CLARIFY_INTERACT02 83,276 105,300
CLARIFY_INTERACT03 243 243
CLARIFY_INTERACT04 300 15,200
CLARIFY_INTERACT_INDEX01 105,873 111,368
CLARIFY_INTERACT_INDEX02 79,758 99,600
CLARIFY_LOOKUP_DATA 86,062 95,170
CLARIFY_LOOKUP_INDEX 8,271 8,271
CLARIFY_RETENTION_DATA 194 32,961
CLARIFY_TRANS_DATA 439,698 453,637
CLARIFY_TRANS_INDEX 207,656 207,656
DELANO 45 32,768
PERFSTAT 8,000 8,000
SYSTEM 11,540 13,540
TERA_DATA 1,000 10,000
TOOLS 95 2,000
UNDOTBS1 49,000 49,000
UNDOTBS2 27,566 27,567
USERS 2,168 2,168
XDB 50 50

26 rows selected.

*****************************************

Finished

******************************************

[MeenaRK]

Hi VJR,

Thank you for your support.

Screenshot of the email Body 

I have tried but I get an error:

[VJR]

Hi @MeenaRK 

Take a look about converting from string to Array to be able to be passed to these two Compose actions.

If that's not possible then perhaps an option would be going line by line starting from the dashes "---", then using string functions getting the characters from the right just after the last space, until it finds the word "selected"

And then fetch it only if that value is >50.

Tablespace SIZE (MB) FREE (MB) % Free % Used
------------------------------- ------------ ------------ ------------

XDB 50 50 100 0
TOOLS 95 95 100 0

.

.

27 rows selected.

If you come across an easier way do post back here.

Would also like to share you an Excel formula based approach if you decide to write that content to an Excel.

Formula for reference: 

=RIGHT($A11,LEN($A11)-FIND("@",SUBSTITUTE($A11," ","@",LEN($A11)-LEN(SUBSTITUTE($A11," ",""))),1))

-------------------------------------------
Help fellow beings find relevant posts.
Upvote to a supporting response.
Mark as solution to an answer.