How to load a text file in SAS Data Integration with comma separator in amounts fields instead

ivanfesua — Mon, 11 May 2020 11:04:59 GMT

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.

topic How to load a text file in SAS Data Integration with comma separator in amounts fields instead in SAS Studio

How to load a text file in SAS Data Integration with comma separator in amounts fields instead