LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: akash_123srm

Hi guys I am new to lavastorm,i wish to find out difference between the dates when the enty in column CMLTEXT changes.I wish to calculate days between (2014-07-23 13:39:35 User: bkugele - Means: MB - Request to Clearing D2D) and (2014-08-29 15:55:11 User: bkugele - Means: MB - Response existing).Any ideas how can I accomplish that?

The log is as follows:

CMLTEXT
2014-07-23 13:33:51 User: bkugele - Case was created
2014-07-23 13:39:30 User: bkugele - Case Added by : bkugele
2014-07-23 13:39:35 User: bkugele - Case Name: VPKN_10702617_Hans-Peter L�we
2014-07-23 13:39:35 User: bkugele - Case Status (Client):Follow-up
2014-07-23 13:39:35 User: bkugele - Classification: MB - Suspicion
2014-07-23 13:39:35 User: bkugele - Source of Information: Sales and Dealer FM
2014-07-23 13:39:35 User: bkugele - Motive: Sales and dealer
2014-07-23 13:39:35 User: bkugele - Means: MB - Request to Clearing D2D
2014-07-23 13:39:35 User: bkugele - Planned Action: Changed
2014-07-23 13:39:35 User: bkugele - Reminder SMS: Active
2014-07-23 13:39:35 User: bkugele - Reminder date: 14.08.2014
2014-07-23 16:03:02 User: bkugele - Spent Hours: 4,5
2014-08-14 12:46:37 User: bkugele - Planned Action: Changed
2014-08-14 12:46:37 User: bkugele - Reminder date: 02.09.2014
2014-08-29 15:55:11 User: bkugele - Means: MB - Response existing
2014-08-29 15:55:11 User: bkugele - Planned Action: Changed
2014-08-29 15:55:11 User: bkugele - Reminder date: 19.11.2014
2014-11-13 17:32:44 User: bkugele - Reminder date: 17.12.2014
2014-12-18 16:43:01 User: bkugele - Reminder date: 21.01.2015
2015-01-27 17:42:07 User: bkugele - Case Status (Client):Closed
2015-01-27 17:42:07 User: bkugele - Planned Action: Changed
2015-01-27 17:42:07 User: bkugele - Spent Hours: 5,5
2015-02-05 18:13:14 User: bkugele - Case Status (Client):Follow-up
2015-02-05 18:13:14 User: bkugele - Means: MB - Request to Center D2D
2015-02-05 18:13:14 User: bkugele - Planned Action: Changed
2015-02-05 18:13:14 User: bkugele - Reminder date: 19.02.2015
2015-02-05 18:13:14 User: bkugele - Spent Hours: 7

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mgajdosik

Hi,

please see the code below... It contains reader node for your data and also the filter which will do the difference in days for you. You still need to account for multiple records here, and have some unique identifier whether it would be filename or some other id, if you expect to have multiple elements within your data.

Regards
Marek

node:Filter
bretype:core::Filter
editor:sortkey=56684aeb65f84594
input:@40fd2c74167f1ca2/=Delimited_File.41e6c6cd11e613c6
output:@40fd2c7420761db6/=
prop:Script=<<EOX
diff = int(null)
if Data.strFind("Means: MB - Request to Clearing D2D")>-1 then
startdate = Data.left(10).date("CCYY-MM-DD")
if Data.strFind("Means: MB - Response existing")>-1 then {
enddate = Data.left(10).date("CCYY-MM-DD")
diff = dateSubtract(startdate,enddate)
}

emit diff where diff.isNotNull()

EOX
editor:XY=380,170
end:Filter

node:Delimited_File
bretype:core::Delimited File
editor:sortkey=56684c115f960c67
output:@41e6c6cd11e613c6/=
prop:FieldDelimiter=notapplicable
prop:FieldNames=Data
prop:RecordDelimiter=\n
editor:XY=250,170
end:Delimited_File