I keep getting an odd error code and I cant determine what I’m doing wrong, here is the code to get the data: I send the DataLine to an IFS file so I can capture the output of the regular _expression_ just to visualize what I’m getting, regarding the regular _expression_ I have do this in
order to parse the JSON file and this works just fine if I capture the file into an IFS file then use Grep to remove the part of the JSON that causes the error, however when I capture just the output to a variable is when the error occurs, I have a feeling
its being caused by the regular _expression_ however the DataLine variable looks identical to the file I produce using Grep. This is where the error occurs: Thoughts? Keeping in mind this works…. -- Thank You, |
[ { "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPAREL0W4N0SP002P","Status":"0","TickerSymbol":"FSPAREL0W4N0SP002P","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.3188" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARFT0WAR0SR007N","Status":"0","TickerSymbol":"FSPARFT0WAR0SR007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.2984" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARFT0WEL0SR007N","Status":"0","TickerSymbol":"FSPARFT0WEL0SR007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"9" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARFT0WHK0SR007N","Status":"0","TickerSymbol":"FSPARFT0WHK0SR007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4135" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARFT0W4C0SR007N","Status":"0","TickerSymbol":"FSPARFT0W4C0SR007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.3465" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0WAR0SV007O","Status":"0","TickerSymbol":"FSPARLR0WAR0SV007O","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.3313" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0WAR0SX004G","Status":"0","TickerSymbol":"FSPARLR0WAR0SX004G","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.3354" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0WEL0SU0028","Status":"0","TickerSymbol":"FSPARLR0WEL0SU0028","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-05-07","PrdEffectiveTime":"781","Last":"9.02" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0WEL0SV007O","Status":"0","TickerSymbol":"FSPARLR0WEL0SV007O","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-05-07","PrdEffectiveTime":"781","Last":"9.02" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0WEL0SW007P","Status":"0","TickerSymbol":"FSPARLR0WEL0SW007P","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-05-07","PrdEffectiveTime":"781","Last":"9.02" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0WEL0SX004G","Status":"0","TickerSymbol":"FSPARLR0WEL0SX004G","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"9" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0WEL26O000B","Status":"0","TickerSymbol":"FSPARLR0WEL26O000B","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-05-07","PrdEffectiveTime":"781","Last":"9.02" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0W4C0SU0028","Status":"0","TickerSymbol":"FSPARLR0W4C0SU0028","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.368" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0W4N0ST008P","Status":"0","TickerSymbol":"FSPARLR0W4N0ST008P","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.3875" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0W4N0SU0028","Status":"0","TickerSymbol":"FSPARLR0W4N0SU0028","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.5231" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0W4N0SX004G","Status":"0","TickerSymbol":"FSPARLR0W4N0SX004G","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4001" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEBXHK0ZL00A4","Status":"0","TickerSymbol":"FSPIABEBXHK0ZL00A4","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4568" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEBYHK0ZL00A4","Status":"0","TickerSymbol":"FSPIABEBYHK0ZL00A4","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4603" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB8AR0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB8AR0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.3856" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB8CD0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB8CD0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-04-01","PrdEffectiveTime":"1080","Last":"9.9999" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB8CD0ZL0HA4","Status":"0","TickerSymbol":"FSPIABEB8CD0ZL0HA4","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-17","PrdEffectiveTime":"0","Last":"6.3914" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB8GZ0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB8GZ0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4133" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB8HK0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB8HK0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-10-01","PrdEffectiveTime":"1080","Last":"8.9999" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB8HK0ZL00A4","Status":"0","TickerSymbol":"FSPIABEB8HK0ZL00A4","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4866" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB8330ZI0006","Status":"0","TickerSymbol":"FSPIABEB8330ZI0006","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4459" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB84C0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB84C0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4094" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB9AR0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB9AR0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.3891" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB9CD0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB9CD0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-04-01","PrdEffectiveTime":"1080","Last":"9.9999" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB9CD0ZL0HA4","Status":"0","TickerSymbol":"FSPIABEB9CD0ZL0HA4","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-17","PrdEffectiveTime":"0","Last":"6.3964" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB9GZ0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB9GZ0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4168" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB9HK0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB9HK0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-10-01","PrdEffectiveTime":"1080","Last":"8.9999" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB9HK0ZL00A4","Status":"0","TickerSymbol":"FSPIABEB9HK0ZL00A4","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4901" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB9330ZI0006","Status":"0","TickerSymbol":"FSPIABEB9330ZI0006","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4509" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB94C0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB94C0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4129" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABECMHK0ZL00A4","Status":"0","TickerSymbol":"FSPIABECMHK0ZL00A4","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4484" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABECNHK0ZL00A4","Status":"0","TickerSymbol":"FSPIABECNHK0ZL00A4","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4272" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABE0SAR0ZJ007N","Status":"0","TickerSymbol":"FSPIABE0SAR0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.2883" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABE0SCD0ZJ007N","Status":"0","TickerSymbol":"FSPIABE0SCD0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-04-01","PrdEffectiveTime":"1080","Last":"9.9999" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABE0SGZ0ZJ007N","Status":"0","TickerSymbol":"FSPIABE0SGZ0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.2962" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABE0SHK0ZJ007N","Status":"0","TickerSymbol":"FSPIABE0SHK0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-10-01","PrdEffectiveTime":"1080","Last":"8.9999" }} ]
-- _______________________________________________ Ftpapi mailing list Ftpapi@xxxxxxxxxxxxxxxxxxxxxx http://scottklement.com/mailman/listinfo/ftpapi