User Tools

Site Tools


howtos:manipulate_cvs_file

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
howtos:manipulate_cvs_file [01/09/2017 15:30] domingohowtos:manipulate_cvs_file [02/12/2018 21:34] (current) – external edit 127.0.0.1
Line 1: Line 1:
 +
 +
 +<code>
 +awk -F"," -v q='"' '{ print q $2 q " " ":=" " " q $1,$3,$4,$5,$6,$7,$8 q"," }' fil1.txt > dg.txt
 +</code>
 +
 +|-v q='"'| is used to insert double quotes around the key-value pairs with q as variable containing the quotes|
 +|-F","| the file is comma separated so we tell awk to that as field separator|
 +
 +
 +
 +fil1.txt
 +<file>
 +DHE-RSA-DES-CBC-SHA,0x15,64,TLS1-TLS1.1-TLS1.2-DTLS1,EDH,RSA,DES,SHA
 +DHE-RSA-DES-CBC3-SHA,0x16,168,TLS1-TLS1.1-TLS1.2-DTLS1,EDH,RSA,DES,SHA
 +ADH-RC4-MD5,0x18,128,TLS1,ADH,None,RC4,MD5
 +ADH-DES-CBC-SHA,0x1a,64,TLS1,ADH,None,DES,SHA
 +ADH-DES-CBC3-SHA,0x1b,168,TLS1,ADH,None,DES,SHA
 +AES128-SHA,0x2f,128,TLS1-TLS1.1-TLS1.2-DTLS1,RSA,RSA,AES,SHA
 +DHE-DSS-AES128-SHA,0x32,128,TLS1-TLS1.1-TLS1.2-DTLS1,DHE,DSS,AES,SHA
 +DHE-RSA-AES128-SHA,0x33,128,TLS1-TLS1.1-TLS1.2-DTLS1,EDH,RSA,AES,SHA
 +ADH-AES128-SHA,0x34,128,TLS1,ADH,None,AES,SHA
 +AES256-SHA,0x35,256,TLS1-TLS1.1-TLS1.2-DTLS1,RSA,RSA,AES,SHA
 +DHE-DSS-AES256-SHA,0x38,256,TLS1-TLS1.1-TLS1.2-DTLS1,DHE,DSS,AES,SHA
 +DHE-RSA-AES256-SHA,0x39,256,TLS1-TLS1.1-TLS1.2-DTLS1,EDH,RSA,AES,SHA
 +ADH-AES256-SHA,0x3a,256,TLS1,ADH,None,AES,SHA
 +AES128-SHA256,0x3c,128,TLS1.2,RSA,RSA,AES,SHA256
 +AES256-SHA256,0x3d,256,TLS1.2,RSA,RSA,AES,SHA256
 +RC4-MD5,0x4,128,TLS1-TLS1.1-TLS1.2,RSA,RSA,RC4,MD5
 +...
 +...
 +...
 +</file>
 +
 +dg.txt
 +<file>
 +"0x15" := "DHE-RSA-DES-CBC-SHA 64 TLS1-TLS1.1-TLS1.2-DTLS1 EDH RSA DES SHA",
 +"0x16" := "DHE-RSA-DES-CBC3-SHA 168 TLS1-TLS1.1-TLS1.2-DTLS1 EDH RSA DES SHA",
 +"0x18" := "ADH-RC4-MD5 128 TLS1 ADH None RC4 MD5",
 +"0x1a" := "ADH-DES-CBC-SHA 64 TLS1 ADH None DES SHA",
 +"0x1b" := "ADH-DES-CBC3-SHA 168 TLS1 ADH None DES SHA",
 +"0x2f" := "AES128-SHA 128 TLS1-TLS1.1-TLS1.2-DTLS1 RSA RSA AES SHA",
 +"0x32" := "DHE-DSS-AES128-SHA 128 TLS1-TLS1.1-TLS1.2-DTLS1 DHE DSS AES SHA",
 +"0x33" := "DHE-RSA-AES128-SHA 128 TLS1-TLS1.1-TLS1.2-DTLS1 EDH RSA AES SHA",
 +"0x34" := "ADH-AES128-SHA 128 TLS1 ADH None AES SHA",
 +"0x35" := "AES256-SHA 256 TLS1-TLS1.1-TLS1.2-DTLS1 RSA RSA AES SHA",
 +"0x38" := "DHE-DSS-AES256-SHA 256 TLS1-TLS1.1-TLS1.2-DTLS1 DHE DSS AES SHA",
 +"0x39" := "DHE-RSA-AES256-SHA 256 TLS1-TLS1.1-TLS1.2-DTLS1 EDH RSA AES SHA",
 +"0x3a" := "ADH-AES256-SHA 256 TLS1 ADH None AES SHA",
 +"0x3c" := "AES128-SHA256 128 TLS1.2 RSA RSA AES SHA256",
 +"0x3d" := "AES256-SHA256 256 TLS1.2 RSA RSA AES SHA256",
 +"0x4" := "RC4-MD5 128 TLS1-TLS1.1-TLS1.2 RSA RSA RC4 MD5",
 +"0x40" := "DHE-DSS-AES128-SHA256 128 TLS1.2 DHE DSS AES SHA256",
 +"0x41" := "CAMELLIA128-SHA 128 TLS1-TLS1.1-TLS1.2 RSA RSA CAMELLIA SHA",
 +"0x44" := "DHE-DSS-CAMELLIA128-SHA 128 TLS1-TLS1.1-TLS1.2 DHE DSS CAMELLIA SHA",
 +"0x45" := "DHE-RSA-CAMELLIA128-SHA 128 TLS1-TLS1.1-TLS1.2 EDH RSA CAMELLIA SHA",
 +"0x5" := "RC4-SHA 128 TLS1-TLS1.1-TLS1.2 RSA RSA RC4 SHA",
 +"0x67" := "DHE-RSA-AES128-SHA256 128 TLS1.2 EDH RSA AES SHA256",
 +"0x6a" := "DHE-DSS-AES256-SHA256 256 TLS1.2 DHE DSS AES SHA256",
 +"0x6b" := "DHE-RSA-AES256-SHA256 256 TLS1.2 EDH RSA AES SHA256",
 +"0x84" := "CAMELLIA256-SHA 256 TLS1-TLS1.1-TLS1.2 RSA RSA CAMELLIA SHA",
 +"0x87" := "DHE-DSS-CAMELLIA256-SHA 256 TLS1-TLS1.1-TLS1.2 DHE DSS CAMELLIA SHA",
 +"0x88" := "DHE-RSA-CAMELLIA256-SHA 256 TLS1-TLS1.1-TLS1.2 EDH RSA CAMELLIA SHA",
 +"0x9" := "DES-CBC-SHA 64 TLS1-TLS1.1-DTLS1 RSA RSA DES SHA",
 +"0x9c" := "AES128-GCM-SHA256 128 TLS1.2 RSA RSA AES-GCM SHA256",
 +"0x9d" := "AES256-GCM-SHA384 256 TLS1.2 RSA RSA AES-GCM SHA384",
 +...
 +...
 +...
 +</file>
  
howtos/manipulate_cvs_file.txt · Last modified: 02/12/2018 21:34 by 127.0.0.1