Help in Regex Expression

[James89]

Hi,

I am trying to split a string with the following format into 8 separate columns.

TEAM||Manchester|London||City|Derby|Number of Players|Man of the Match|Match Day

I have tried using Regex expression ([^|]*) as suggested doesn't work out that way. Any tips that could help solve this issue?

Thanks!

[Deano478]

hey @James89 this could be neater but this will do it for you

([^|]+)\|\|([^|]+)\|([^|]+)\|\|([^|]+)\|([^|]+)\|([^|]+)\|([^|]+)\|([^|]+)

[OTrieger]

@James89 
It can be done also with the use of Text To Column tool, Using Pipe as the delimiter.

[DataNath · Accepted solution]

Hey @James89, the following ought to work in the RegEx tool in Tokenize mode, splitting to 8 fields:

([^|]+)\|?

[James89]

Thanks @DataNath ! It really works.