AnsweredAssumed Answered

Recursive function help, CSV import

Question asked by BobSchwenkler on Mar 29, 2011
Latest reply on Mar 31, 2011 by philmodjunk


Recursive function help, CSV import



I have not gotten into recursive functions at all yet and it seems like this is what's needed to do what I want to do, so I'm looking for a bit of help to get started on a problem at hand.

I have a Quickbooks report that I'm creating an FM import script for. The report needs to be pivoted to get data where it ought to be. Unfortunately, it has about 400 something rows in it, too many for Excel to open, so I'm scripting an import and pivot for the CSV data in FM. Before I get started, if anyone has any other ideas for pivoting this information, I'm open to options, though it would be nice to keep the user's required interaction to a minimum.

My only hangup right now is that some of the item names have commas in them which is screwing up my delimiting. Basically, I want to substitute any commas in the item names into some other character, or to simply remove them. Here's some sample text:

"Blow, The - Other","KLP052 -  The Normal Years","KLP086 - Introducing . . .",

Thanks in advance.