July 17, 2003 at 8:04 am
I am trying to import and transform a csv file. In the last column is a date wich i use the date transformation but it keeps failing with Cannot parse input data string
and the date string has a square box (cannot paste as it is a line feed) My row delimeter is {CR}{LF} wich shows correct columns,rows.
any idea how i can get rid of this extra | character? something like do a trim as well as date transformation.
July 18, 2003 at 6:38 am
If the field contains a LF then I think there must be a problem with the datafile. I have seen data where LF not converted and CR/LF added to each line producing LF/CR/LF and this seems to be your trouble. I have not ssen that error before and it depends on which part of the system is producing it. If it is the part where the file is read then you cannot do anything but if the transformation itself if causing the error then try changing the transformation to activeX script and validate/edit the data before transfer.
Far away is close at hand in the images of elsewhere.
Anon.
August 12, 2003 at 1:27 pm
Have you tried setting the row delimiter to {lf}{cr}{lf}.
This can easilt be set when you select your csv file.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply