F
fs - ab
Guest
here is my regex
(?<leader>[a-z0-1/]{5,13}(\s\w+){0,4})\s(?<v1>[0-9.,-]+)\s(?<v2>[0-9.,-]+)\s(?<v3>[0-9.,-]+)\b
here is my test data
Deposits/Transfer Ins 0.00 0.00 0.00
Withdrawals/Transfer Outs 0.00 0.00 -15,660.70
Total Investment Return -272.14 -572.63 8,454.91
however I only got one line matched and extracted for
Total Investment Return -272.14 -572.63 8,454.91 ignoring any line with / in leader
what have I done wrong? for the leader pattern?
looks like it does not matter if it's /, @ or other special char, even double space
eg "Withdrawal Transfer Outs 0.00 0.00 -15,660.70"
the expression @"
(?<leader>\w+( {0,1})(\s\w+){0,4})\s(?<v1>[0-9.,-]+)\s(?<v2>[0-9.,-]+)\s(?<v3>[0-9.,-]+)\b"
will not match
Continue reading...
(?<leader>[a-z0-1/]{5,13}(\s\w+){0,4})\s(?<v1>[0-9.,-]+)\s(?<v2>[0-9.,-]+)\s(?<v3>[0-9.,-]+)\b
here is my test data
Deposits/Transfer Ins 0.00 0.00 0.00
Withdrawals/Transfer Outs 0.00 0.00 -15,660.70
Total Investment Return -272.14 -572.63 8,454.91
however I only got one line matched and extracted for
Total Investment Return -272.14 -572.63 8,454.91 ignoring any line with / in leader
what have I done wrong? for the leader pattern?
looks like it does not matter if it's /, @ or other special char, even double space
eg "Withdrawal Transfer Outs 0.00 0.00 -15,660.70"
the expression @"
(?<leader>\w+( {0,1})(\s\w+){0,4})\s(?<v1>[0-9.,-]+)\s(?<v2>[0-9.,-]+)\s(?<v3>[0-9.,-]+)\b"
will not match
Continue reading...