I want to be able to remove the last occurrence of "/" from data I have in a query.. like below:
Original Data Example:
X/Y/A1/
X/Y/B1/
X/Y/B2/
X/Y/B4/
X/Y/B7a
X/Y/B8a
X/Y/B3/
X/Y/B3/
X/Y/B9a
X/Y/B4/
Required Data Example:
X/Y/A1
X/Y/B1
X/Y/B2
X/Y/B4
X/Y/B7a
X/Y/B8a
X/Y/B3
X/Y/B3
X/Y/B9a
X/Y/B4
What sort of expression should I use? I've tried doing a few Replace expressions, but couldn't get it right. Any help would be appreciated. Thanks.
Original Data Example:
X/Y/A1/
X/Y/B1/
X/Y/B2/
X/Y/B4/
X/Y/B7a
X/Y/B8a
X/Y/B3/
X/Y/B3/
X/Y/B9a
X/Y/B4/
Required Data Example:
X/Y/A1
X/Y/B1
X/Y/B2
X/Y/B4
X/Y/B7a
X/Y/B8a
X/Y/B3
X/Y/B3
X/Y/B9a
X/Y/B4
What sort of expression should I use? I've tried doing a few Replace expressions, but couldn't get it right. Any help would be appreciated. Thanks.