Loading text from a file to send in body of HTML email

prashant
Topic Author
Offline
Platinum Member

More

2 years 2 months ago #23892 by prashant

Replied by prashant on topic Loading text from a file to send in body of HTML email

Though some help with chatgpt with script , I was able to convert vanilla html tables into a decent looking styles

Code:

{ Using Replace we provide styling to table }
begin SetVariable('#file-content#',FileToString(GetVariable('#file#')));
SetVariable('#file-content#', Replace(GetVariable('#file-content#'), '<table>', '<table style="width: 100%; max-width: 600px; border-collapse: collapse;">'));
SetVariable('#file-content#', Replace(GetVariable('#file-content#'), '<thead>', '<thead style="background-color: black; color: white;">'));
SetVariable('#file-content#', Replace(GetVariable('#file-content#'), '<th>','<th style="padding: 10px; text-align: left; border-bottom: 1px solid #ddd; font-weight: bold;">')); SetVariable('#file-content#', Replace(GetVariable('#file-content#'), '<td>','<td style="padding: 10px; text-align: left; border-bottom: 1px solid #ddd;">'));
Result:=True;
end;

The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

admin
Offline
Administrator
Deeds not Words

More

2 years 2 months ago #23894 by admin

Replied by admin on topic Loading text from a file to send in body of HTML email

You can also use file operation to replace string

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

prashant
Topic Author
Offline
Platinum Member

More

2 years 2 months ago #23895 by prashant

Replied by prashant on topic Loading text from a file to send in body of HTML email

Holy cow !! that's even better ! Thanks for pointing this out

I assume File operation can accept the file location from "LOOP+Read Multi Variable" ?

The following user(s) said Thank You: Peter.Jonson

Please Log in or Create an account to join the conversation.

Peter.Jonson
Offline
Administrator

More

2 years 2 months ago #23896 by Peter.Jonson

Replied by Peter.Jonson on topic Loading text from a file to send in body of HTML email

I assume File operation can accept the file location from "LOOP+Read Multi Variable" ?

Yes it will

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

ETL Forum