Parse Text

[bertal34]

Hello,

Is there a clean way to parse the attached Text?  I am trying to arrive at the Metric/Value fields but having trouble with a parsing solution capable of working for all scenarios.

thanks!

[AGilbert]

That is a tricky set of strings. As a first step you could replace the first occurrence of more than one space with a ':' as a common character to split the key/value pairs. Just an idea that might help piecemeal the problem. 

[Yoshiro_Fujimori · Accepted solution]

Hi @bertal34 ,

I would use Column To Text after replacing the parsing patterns with a separator.

I hope this helps.

Input

Text

Case 1: Separated with colon + space

Case 2   Separated with more than two spaces

Case 3  Separated with more than two spaces  and multiple  fields

Output

Text	1	2
Case 1: Separated with colon + space	Case 1	Separated with colon + space
Case 2   Separated with more than two spaces	Case 2	Separated with more than two spaces
Case 3  Separated with more than two spaces  and multiple  fields	Case 3	Separated with more than two spaces

Workflow

Text To Column Configuration

[bertal34]

@Yoshiro_Fujimori perfect solution, thank you!