need shell command to wrap text &adjust column width (csv file )

Sankaran29 · 12-17-2012, 07:40 AM

Hi!

I've written a shell script to monitor the log file and output the lines which include "exception" pattern in it.

I'm receiving the report in csv format via mail .The problem is with csv report format (Lines are too long ). Evrytime i open the report , have to manually adjust the column width and wrap text it. (Alignment--->Text control --> wrap text).

Please let me know if thr is any command in shell to adjust column width and wraptext the csv report before emailing it.

Thanks in advance!!

markush · 12-17-2012, 08:10 AM

Hello Sankaran29, welcome to LQ,

which tools do you use in your shellscript? afaik the printf function in AWK works similar as in C, so it should be possible, to format the output with AWK. It is explained in the manpage for AWK.

For more help, please post your script and some example output.

Markus

shivaa · 12-17-2012, 08:24 AM

Does that report contains lot of CSV, which are not wrapped? Once share sample file plus output that you want. It then can be easily formatted with awk in desired way.

Sankaran29 · 12-17-2012, 08:49 AM

grep i "Exception" Logfile.txt > Temp.out
sed s/,/\./g <Temp.out | awk -f '{Printf $1}' > Temp.csv

unencode and mailx commands to send the output csv to my mail id

sorry i'm not allowed to upload files from my wks.

my output Temp.csv file contains 147 long lines with exceptions like Rollback ,sqlsyntax exceptions ... with different column width eg: Column A1 width is more than 170 Column A2 line width is 75 ,A3 :180 till ... A147

Thanks for responding .

Sankaran29 · 12-17-2012, 08:57 AM

Need CSV output report with all 147 lines with some fixed width

shivaa · 12-17-2012, 09:29 AM

Perhaps you've trying to copy the data of temp.csv into excel sheet to adjust columns. But to be honest, it's really tough to answer without knowing the exaxt input file pattern and output pattern. Although it can be done using awk, but as I said, it's still not clear.
Once share a sample (just dummy entries, but exactly in same format as it is in temp.out file). In the meantime, commands your using can be shortend as:

Code:

awk '/Exception/; {gsub(/,/,".",$0}; print $0}' Logfile.txt >  temp.out

I did not get why you converted "," into "."? Are entries "," sepearte in logfile?

theNbomr · 12-17-2012, 09:33 AM

There is no standard way to split an individual field of a CSV file; any algorithm to do so would be completely domain-specific. Given that, it is unlikely that anyone can guess how to to split your data. You don't have to upload files to provide sample data, just copy/paste some representative data into your posting. Use [CODE][/CODE] tags (vital) to preserve formatting so people can suggest parsers that actually work.
--- rod.