string manipulation

[pulsoft]

If I wanted to extract two numeric variables out of the following string '11m 10.79s' (i.e. 11 and 10.79) what would be the most effective way to do it?

Thanks

[Tom Cone Jr]

Re: string manipulation

What patterns are present in the strings? i.e. is the "m" always 2 digits? is the "s" always 5?

[pulsoft]

Re: string manipulation

No Tom, not exactly as you said, the minute numbers will be either 1 or 2 characters in length and the seconds numbers could br 5 characters long or 4 characters long, for exam0ple, the string could be '7m 8.01s' ...

[pulsoft]

Re: string manipulation

There does always appear to be a decimal point in the second number and therefore the decimal places is always 2

[Tom Cone Jr]

Re: string manipulation

More details please. Give us sample data to work with. Will the "m" value ever include decimals? Will the "s" value always include decimals? Please be comprehensive and detailed.

[pulsoft]

Re: string manipulation

Here is a sample data xlsx file

m values will not have decimals only s values

[Tom Cone Jr]

Re: string manipulation

Paul, these expressions will extract the numerics as strings of characters. If you need them stored as numerics you'll need to use the val() function on each.

my_str = "11m 10.79s"
s = regex_split(my_str,"(\d+.\d+)")
?s
= "10.79"

m = word(regex_split(my_str,"(\d+)"),1)
?m
= "11"

There may be simpler ways of doing this, so I'll be lurking in the background.

[pulsoft]

Re: string manipulation

Many thanks Tom...

[pulsoft]

Re: string manipulation

Works a treat

dim winmin as n
dim winsecs as n
wintime = "11m 10.79s"
winmins = val(word(regex_split(wintime,"(\d+)"),1))
winsecs = val(regex_split(wintime,"(\d+.\d+)"))"

So, wintime will be the imported string time field
winmins will be an additional numeric fiield with a val() field rule as above
as will winsecs

Thanks again Tom...

[CALocklin]

Re: string manipulation

Really cool, Tom!

Just another idea - but it only applies to a number at the beginning of a string:

my_str = "11m 10.79s"
First_number = val( my_str )
?First_number
= 11

and, just so you know it works with decimals ....

my_str = "11.325m 10.79s"
First_number = val( my_str )
?First_number
= 11.325

[JetLi]

Re: string manipulation

Nice suggestions, I am doing the same thing, but I am having problems to do some calculations on a certain formula.Here is the fist scenario:
Price= 2500, Discount=10+1 (to be supplied by user), the discounted price is (2500*10)/11= 2,272.7272
Here is another scenario:
Price=2500, Discount = -5% (again to be supplied by the user), the discounted price is 2500-(2500*.05) = 2375.
Another case is Price=2,500, Discount =+7%, 2500+(2500*.07) =2,675

My problem is how to evaluate the formula based on the supplied discount by the user(user can enter 12+1,-7%,-10% or 10+2,+8% etc, How will I determine on my app so that I can implement either the first or second formula or 3rd on the 3 scenarios?Thanks!

[Tom Cone Jr]

Re: string manipulation

Jet, while there may be some similarities I think your question belongs in its own thread. It's considered rude to hijack someone else's thread by moving the discussion into a different area. Worse, when a single message thread tackles multiple questions the thread is much less useful as future knowledgebase. Someone interested in your question would have to wade through all the preceding posts just to get to yours.

[JetLi]

Re: string manipulation

Jet, while there may be some similarities I think your question belongs in its own thread. It's considered rude to hijack someone else's thread by moving the discussion into a different area. Worse, when a single message thread tackles multiple questions the thread is much less useful as future knowledgebase. Someone interested in your question would have to wade through all the preceding posts just to get to yours.

I picked the wrong choice, at first I thought I can just start a new thread and asked a new question, but I thought it was a bit related to the question here. But for Tom Cone Jr. it was rude, it is a HIJACKED FOR ME ON SOMEONE ELSE'S Thread, now I know that this is how it is meant by others to post on someone's thread.Thanks for the reminder.I will then post my question in another thread and I hope I will not be charged in court for doing something rude on this thread, just in case someone will sue me, may I get you as my Lawyer, hope you will not charge me much for your services.

[pulsoft]

Re: string manipulation

I picked the wrong choice, at first I thought I can just start a new thread and asked a new question, but I thought it was a bit related to the question here. But for Tom Cone Jr. it was rude, it is a HIJACKED FOR ME ON SOMEONE ELSE'S Thread, now I know that this is how it is meant by others to post on someone's thread.Thanks for the reminder.I will then post my question in another thread and I hope I will not be charged in court for doing something rude on this thread, just in case someone will sue me, may I get you as my Lawyer, hope you will not charge me much for your services.

Jet, I don't think Tom meant to come across as high handed, I don't think it's in his nature. However, I do think he makes a valid point that a separate thread would focus on your particular problem, especially as it does seem very different to my original question in this thread.
Out of interest, how do you envisage the user entering or indicating the discount value?

[Ray in Capetown]

Re: string manipulation

I thought Jet was being humerous in his own way. Didnt think he took Tom as high handed.
He intends posting his question.
How dry our written responses can be, especially on international multicultural, multi linguistic levels, despite which we do pretty well.