Wednesday, October 26, 2022

[SOLVED] Split filenames at delimiter and write to HTML table

Issue

I am attempting to split some filenames which contain data in their names and export this into different columns in a HTML table. An example filename is below:

 10.129.18.225,9998,builtin-v10.conf

There are multiple files in the directory with the same format (IP address, Port Number, builtin-v(5,7,9 or 10) that I need to perform this action on as well. New files are constantly added and removed.

My aim is to be able to split the filename using the ',' as a delimiter/separator and import the different variables of the filename into a HTML table like below:

Collector IP Address Collector Port Netflow Version
10.129.18.225 9998 builtin-v10
10.0.0.0 9000 builtin-v9

I have taken a look at a few different posts which seem to be similar but I was just wondering the best way to achieve this in bash?

I have the following script at the moment but I don't think it is correct.

    #!/bin/bash

$file="/usr/local/flowsim/data/*.conf"
data=$(echo $file | cut -d"," -f1 | tr -d ",")

Collector=$(echo $file | cut -d"," -f1) >> "/usr/local/flowsim/active-flows.html"
Port=$(echo $file | cut -d"," -f2 | cut -d"," -f1)

Any suggestions or examples would be greatly appreciated!


Solution

Another approach is to use the =~ operator in bash.

#!/usr/bin/env bash

shopt -s nullglob

for file in /usr/local/flowsim/data/*,*,*.conf; do
  [[ $file =~ ([^/]+),(.+),(.+)\.conf$ ]] &&
  ip=${BASH_REMATCH[1]}
  port=${BASH_REMATCH[2]}
  version=${BASH_REMATCH[3]}
  printf '%s\n%s\n%s\n' "$ip" "$port" "$version"
done

import the different variables of the filename into a HTML table

Something like this maybe.

#!/usr/bin/env bash

head='<!DOCTYPE html>
<html>
<style>
table, th, td {
  border:1px solid black;
}
</style>
<body>
<h2>A basic HTML table</h2>
<table style="width:50%">
  <tr>
    <th>Collector IP Addess</th>
    <th>Collector Port</th>
    <th>Netflow Version</th>
  </tr>'

tail='</table>
</body>
</html>'

printf '%s\n' "$head"

shopt -s nullglob

for file in /usr/local/flowsim/data/*,*,*.conf; do
  [[ $file =~ ([^/]+),(.+),(.+)\.conf$ ]] &&
  ip=${BASH_REMATCH[1]}
  port=${BASH_REMATCH[2]}
  version=${BASH_REMATCH[3]}
  printf ' <tr>\n    <td>%s</td>\n    <td>%s</td>\n    <td>%s</td>\n </tr>\n' "$ip" "$port" "$version"
done

printf '%s\n' "$tail"

Now you can point the script to a file, e.g.

my_script > output.html


Answered By - Jetchisel
Answer Checked By - Marie Seifert (WPSolving Admin)
at