QB export to ASCII Fixed Field Flat File

Question

Hey All,
We're need to export a file from Quickbase on a weekly basis to import into a trans-edi system for billing. They are requesting an ASCII Fixed Field Flat file. I only see an option for CSV exports from reporting. I was going to export to a CSV but then use BBEdit to strip the commas. The problem I am running into is some fields such as name fields (also left justified) are not always the same length and two groups of number fields are right justified and also not the same length. How do I overcome these? Can I build a formula to create the filler spaces or is there a different format that I can export too? I tried requesting help from the Support Staff, but the customer care rep suggested that I request it via the Feedback form.

I've attached the file format for you to review. We actually only use 16 fields, the rest I would have to add to Quickbase with the formatting. Please let me know your thoughts.------------------------------Mary Perkins M3TR1CS Business Solutionsmary.perkins@m3tr1cs.com------------------------------

JimHarrison · Answer

Hi Mary,All spaces are trimmed during export, so you would have to put a character into the field before export. You might be able to use a formula that adds a special character at the end up to a set number of characters. Alternatively using workato may be an option. You can also use something like BBEdit, Notepad++ or Excel and make a function, on your local device.I like Notepad++ because it allows me to see the ascii chars but that is the most manual process.I would build a solid process and then look at automation but I like to see the data and verify it is working properly before setting it free. I don't know if Quickbase will give good results.Good luck,------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------

Sign up

Login to the community