Hello!
I have a problem, i didn't found yet the solution so i am asking your help. In my database I have some int, decimal and string that needs to be convert in numeric with specific length and precision to include in a flat file.
ex:
integer 123 to numeric(8,0) ==> 00000123
decimal 123,123 to numeric(8,8) ==> 0000012312300000
String "22" to numeric(8,0) ==> 00000022
It can't put comma or dot. Is there an easy solution I try a lot of things but none will give me my result except doing loops foreach Filed in my flat file too dirty!!
EDIT:
the flat file gets information based on there start point and the lenght so every data i includ in the file has to be a cetain lenght. And for the Numeric I have for exemple
database Decimal Price = 123,456
File Numeric(8,6) Price = 00000123456000
I wanted to know how could i parse any decimal or integer data based on N(,)