Guest User

Untitled

a guest
Mar 22nd, 2018
508
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.04 KB | None | 0 0
  1. XiaoLi,6705462234,lxiao@unc.edu,NC764
  2. NatkinPook,8044344528,wnatkin@vcu.edu,VA22345
  3. EliziMoe,5208534566,emoe@ncsu.edu,AZ85282
  4. MaTa,4345667345,mta@yahoo.com,TX91030
  5. DianaCheng,5203456789,dcheng@asu.edu,WY4587
  6. JacksonFive,5206564573,jfive@ncsu.edu,AZ85483
  7. AdiSrikanthReddy,6578904566,sadi1@asu.edu,WS67854
  8.  
  9. Xiao Li 6705462234 lxiao@unc.edu NC 764
  10. Natkin Pook 8044344528 wnatkin@vcu.edu VA 22345
  11. Elizi Moe 5208534566 emoe@ncsu.edu AZ 85282
  12. Ma Ta 4345667345 mta@yahoo.com TX 91030
  13. Diana Cheng 5203456789 dcheng@asu.edu WY 4587
  14. Jackson Five 5206564573 jfive@ncsu.edu AZ 85483
  15. Adi SrikanthReddy 6578904566 sadi1@asu.edu WS 67854
  16.  
  17. awk -F "," ' {print $1, $4, $3, $6}' data3
  18.  
  19. awk -F, '
  20. {c = match($1,/[a-z][A-Z]/)}
  21. c>0 {$1 = sprintf("%s %s", substr($1,1,c), substr($1,c+1))}
  22. {c = match($4,/[A-Z][0-9]/)}
  23. c>0 {$4 = sprintf("%s %s", substr($4,1,c), substr($4,c+1))}
  24. 1' file.csv
  25. Xiao Li 6705462234 lxiao@unc.edu NC 764
  26. Natkin Pook 8044344528 wnatkin@vcu.edu VA 22345
  27. Elizi Moe 5208534566 emoe@ncsu.edu AZ 85282
  28. Ma Ta 4345667345 mta@yahoo.com TX 91030
  29. Diana Cheng 5203456789 dcheng@asu.edu WY 4587
  30. Jackson Five 5206564573 jfive@ncsu.edu AZ 85483
  31. Adi SrikanthReddy 6578904566 sadi1@asu.edu WS 67854
  32.  
  33. awk -F, '
  34. {c = match($1,/[a-z][A-Z]/)}
  35. c>0 {$1 = sprintf("%s %s", substr($1,1,c), substr($1,c+1))}
  36. {$4 = sprintf("%s %s", substr($4,1,2), substr($4,3))}
  37. 1' file.csv
  38.  
  39. perl -F, -ne '
  40. print join " ", map { s/(?<=[[:lower:]])(?=[[:upper:]])|(?<=[[:upper:]])(?=[[:digit:]])/ /; $_ } @F
  41. ' file.csv
  42. Xiao Li 6705462234 lxiao@unc.edu NC 764
  43. Natkin Pook 8044344528 wnatkin@vcu.edu VA 22345
  44. Elizi Moe 5208534566 emoe@ncsu.edu AZ 85282
  45. Ma Ta 4345667345 mta@yahoo.com TX 91030
  46. Diana Cheng 5203456789 dcheng@asu.edu WY 4587
  47. Jackson Five 5206564573 jfive@ncsu.edu AZ 85483
  48. Adi SrikanthReddy 6578904566 sadi1@asu.edu WS 67854
  49.  
  50. awk '
  51. { gsub(","," ")
  52. $0=gensub("([[:upper:]])([[:digit:]])","\1 \2","g")
  53. $0=gensub("([[:lower:]])([[:upper:]])","\1 \2","g")
  54. print
  55. }' file.csv
Add Comment
Please, Sign In to add comment