how to take the values ​​in a string?

[daniele]

is possible to take only a part of a value as this?

<BytesSample sampleTime="00:00:41.870" data="660103010201" /> -201-WATER-

I want to take the time and the final value, is it possible?
Example:
00:00:41.870 in the "global Strings A"
And
201 In the Global value B

I have to take only two values​​, but it is very difficult when there are other values ​​that row or written, you know how?
I entered an empty file, you can write the 'event which takes only the time and' last number value of that string?
Regards

[ChrisBurrows]

This will work providing the substrings never more or change length.

[daniele]

I found a solution, but this solution is good only if that string is the number of characters are always the same, but I would always have a solution that takes these values ​​even if the number of characters not good increases or decreases

[daniele]

ahaha :-)
I read your response after I prepared the new file!
Incredible.
thanks anyway, is good as a solution but not always

[MuddyMole]

You just use the "find string in string" expression to locate the starting point of the substring you want - eg. "sampleTime=""
and then run a fastloop to copy the following characters one at a time, until you hit a character that marks the end of the substring you want - in this case another quotation mark.

[daniele]

Thanks, I tried but I can not create the right 'expression. could you please change my example to the string that gets only that value?

[daniele]

Hello, I solved a problem, now I have one more great and I hope to have your help as I have always given.

I want to separate the rows and copy them into the column, but must be divided in relation to the last line number.
If the final number is "3" the entire line must be copied in the column "3" but I do not know how to do this.
Daniele