Doubt - Extract Text (RegExMatch) Topic is solved

[snowmind]

hi folks

How can I extract the word WINDOWS from this text?

{"id":"restaura_senha","activitygroup":"8","campos":[{"value":"WINDOWS","label":"Sistema"},{"value":"684067 - jonh Smith tonelli","label":"Usuário que acessa o sistema"},{"value":"solicito reset de senha urgente\r\n\r\n684067 - jonh smithtonelli","label":"Justificativa"}],"nome":"Restaura Senha"}


I tried something with regxmatch but was unsuccessful.
* The text above was in my clipboard

Code: Select all

RegExMatch(clipboard, "value\s?:(.*) \,", match)
Var = %match1%
Msgbox % Var

[awel20]

Hi snowmind,

Is this what you want? It will only get the first match (WINDOWS).

Code: Select all

Var = {"id":"restaura_senha","activitygroup":"8","campos":[{"value":"WINDOWS","label":"Sistema"},{"value":"684067 - jonh Smith tonelli","label":"Usuário que acessa o sistema"},{"value":"solicito reset de senha urgente\r\n\r\n684067 - jonh smithtonelli","label":"Justificativa"}],"nome":"Restaura Senha"}
RegExMatch(Var, "value\s?"":""\K([^""]+)", Match)
MsgBox % Match

[boiler]

You may want to make sure it always finds the value which corresponds to the label "Sistema" instead of relying on it being the first label. If so, this will find it:

Code: Select all

Haystack = {"id":"restaura_senha","activitygroup":"8","campos":[{"value":"WINDOWS","label":"Sistema"},{"value":"684067 - jonh Smith tonelli","label":"Usuário que acessa o sistema"},{"value":"solicito reset de senha urgente\r\n\r\n684067 - jonh smithtonelli","label":"Justificativa"}],"nome":"Restaura Senha"}
Needle = (?<=value":")[^"]*(?=","label":"Sistema")
RegExMatch(Haystack, Needle, Sistema)
MsgBox, % Sistema

[snowmind]

Hi snowmind,

Is this what you want? It will only get the first match (WINDOWS).

Code: Select all

Var = {"id":"restaura_senha","activitygroup":"8","campos":[{"value":"WINDOWS","label":"Sistema"},{"value":"684067 - jonh Smith tonelli","label":"Usuário que acessa o sistema"},{"value":"solicito reset de senha urgente\r\n\r\n684067 - jonh smithtonelli","label":"Justificativa"}],"nome":"Restaura Senha"}
RegExMatch(Var, "value\s?"":""\K([^""]+)", Match)
MsgBox % Match

Hello awel20, thanks for replying

So the word is not always "WINDOWS". In this same place can come another word sometimes, like:

{"id":"restaura_senha","activitygroup":"8","campos":[{"value":"EMULATOR","label":"Sistema"},{"value":"684067 - jonh Smith tonelli","label":"Usuário que acessa o sistema"},{"value":"solicito reset de senha urgente\r\n\r\n684067 - jonh smithtonelli","label":"Justificativa"}],"nome":"Restaura Senha"}

In this case I should take the word "EMULATOR"

[snowmind]

Hi snowmind,

Is this what you want? It will only get the first match (WINDOWS).

Code: Select all

Var = {"id":"restaura_senha","activitygroup":"8","campos":[{"value":"WINDOWS","label":"Sistema"},{"value":"684067 - jonh Smith tonelli","label":"Usuário que acessa o sistema"},{"value":"solicito reset de senha urgente\r\n\r\n684067 - jonh smithtonelli","label":"Justificativa"}],"nome":"Restaura Senha"}
RegExMatch(Var, "value\s?"":""\K([^""]+)", Match)
MsgBox % Match

But your answer is perfect. Thank you for your help

[snowmind]

You may want to make sure it always finds the value which corresponds to the label "Sistema" instead of relying on it being the first label. If so, this will find it:

Code: Select all

Haystack = {"id":"restaura_senha","activitygroup":"8","campos":[{"value":"WINDOWS","label":"Sistema"},{"value":"684067 - jonh Smith tonelli","label":"Usuário que acessa o sistema"},{"value":"solicito reset de senha urgente\r\n\r\n684067 - jonh smithtonelli","label":"Justificativa"}],"nome":"Restaura Senha"}
Needle = (?<=value":")[^"]*(?=","label":"Sistema")
RegExMatch(Haystack, Needle, Sistema)
MsgBox, % Sistema

Hi boiler! your answer is perfect too. Thank you for your help