Can't import fixed decimal in a flat file config.

LeandroDamato

Hey guys, I have some records in a file that is .txt and needs to be formatted by a flat file so it appears as it is supposed to.

So here's how I did it, I chose this option:

Then I delimited as the support file that I have where it says how much characters each column should have. E.g. the field "Empresa" has 4 strings in the clients, file so I went in there and selected the first 4 strings:

And so i did it the same for each field for the rest of the file. The problem is the fields that were fixed decimal (LOCAL VALUE / OUTSIDE VALUE) are displaying as null and I don't know why. I've arranged a way that works by separating the fields in 3 columns each: one column were the integer number before the decimals, the decimal separator and, the 2 decimal digits. But I would really appreciate to know how to do it the "proper" way.

I've attached all the files that were used. Please change the "Import Settings_v1" to .flat (it's not a supported file to attach in here).

Test_v1.TXT

Import Settings_v1.TXT

Maskell_Rascal

Hi @LeandroDamato 

Try importing the field as a string to start. you can then convert it to a FixedDecimal using the Select Tool. Just make sure that you select the "Use commas as decimal separators (String/Numeric conversion only)" option at the bottom. 

After that, the data will come through correctly. 

If this solves the problem please mark answer as correct, if not let me know!

Cheers!

Phil