Extract and store partial value from a Notification String in Variable

[Muralidaran]

Hi,
I'm facing difficulty in extracting and storing a partial value from a Notification String in Variable, i have tried the below but with no luck so landed here for experts opinion and suggestions.

[not_title] = You have spent in amazon of value 61.4567

Text Manipulation 'to extract 'amazon'
Substring
Source Text = [not_title]
Start Index = 19
End Index = 6 'this is not a fixed length currently I'm using a fixed length (need to identify the blank space after start index 19)
Save to variable = Shop 'Created the varible in Home tab Variable menu with the type as String

For me the steps seems good but for some unknown reason the variable is empty after the trigger is fired, i have confirmed that the trigger worked by adding a sound after this text maipulation step.

Requesting your suggestion on this, thanks.

 

[tanutanu]

Hi,
I'm facing difficulty in extracting and storing a partial value from a Notification String in Variable, i have tried the below but with no luck so landed here for experts opinion and suggestions.

[not_title] = You have spent in amazon of value 61.4567

Text Manipulation 'to extract 'amazon'
Substring
Source Text = [not_title]
Start Index = 19
End Index = 6 'this is not a fixed length currently I'm using a fixed length (need to identify the blank space after start index 19)
Save to variable = Shop 'Created the varible in Home tab Variable menu with the type as String

For me the steps seems good but for some unknown reason the variable is empty after the trigger is fired, i have confirmed that the trigger worked by adding a sound after this text maipulation step.

Requesting your suggestion on this, thanks.

You need to assign 19+6 value as the ending index.
Note that the result should be starting "m"(Amazon's m) as your example. It counts index starting from the number zero, 0,1,2,3...

 

[Muralidaran]

Hi,
Thanks for your suggestion, tried it still the value is not stored in variable (macro triggered).
attached images for reference.

 

[tanutanu]

Hi,
Thanks for your suggestion, tried it still the value is not stored in variable (macro triggered).
attached images for reference.

It works. So the problem is hidden in the magic text variable you refered.
Add a test popup and/or put it in a variable action to show the notification title. Probably you would missed to get it.

Anyway, I think extract text is easier for your case, especially the string would be changing.

 

[tanutanu]

Hi,
Thanks for your suggestion, tried it still the value is not stored in variable (macro triggered).
attached images for reference.

The string what you want might be notification message body, not the title. You can get it with the magic text, [notification], as well

 

[Muralidaran]

Thanks, it worked.
Variables were stored properly.

 

[Dm114]

Hi,
I'm facing difficulty in extracting and storing a partial value from a Notification String in Variable, i have tried the below but with no luck so landed here for experts opinion and suggestions.

[not_title] = You have spent in amazon of value 61.4567

Text Manipulation 'to extract 'amazon'
Substring
Source Text = [not_title]
Start Index = 19
End Index = 6 'this is not a fixed length currently I'm using a fixed length (need to identify the blank space after start index 19)
Save to variable = Shop 'Created the varible in Home tab Variable menu with the type as String

For me the steps seems good but for some unknown reason the variable is empty after the trigger is fired, i have confirmed that the trigger worked by adding a sound after this text maipulation step.

Requesting your suggestion on this, thanks.

Why wouldn't you extract with regex '\d+\.\d+' (without quotes) ?