Good morning, I needed help solving a problem with the SAS Data Integration Studio 4.903 tool. It is related to the import of delimited text files, for this I use the File Reader object that is within transformations / access. sequence load file into oracle table The problem is the following, the amounts fields come with a comma separator in the decimals when importing with the File Reader, I define them all as Alphanumeric and then with a table loader, I load them in a table of the Oracle Database , it is here in the table loader where I modify the format of the amounts fields to 19.2 Example File Definition fields in the file reader Definition fields in table loader When the load is carried out, I check the data in the table and it turns out that the records with amounts with decimals come to null, because the Database has the point as a decimal separator. The temporary solution applied was to modify the file directly by replacing the decimal point with decimal point. modified file - decimal separator instead of comma Is there a way to configure or define a parameter to tell it to take the point as a decimal separator. I have seen as an option in the File Reader that you can add code in INFILE. advanced file properties Thank you very much and I hope you can help me.
... View more