fork download
copy 
  1. #!/bin/bash
  2. s='2020/10/26,249.00,Test10028
  3. 2020/10/24,569.00,Test 00074
  4. 2020/10/24,1999.00,0016 1708fqb8ba
  5. 2020/10/24,1399.00,00450 165058hb1bda
  6. 2020/10/23,399.00,Att-10170 158bb8ba
  7. 2020/10/22,599.00,Ref:10150 1605fk0bsf
  8. 2020/10/22,5669.00,1605fk0bsf'
  9. rx='([^0-9]|^)([01][0-9]{3,4})([^[:alnum:],][^,]*)?$'
  10. awk -v r=$rx 'BEGIN{FS=OFS=","} {print ($3 ~ r) ? $0 OFS gensub(r, "\\1\\2\\3,\\2", 1, $3) : $0 OFS}' <<< "$s"
  11.  
Success #stdin #stdout 0s 5032KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
2020/10/26,249.00,Test10028,Test10028,10028
2020/10/24,569.00,Test 00074,Test 00074,00074
2020/10/24,1999.00,0016 1708fqb8ba,0016 1708fqb8ba,0016
2020/10/24,1399.00,00450 165058hb1bda,00450 165058hb1bda,00450
2020/10/23,399.00,Att-10170 158bb8ba,Att-10170 158bb8ba,10170
2020/10/22,599.00,Ref:10150 1605fk0bsf,Ref:10150 1605fk0bsf,10150
2020/10/22,5669.00,1605fk0bsf,
https://ideone.com/x2Vwhw
language:
Bash (bash 5.0.3)
created:
5 years ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!