tombrown
Active Member
Hi List,
I am having trouble importing a CSV file using a table convertor. The fields in my file are of variable length, for example I may get
tom,12345,needs,help
or
paul,123,does,not
when defining the layout of my csv file within the table convertor tool, I name the 4 fields in order, but am also asked to specify the length of the fields. If I define the second field as 5 long, it will be assigned a value of 123,d for the second record.
Anyone come across this and found a way round? I must be doing something wrong - or going mad.
TIA
Tom Brown
OneWorld 733, Oracle, NT Servers
I am having trouble importing a CSV file using a table convertor. The fields in my file are of variable length, for example I may get
tom,12345,needs,help
or
paul,123,does,not
when defining the layout of my csv file within the table convertor tool, I name the 4 fields in order, but am also asked to specify the length of the fields. If I define the second field as 5 long, it will be assigned a value of 123,d for the second record.
Anyone come across this and found a way round? I must be doing something wrong - or going mad.
TIA
Tom Brown
OneWorld 733, Oracle, NT Servers