I have the attached txt file whereby starting at row 10, I need the value in field 1 to be parsed into two columns: i.e. FUND SELECTION OPTION is the Key value and EXCLUDE is the Value value and so forth. The expression currently within the attached workflow (Regex tool) was working previously, but then the report format was recently altered and it no longer traps the Value values. Can someone help me tweak the Regex formula to get this to work?
Instead of \s{5,}(.*?)\s{5,}(.*?)\s{5,}.*
Try this ^(.+?)\s{5,}(.+)$
Explanation from the regex101 site.
Thanks. However, that solution didn't seem to do the parsing as was hoped for. But, I was able to resolve by keeping to my original expression but adding a padright formula beforehand to ensure a min character count per line of 132. For reference I've reattached a new version of the workflow. It includes both solutions for comparison purposes.