In order to use SQL bulk insert command, I need to convert a text file (5mb) as below to a csv file
35*20120527*WQ*1900.38@
220*20131020*QQ*454@
1) change "*" to "|" as field terminator
2) change "@" to "\n" as row terminator
Can someone help me?
Go to the complete details ...