Bhupesh, Despite the fact that Remedy stores Currency fields as two fields in the DB, it is still considered a 'single' field that contains both numbers and the currency, so it makes sense that it would export to a single column when doing a csv export, and I assume also expect it as such on an import as well, so I'm not entirely sure where the problem lies, but once in CSV you should be able to use Excel's 'Text to Columns' feature to parse the one field into two columns if you are needing it to be separate.
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Bhupesh Gupta Sent: Friday, September 02, 2011 2:11 AM To: arslist@ARSLIST.ORG Subject: How to Extract Currency Type and Value in an Csv - Urgent ** Can some one please help how to pull currency fields in remedy by using standard reporting procedures? Tools --> Reporting Select fields and Report to .csv. CSV does not extract currency.type and currency.value as separate columns. Can some please help here? It is urgent. -- Regards, Bhupesh Gupta _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
