Convert variable string to variable numeric

[javier]

Hi,

I have this table:

A	B
10 min	50 seg
10 min	1 hora

Column A is a constant that I put, and column B is a string I take from url.

I need convert strings, seg, min, hora, horas, día, dias (this is all time string url generate) to, 0.6, 1, 60, 60, 1440, 1440.

I need this for compare later two columns and if A1<B2 do something. I read in forum that I can do this with javascript


I apreciate your help.

 

[lokiys]

seg = 0.6
min = 1
hora = 60 etc.

All the time it hold the same value ?

 

[javier]

I don´t know if you urderstand what I want.

I want conver this

var1 = 60 seg to var1convert = 1

var2 = 1 día to var2convert = 1440

var3 = 4 horas to var3convert= 240

var4 = 35 min to var4convert = 35

I want convert all times to minutes.

 

[Hungry Bulldozer]

I'd do that such a way:
0. for each row
1. Parse number from column B with regexp \d+
2. Parse word from column Bwith regexp [a-z]*
3. Use switch to convert variable from step 2 into number
4. Multiply number from step 3 and step 1 by using JS.

 

[javier]

Thanks for reply.

I make step 1 and 2, but I don't know how do step 3.

I try to do with wordprocessing but I don't find how.

 

[javier]

I no say nothing:mad:

For step 3 I use wordprcesing/regex and you code [a-z]*

When I run template no put nothing in variable.

I use tool regurar expresion and writte 1 seg and put your code [a-z]* and fin 3 results:

0 nothing
1 seg
2 nothing

Its posible that when I use wordprocesing take number 0 o 2 result?
I don't know

bye

 

[javier]

I no see {space} before [a-z]*
Noe I find only text

I continue

 

[javier]

Finish!!!

thanks

 

[rostonix]

You made it?

 

[Hungry Bulldozer]

Finish!!!

thanks

Respect, not easiest thing to get done