Hi All,
I understand that this is an old thread, but would anyone be able to help me with what I think is a similar issue to the first above.
I want to be able to truncate all text on either side of specific characters. A sample of a single entry within this field would be;
01A-Dirty Walls¬
02B-Paint scratched¬
03C-No Toilet paper¬
Can i define a start position e.g. "01A-" and define the end position being either the "¬" or a carriage return. Leaving me with whatever is in between (considering that the text in between could be of varying lengths) and in this case the end result looking like this:
Dirty Walls
Ultimately, what i need is to link items from a different field (i.e. TASK.QUESTIONS), with specific sentences within the field explained above (TASK.NOTES).
Hopefully this would look like this:
Doors/Walls {QUESTIONS} - Walls Dirty {NOTES}
Paint {QUESTIONS} - Paint scratched {NOTES}
Cosumables {QUESTIONS} - No toilet paper {NOTES}
Thanks in advance.