You could try triming the field using the following calculation Where [C] is your Note dimension
Thanks Mark I must have a research at this
Thank you this worked a treat.
Could you please explain what this calculation is actually doing?
1 of 1 people found this helpful
The first MID() statement extracts everything right of the first character after the first occurrence of the " which is the first FIND statement onwards.
The second FIND uses the same code as above it and looks for the next " in the remaining string.
The LEFT then starts at the result of the first FIND statement and returns the characters from here up until the second find -1 character which is determined by the last statement in the calculation.
Hope this helps