05-31-2017 07:33 AM
Hi ,
I want to select the value after Fourth tabulation or third tabulation ...
I dont find the regular expression that I can use.
Example :
12:34:37.173 25.7 24.8 15.98 27.1 0.5 3.34 584.5 24.0 86.0 946.5 77.5
15.98
Thank you ,
Solved! Go to Solution.
05-31-2017 08:26 AM
I would just use Spreadsheet String To Array to get an array of your strings. You then just use Index Array to get the value you want.
05-31-2017 08:34 AM - edited 05-31-2017 08:38 AM
Agree, REGEX is not what you want to use! Use as crossrulz said Spreadsheet String To Array
But since you asked... Regular expression is almost a programming language in itself and can almost do anything it if given the time to figure it out.
Change the {3} to {4} to get the 4th item.
BUT choose the correct tool for the task
Spreadsheet String To Array!
05-31-2017 09:11 AM
thank youuuu .