Convert spreadsheet into a flat file

50 pts.
Tags:
Microsoft Excel
Microsoft Excel 2003
I need to convert a spreadsheet into a flatfile using the mid function. I only want to use a couple fields out of the spreadsheet, can someone help me?

Answer Wiki

Thanks. We'll let you know when a new response is added.

What do you mean “flatfile”, strictly speaking, an Excel spreadsheet is a type of flatfile. You need to provide much more information if you want help.

–JP

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Jerry Lees
    Can you give an examply of the input rows and what you want the output to look like? You specified the Mid function, so I assume you only need a protion of a cell-- Is that correct?
    5,335 pointsBadges:
    report
  • Gilly400
    Hi, Normally I use the "Save as" and then select .PRN, this should give you a flat file with no formatting. Alternatively I use .CSV comma separated variable files. Regards, Martin Gilbert.
    23,730 pointsBadges:
    report
  • Kioh46
    I am sorry I took so long to reply. I figured it out. I need to give each field a set length no matter what the length of the data is the field was, so i used the mid function to do so, concatenated with another field, repeating the process until I included all of my fields and then copied the and paste the values into text file. example(=MID(B:B&" ",1,9)MID(B:B&" ",1,9)&" "&TEXT(D:D,"MMDDYY")&" "&)MID(E:E&" ",1,20)&" "&MID(F:F&" ",1,5)&" "&..............) Result(flat file), xxxxxxxx xxxxxxxx xxxxxx xxxxxxxxx, xxxxx xxx xxxxxxxxxxxxx ,xx xx xxxx xxxxxxxxxxx xxxxxxxx xxxxxxxx xxxxxx xxxxxxxxx xxx xxxxxxx xx xxxx xxxxxxxxxxx
    50 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following