Support Questions

VidyaSargur · ‎12-30-2019

Hi All,

I have to display the records of csv file over mail body in tabular format using Putmail.

I am extracting records by executing sql which is scheduled at some duration and than forwarding the same using putmail to some specific users.

Can someone please tell me how to display the data of generated csv file in tabular format.

stevenmatison · ‎12-30-2019

To get it into a table, you need something like this:

<table><tr><td>
${'$1':replace(',','</td><td>'):replace('\n','</td></tr>\n<tr><td>')}
</td></tr></table>

and it should output an HTML Table like this:

<table><tr><td>
Release Cause</td><td>Previous Count</td><td>Current Count</td><td>Change_Ratio</td><td>SEVERITY</td>
</tr><tr><td>SIP: [487] Request Terminated</td><td>173</td><td>393</td><td>1.271676300578034682</td><td>Critical
</td></tr></table>

You may have to play with the last </td></tr> depending on if you have an empty line on bottom or not.

You may also have to adjust \n to \r\n again depending on the source file actual return chars (not seen they are hidden).

View solution in original post

ashishtiw26 · ‎09-30-2021

Yes Sumita, it worked.

Cloudera Community

Support Questions

Nifi || Mail || Display csv files content in tabular format.

Create custom format from the csv file content usi...

NIFI read different file format and convert it to ...

Converting a Large JSON File into CSV

Processing files within the CML EFS (better I/O pe...

NiFi : combine flow file attribute and content

HDF/NiFi to convert row-formatted text files to co...

Ingesting a Big CSV file into Kafka using a multi-...

Capture de content of a file in Nifi from HDFS

How to merge many json files in one csv file in NI...

How to process corrupted CSV data with NiFi