I searched for existing scripts, but I could not find something to match my needs.
I have text files with several paragraphs. One of the paragraphs has some data in this format:
String1: 0.8 String2: 0.4
I would like to capture the numbers (which are 0-1, inclusive), and then drop those into custom fields for that file (these custom fields would be named String1 and String2).
I can write Regex to capture, however, I do not know how to write a script to copy those data to custom fields.
Any resources or ideas?
OK, I found that a Smart Rule could do this, but I hit a block:
To be more specific, the line from which I am trying to capture text is something like:
Diff: 0.96 Disc: 0.08
And I am trying to capture “0.96” and change my custom field “Diff” to that. My capture Regex should work (it does in TextSoap, anyway). I have my custom field Diff formatted as single-line text (I learned that the rule could not pass the captured text to a decimal number field). However, when I run this rule, nothing happens (Diff is not changed).
A regular expression is probably not even necessary:
Works fine for your text example.
Thanks! This will be very helpful!
I changed it to move the result to my custom field, and it worked!
And to add to @cgrunenberg’s suggestion, from the Appendix > Smart Rule Events and Actions…