Hi. I have a lookup file with phone numbers broken down into their parts, so: cc,npa,nxx,list 1,210,5551234,good 1,512,7779876,bad My event stream has e164 phone numbers, so: +12105551234 +1...
See more...
Hi. I have a lookup file with phone numbers broken down into their parts, so: cc,npa,nxx,list 1,210,5551234,good 1,512,7779876,bad My event stream has e164 phone numbers, so: +12105551234 +15127779876 i'd like to use the lookup command, but can't find a way to natively join this data and looking for ideas. currently i am able to use join, like this: ...
| join number
[
| inputlookup lookupfile.csv | eval number="+".cc.npa.nxx but I've learned through this group mostly to try and avoid 'join' because of limitations and 'it basically applying SQL and this ain't SQL'. I thought about 'breaking apart' the number field into (3) fields and then passing several looks like in the example page linked above, but this feels backwards when what i'd prefer to do is join the data in the csv. So another idea was to create a report that does that and creates a new CSV (|output lookup), but that feels unnecessary, too. Any thoughts? THANK YOU!