Decimal Custom Converter (for fixed length files)

In the FixedLength records when you need to read decimal info you donīt have the decimal bacause this is donīt needed. This example explain how to read that.

If you like to parse a file with a field that has different parsing rules you can define a CustomConverter, for example if you have this source file:

0001250001458800013025 0001260012345600234567 0001270123456702345678 0001280087654300123456

This is a FixedLength record file with 6 chars for the Producto Id and 8 places for each Price (6.2) the record class must be like this:

[FixedLengthRecord] public class PriceRecord { [FieldFixedLength(6)] public int ProductId; [FieldFixedLength(8)] [FieldConverter(typeof(MoneyConverter))] public decimal PriceList; [FieldFixedLength(8)] [FieldConverter(typeof(MoneyConverter))] public decimal PriceOnePay; }

The last step is to define the converter, you must inherit from the ConverterBase

public class MoneyConverter : ConverterBase { private int mDecimals = 2; public override object StringToField(string from) { return Convert.ToDecimal(Decimal.Parse(from) / (10 ^ mDecimals)); } public override string FieldToString(object fieldValue) { Decimal v = Convert.ToDecimal(val); // ugly but works =) string res = Decimal.ToUInt32(Decimal.Truncate(v)).ToString(); res += Decimal.Round(Decimal.Remainder(v, 1), mDecimals) .ToString(".##").Replace(",", "").Replace(".", "").PadLeft(mDecimals, '0'); return res; // a more elegant option that also works // return Convert.ToInt32(Convert.ToDecimal(fieldValue) * (10 ^ mDecimals)).ToString(); } }

Done !! you can actually parse the file with.

FileHelperEngine engine = new FileHelperEngine(typeof(PriceRecord)); PriceRecord[] res = (PriceRecord[]) engine.ReadFile("NameTest.txt");

See also

Must Read - Quick Start Guide - Attributes List - F.A.Q. - Examples of Use - Contacts & Credits - Donations

---