Skip to main content
Question

Data extraction


n.d
Contributor
Forum|alt.badge.img+7
  • Contributor

Hello.

I have some data like this:

123 m

32 m

56 m

...

and I want to keep the numeric part and ommit the unit (m). Which way is the best?

4 replies

redgeographics
Celebrity
Forum|alt.badge.img+50

Stringreplacer, replacing the combination of space and m with nothing, is probably the easiest way do do this, assuming it's always meters.


n.d
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • July 26, 2023
redgeographics wrote:

Stringreplacer, replacing the combination of space and m with nothing, is probably the easiest way do do this, assuming it's always meters.

Thanks. I did the same by using the AttributeManager. Now it is needed to change the format of that attribute, it is still a string.


n.d
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • July 26, 2023
n.d wrote:

Thanks. I did the same by using the AttributeManager. Now it is needed to change the format of that attribute, it is still a string.

Solved. :)


Forum|alt.badge.img
redgeographics wrote:

Stringreplacer, replacing the combination of space and m with nothing, is probably the easiest way do do this, assuming it's always meters.

Thanks, it works for me and I am glad my problem was solved too. I appreciate you.

 

 

 

 

 

To extract the numeric part and omit the unit ("m" in this case) from your data, you can use various methods depending on the software or programming language you're using. If you have this data in an Excel spreadsheet, you can use the SUBSTITUTE function to replace the "m" with an empty string, like this: =SUBSTITUTE(A1, " m", "") and if you want to know more about online essay writer then I will recommend you to click for more info on online essay writing services. Because over there you can find a lot of them easily and you just only have to choose them according to your requirements.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings