Forum Discussion
Multiline text import using query editor - variable number of rows.
- 8 years ago
Thanks for the suggestion. The info was helpful to provide me with additional ideas and background.
While I was not able to develop a specific solution to this issue, I am able to solve the problem a different way. I went back and found a much cleaner data source that has one row per security, with each row containing the description in a separate field. This let me split the table for the description into the component parts, (underlying, expiration date, strike price, and call or put)
The only disadvantage is that this alternative data source is batch updated overnight, rather than in real time after the trade. However, for my purposes this is sufficient.
Thanks
John
- stockturner8 years agoRegular Visitor
Thanks for the suggestion. The info was helpful to provide me with additional ideas and background.
While I was not able to develop a specific solution to this issue, I am able to solve the problem a different way. I went back and found a much cleaner data source that has one row per security, with each row containing the description in a separate field. This let me split the table for the description into the component parts, (underlying, expiration date, strike price, and call or put)
The only disadvantage is that this alternative data source is batch updated overnight, rather than in real time after the trade. However, for my purposes this is sufficient.
Thanks
John