I have got data in the following form :
username:hash:email:ip
但是这些值本身没有分隔符。
我的问题是，当用户名包含冒号或更多的用户名将数据导入Excel时，它会创建一个新列，因此使我很难处理这些数据。
And option would be to add delimiters to the values like ". I guess that we could make a regular expression that matches the hash and the colon before it and then enclose everything before this regular expression into quotes but I don't really know how to do that.
Example : Image
