Extract data from a long text field
How can I get the number 12 from this field AIR WICK AIR FRESHENER 12/8 oz SNUGGLE FRESH LINEN https://www.screencast.com/t/1w1uGCphWs
Forum Discussion
I don't think it will be possible to have a perfect extraction formula as the data is inconsistent.
In the example I did, I was looking for the first number from the left.
In your next example you are looking for the first numbers from the right.
I can make a formula for either, but how to know which is correct for each type of data
In the example I did, I was looking for the first number from the left.
In your next example you are looking for the first numbers from the right.
I can make a formula for either, but how to know which is correct for each type of data