Skip to main content
Question

Data extraction

  • July 26, 2023
  • 4 replies
  • 16 views

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

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+59
  • Celebrity
  • 3700 replies
  • July 26, 2023

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
  • 26 replies
  • July 26, 2023

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
  • 26 replies
  • July 26, 2023

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

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.