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

[#1]

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.

[#2]

A replaceText processor can change from Comma Separated to Tab Separated.  This would be the easiest option.   Configured with [tab] in Search Value, and [,] in Replacement Value:

[#3]

Hi,

I tried doing the same by replacetext but I am getting the output as:

Release Cause,Previous Count,Current Count,Change_Ratio,SEVERITY

test_data,276,730,1.644927536231884058,Critical

but i want the same output in tabular format:

Release Cause	Previous Count	Current Count	Change_Ratio	SEVERITY
test_data	276	730	1.644927536231884058	Critical

Please help for the same.

[#4]

If the output is still comma separated, then replace text did not work.  The solution above is how you do it.  You may need to experiment with other replacements. For example maybe \t instead of [tab].  Again, the method above is what you need.

Here is a similar post that includes some of the other forms of "tab"... 

https://community.cloudera.com/t5/Support-Questions/How-best-to-replace-all-TABs-t-by-COMMAs-in-the-...

[#5]

Thanks for your help but this is not solving my problem as i want the csv record which itself is in comma separated to be displayed in tabular format as in my mail body through PUTMAIL.

I want records to be displayed in table format rather than comma separated or tab one.

I have comma separated record :

Release Cause,Previous Count,Current Count,Change_Ratio,SEVERITY

SIP: [487] Request Terminated,173,393,1.271676300578034682,Critical

and I want like this in mail body:

Release Cause	Previous Count	Current Count	Change_Ratio	SEVERITY
test_data	276	730	1.644927536231884058	Critical

Please suggest a suitable method in order to do the same.

[#6]

I understand you are not able to figure out the exact ReplaceText syntax that you need.  I have quickly created a flow and validated the following works as demonstrated.  I had to use \t to match your string:

Output:

The regex you need is:  

${'$1':replace(',','\t')}

Table formatting is something entirely different and is not part of "csv" parsing....

[#7 · Accepted solution]

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).

[#8]

Thanks Stevenmatison.

It worked!!

[#9]

Hi Steven,

Your solution worked well. 

but i have a question related to this topic.

In Putemail, for the solution you provided i am using content type 'text\html' which is delivering result in table format (in mail body) but  i am also attaching csv  in my mail.

Now this csv is also displaying data with html tag, is it possible to display the data in original form.(only csv format for attachment without html tag).

[#10]

Hello Ashish,

Wanted to check whether you were able to solve this problem. As I have to do something similar. Your help would be appreciated 🙂