Focal Point
mfd for csv file with variable field count

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8111033041

December 02, 2005, 07:51 PM
susannah
mfd for csv file with variable field count
any ideas for writing an mfd to read a csv file with a variable number of fields?
other than posit thru the record, count the commas, and then add on a dummy field at the end to make the commas even in every record...oh so klugy!

ah. never mind; answered me own question, i did.
kb doc shows how

This message has been edited. Last edited by: susannah,




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
December 07, 2005, 08:43 AM
Jim Morrow
Susannah:
I have not tried it, but what about bringing it in as one field. Then defines in the master using GETTOK to break it apart.


Jim Morrow
Web Focus 7.6.10 under Windows 2003
MVS 7.3.3



December 07, 2005, 10:41 AM
susannah
thanks Jim, that was infact my first plan, before i discovered the cool DFIX format.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID