Forum Discussion

BassG's avatar
BassG
Icon for Helper I rankHelper I
3 years ago
Solved

Is it possible to Trim leading/trailing spaces using transform data?

Using an excel file as my source, there's a column called "Incident" which has the types of incident such as "Physical Assault", "Threatening behaviour", "Throwing an object" & so on.  There's 11 different incident types.
If there was more than one incident, then each incident is split up with a comma (e.g. "Physical Assault, Throwing an object").

 

So I went into Transform Data, used split column ("," as delimiter) & split it into rows so I could put a slicer on a graph, but it's got 2 instances of most incidents.
My thinking is that it's not removed the space from the start/end of any that were delimited.
Is there a way to resolve this without having to go into the excel file, recreating the split column & using TRIM?

Thanks in advance,

G

3 Replies