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!
Solved! Go to 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
@Yoshiro_Fujimori perfect solution, thank you!