Hi, I'm running the trial at the moment, and it's mostly working well. I just can't seem to work this out. In my XML files I have a field where the output is of this style:
10kg Plastic Drum (Non UN)
I need to removed the 10kg (this could be anything from 1 to 10000 kgs, so iI can't use position). I also need to reuse the weight portion in another CSV line.
I have tried with the splitstring function, but have no idea how to access and manipulate the output before passing it into the CSV.