当值本身包含冒号时,处理冒号分隔的值

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

评论