Removing Any Number ending in _R from data in a Dimension

[hammermill21]

Hello!

I have a dimension of barcode_numbers, but I want to remove any numbers that end in _R and I'm not sure how to do that within a dimension. 

Any ideas?

Thank you 🙂 

[Lisa_P]

If this is unique combination of characters you could use replace() function to replace '_R' with ''.
Best done in the load script eg
load ...
replace(barcode_numbers, '_R', '') as barcode_numbers
..