Christine Gopon Posted November 8, 2021 Share Posted November 8, 2021 I'm trying to figure out if this is possible: I have a string dataset that consists of well names, for example: 7/16-2 35/1-1 6401/12-11 S I would like to calcuate a new column that returns the first part of the string, before the / character. So in this example the return would be 7 35 6401 I don't believe the "left" function will work in this instance, so I am wondering if there is another option to do this Thanks! Link to comment Share on other sites More sharing options...
Fabian Duerr Posted November 8, 2021 Share Posted November 8, 2021 Please check out the feature to extract parts of a string with a regular expression with the RXExtract() function: RXExtract([your.column],"[[:digit:]]+",1)Here you could also split your column. Check out the Split() function as well: Split([your.column],"/",1) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now