MySQL Forums
Forum List  »  CSV Storage Engine

Fixed-length fields
Posted by: Patrick Zahra
Date: February 05, 2010 02:31PM

I have a CSV file with fixed-width fields in it. I know how to import them normally:

FIELDS TERMINATED BY '' ENCLOSED BY ''

... unfortunately, each field also has a space separating it from the next. I don't want to have to create a mirror table with single-character fields between each one just to import the data, so is there another way? Like a placeholder variable or cast?

Also, the table fields are VarChar, will that cause an issue as well?

Options: ReplyQuote


Subject
Views
Written By
Posted
Fixed-length fields
8270
February 05, 2010 02:31PM
3896
February 24, 2010 10:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.