Jump to content

Data Extraction Number/Text


This topic is 2934 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have data within a field which consists of measurements that I want to extract. for example

 

ProductSpecification
 
Fork TS Air 27.5", Remote Lockout
Fork TS Air 30 27.5", Remote Lockout, 100mm
Fork TS Air 30 27.5", Remote Lockout, 120mm

Fork TS Air 30 27.5", Remote Lockout, 140mm

 

Doing a simple PatternCount is fine for say "100mm" but how can I do this for an entire range (between 0 and 500mm). For example PatternCount ( ProductSpecification; >500mm )

 

Thanks

Link to comment
Share on other sites

You are not providing enough details to understand the task. What exactly do you want to extract, and what is known for sure to exist in the field that would enable us to locate the wanted part/s?

 

 

P.S. I hope those are 4 individual records in your example, not 4 lines in the same record...

Link to comment
Share on other sites

Apologies, 

 

I am wishing to extract the sizing information from these records (they are individual records)

 

For example

 
Fork TS Air 27.5", Remote Lockout = "0"
Fork TS Air 30 27.5", Remote Lockout, 100mm = "100mm"
Fork TS Air 30 27.5", Remote Lockout, 120mm = "120mm"

Fork TS Air 30 27.5", Remote Lockout, 140mm = "140mm"

 

I have created a new field called ProductSpecificationSizing which will include this information. What I am looking for is the calculation so I can attract the information from these records and 1000's more. 

Link to comment
Share on other sites

I am afraid that's still rather vague. Perhaps you could use =

GetAsNumber ( RightWords ( ProductSpecification ; 1 ) )

which would return the numeric values without the units (if the units are known, then this is the better approach). Otherwise try =

Let (
lastWord = RightWords ( ProductSpecification ; 1 )
;
Case ( lastWord ; lastWord )
)

However, both will fail if your field contains, for example: "Fork TS Air 30 27.5", Remote Lockout 3DVision". This could be prevented if you know for sure that the measurement, if present, is always the last word and contains some digits followed by "mm".

Link to comment
Share on other sites

That is problematic, because a calculation that looks for "mm" at the end of a word, will be fooled by "comm" or "stumm". There aren't many words that end with "mm", but to make this foolproof you must loop over each word in turn and see if it ends with "mm" AND contains only digits before that.

Link to comment
Share on other sites

This topic is 2934 days old. Please don't post here. Open a new topic instead.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.