You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Importing data records surrounded by quote

Received Response
21
Views
4
Comments

Hello. I'm trying to import data into FCC and the records, while comma delimited, are surrounded by quotes. They look like this:

"Account,CostCenter,Amount"

So the whole record is being treated as one field. I can deal with that for the account, cost center, etc. but none of the records come in as the amount is non-numeric. The amount field doesn't offer the same expressions on the import format as the other dimensions.

Thoughts?

Eric

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!