Zipcode range xml not working

[acrisostomo12]

Hi Team im working on the UCCX script for Zipcode in US when the user going to IVR and press the ZIPCODE from where they from. 

when i define it with single zipcode it works but when im using a range for example for Texas 73301 to 88595. 

here is the xml file i have and the script. 

please help how can i do it on range. 

<?xml version="1.0" encoding="utf-8"?>
<ZipCodeList>
<ZipCode ID="73301-88595">
<CSQName>CSQ_TEXAS</CSQName>
</ZipCode>
<ZipCode ID="70001-71497">
<CSQName>CSQ_LOU</CSQName>
</ZipCode>
</ZipCodeList>

[david.macias]

You can't do math on the lookup. You have to fill out every single zip code or do the math in the script to find out the range and then do an XML lookup on the range.

david

[acrisostomo12]

Hi @david.macias 

I did some re configuration with the script using the if statement for IF (Zipcode == XXXXX>=XXXXX) if true go to CSQ = "CSQ_X"

but it not getting to the queue. can you help me on how i can improve the script and xml file. appreciate if you can help me. 

[Elliot Dierksen]

What @david.macias said is correct. Zip code is a string column, so math will not work. You could use regular expressions with a "matches" qualifier in the where clause.

[david.macias]

It would be most helpful if you posted a screenshot of your script.

david

[acrisostomo12]

Hi @david.macias i already post the XML and the script on the beginning. 

[david.macias]

I lost track of this, did you get it working?

david

[acrisostomo12]

Hi @david.macias i manage to use the copilot to create the list of Zipcode for all the state for US. thanks for all the help guys