Field calculator processor : Regular Expression

Discussion created by prasanthk on Dec 24, 2019

I am having an incoming string value like this:

"$864287032522581,23/10/2019,17:24:42,A,023.022762,N,072.537521,E,39.40,00.34,0,0,00.00,31,4DAA,1,05.67,223961.25,0,0,1,0,0,0,03.59,00.00,0,0,0,0,0,231019_172442_2301.36571_07232.2512_0,Q2268_9_600,LTG_7.7_2_404240190254281@"  believing that RegEx can help me in extracting information like below:

864287032522581 - Device ID

  31/10/2019 -- Date

  11:52:32  -- Time

  022.982608  -- Latitude

  072.611007  -- Longitude

  44.00 -- Speed.

Can anyone guide me what would be the appropriate regular expression to get these values?

My filed name is ${GPRMC}