If you are a developer and are not familiar with regex, you should look up a quick tutorial for it because parsing text becomes so much easier with it. I recently had to work on parsing text inputs with inches and feet and thought I’d share it here:
This will capture the following examples:
But not the following ones:
The last one is not captured because anything over 12 inches is going to be another feet, so it should be
11'1" instead. It contains the following capture groups:
Group 1: If there is only feet or only inches in the search text, it gets the feet or inches (the number part), if there are both feet and inches, it gets the feet. In example 1 it would return 10, in example 2 it would return 5 and in example 3 it would return 6.
Group 2: Gets either
" so you can check if the entry was feet or inches if there was only feet or only inches in the text. In example 1 and 3 it would return
'. In example 2 it would return
Group 3: If the text has both feet and inches, gets the inches part. In example 1, it would return 12, in example 2 and 3 it would not exist.