I'm trying to get text strings separated by hyphens to parse out (like text to columns) in a Webi query. Does anyone know what the SQL statement is to do this? Or is there built-in functionality for this in Webi? Struggling!
You would have to do that in the SQL I would think (rather than WEBI), and I think you would then need to know how many such columns you expect?
SQL Sever version would be something like the answer given here ; How to split one column into two columns in SQL Server - Stack Overflow
Retrieving data ...