Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- XiaoLi,6705462234,lxiao@unc.edu,NC764
- NatkinPook,8044344528,wnatkin@vcu.edu,VA22345
- EliziMoe,5208534566,emoe@ncsu.edu,AZ85282
- MaTa,4345667345,mta@yahoo.com,TX91030
- DianaCheng,5203456789,dcheng@asu.edu,WY4587
- JacksonFive,5206564573,jfive@ncsu.edu,AZ85483
- AdiSrikanthReddy,6578904566,sadi1@asu.edu,WS67854
- Xiao Li 6705462234 lxiao@unc.edu NC 764
- Natkin Pook 8044344528 wnatkin@vcu.edu VA 22345
- Elizi Moe 5208534566 emoe@ncsu.edu AZ 85282
- Ma Ta 4345667345 mta@yahoo.com TX 91030
- Diana Cheng 5203456789 dcheng@asu.edu WY 4587
- Jackson Five 5206564573 jfive@ncsu.edu AZ 85483
- Adi SrikanthReddy 6578904566 sadi1@asu.edu WS 67854
- awk -F "," ' {print $1, $4, $3, $6}' data3
- awk -F, '
- {c = match($1,/[a-z][A-Z]/)}
- c>0 {$1 = sprintf("%s %s", substr($1,1,c), substr($1,c+1))}
- {c = match($4,/[A-Z][0-9]/)}
- c>0 {$4 = sprintf("%s %s", substr($4,1,c), substr($4,c+1))}
- 1' file.csv
- Xiao Li 6705462234 lxiao@unc.edu NC 764
- Natkin Pook 8044344528 wnatkin@vcu.edu VA 22345
- Elizi Moe 5208534566 emoe@ncsu.edu AZ 85282
- Ma Ta 4345667345 mta@yahoo.com TX 91030
- Diana Cheng 5203456789 dcheng@asu.edu WY 4587
- Jackson Five 5206564573 jfive@ncsu.edu AZ 85483
- Adi SrikanthReddy 6578904566 sadi1@asu.edu WS 67854
- awk -F, '
- {c = match($1,/[a-z][A-Z]/)}
- c>0 {$1 = sprintf("%s %s", substr($1,1,c), substr($1,c+1))}
- {$4 = sprintf("%s %s", substr($4,1,2), substr($4,3))}
- 1' file.csv
- perl -F, -ne '
- print join " ", map { s/(?<=[[:lower:]])(?=[[:upper:]])|(?<=[[:upper:]])(?=[[:digit:]])/ /; $_ } @F
- ' file.csv
- Xiao Li 6705462234 lxiao@unc.edu NC 764
- Natkin Pook 8044344528 wnatkin@vcu.edu VA 22345
- Elizi Moe 5208534566 emoe@ncsu.edu AZ 85282
- Ma Ta 4345667345 mta@yahoo.com TX 91030
- Diana Cheng 5203456789 dcheng@asu.edu WY 4587
- Jackson Five 5206564573 jfive@ncsu.edu AZ 85483
- Adi SrikanthReddy 6578904566 sadi1@asu.edu WS 67854
- awk '
- { gsub(","," ")
- $0=gensub("([[:upper:]])([[:digit:]])","\1 \2","g")
- $0=gensub("([[:lower:]])([[:upper:]])","\1 \2","g")
- print
- }' file.csv
Add Comment
Please, Sign In to add comment