Information générale
Titre:
Converting a UNIX file
Hi all
I've been asked to convert an old UNIX text file which has fields delimited by pipes ("|") - YUK...
The file does not contain fixed field lengths so I don't think that the approach I've used before :
mfileopen=FOPEN("&mfilenam")
USE mytable
DO WHILE !FEOF(mfileopen)
etc
etc
etc
...then using the SUBSTR command will work as the field lengths vary. The only solution I can see is to somehow strip out the "|" and replace them with "," so I can import the file into a table.
Does anyone have any ideas on how I can achieve this????
Regards
Chris Kable
FuelTrac
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement