Forum Discussion
Culling for different data across a text string
Good morning all. We've inherited a set of data sourced from SharePoint. One of the key pieces of data we need to access and interact with is burried within a column populated from a workflow (whic...
Is it possible to string together Extract and Deliminate functions? I tried splicing them together, but received an error:
Split: = Table.TransformColumns(#"Removed Columns", {{"Log", each Text.AfterDelimiter(_, ",", 6), type text}})
Deliminate: = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Log.1", Int64.Type}, {"Log.2", type text}, [etc. etc.]
Equally, if I could limit the split or extraction to clauses (between commas) that only contain values I need, it would help remove the extra data I don't need.