Whenever you need to take some values out of your column and put them into another one, the Extract Substrings feature from Substring Tools is a real help. And no worries about your original column—it will not change one iota.
The things to be remembered:
Click the Substring Tools icon on the Ablebits Data tab and select Extract Substrings to run the tool:
Fill in the required fields and pick the options of interest:
Click the Extract button to get your data processed. You will see the result on the right of your source column:
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!