Forum Discussion
gazzo1967
Helper III
Helper IIICopy text from Delimiter Text field to specific Columns
HI All I have a field that has multiple text strings in it which is delimiter with a semi colon. What i would like to do is copy each specfic text string to its own column. I have a single cell wi...
If there are only to be 4 possible values (and therefore 4 columns), you could add 4 custom columns , each one using a slightly different version of : if Text.Contains([the1stColumn], "FF1") then "FF1" else null
HotChilli
Community Champion
Community ChampionIf there are only to be 4 possible values (and therefore 4 columns), you could add 4 custom columns , each one using a slightly different version of : if Text.Contains([the1stColumn], "FF1") then "FF1" else null