Hi There
i have a CSV/UDR without headers with following example rows
session_start,0 ,0 ,2017-03-07 20:00:50 +0200 , ,172.99.99.0~86056588,labtest ,172.99.99.0 , [0], 0, 0, 0, 0
usage_start ,0 ,0 ,2017-03-07 20:25:37 +0200 ,2017-03-07 20:25:47 +0200 ,172.99.99.0~86056588,labtest ,172.99.99.0 , [27770], 20549, 18187, 2362, 0
usage_int ,0 ,3 ,2017-03-07 20:33:05 +0200 ,2017-03-07 20:41:54 +0200 ,172.99.99.0~86056588,labtest ,172.99.99.0 , [15457], 54450, 36051, 18399, 0
usage_stop ,0 ,5 ,2017-03-07 20:46:23 +0200 ,2017-03-07 20:46:23 +0200 ,172.99.99.0~86056588,labtest ,172.99.99.0 , [6322], 0, 0, 0, 0
session_stop ,0 ,59 ,2017-03-07 20:00:50 +0200 ,2017-03-07 20:59:32 +0200 ,172.99.99.0~86056588,labtest ,172.99.99.0 , [0], 0, 0, 0, 0
currently i have a props that looks like this:
[sde_rg_udr]
SHOULD_LINEMERGE=false
KV_MODE = NONE
TIME_FORMAT = %Y-%m-%d %H:%M:%S %z
TIME_PREFIX=(?:.*?,){3}
MAX_TIMESTAMP_LOOKAHEAD = 26
INDEXED_EXTRACTIONS = CSV
FIELD_NAMES = RecordType,RecordStatus,RecordNumber,StartTime,EndTime,AcctSessionId,SubscriberId,FramedIp,[ServiceId],TotalBytes,RxBytes,TxBytes,Time
TZ = Africa/Harare
Unfortunately the ServiceID field is encapsulated in [] braces and i just need the id without the braces - how can i change my props to extract the field at index time without the braces?
... View more