Subject | New member, need help with data 'padding?' |
---|---|
Author | supemoy |
Post date | 2005-09-22T22:16:57Z |
Hi, my name is John Connor and I am a new Firebird user. I have barely
scratched the surface of the documantation, but I have a hudge project
to do and very little time to do it in, and am hoping that I can get
some help here, or at least some sage advice.
I plan on googleing and researching my questions but if there is
anyone here who can answer me, your help would be greatly appreciated.
I am reading csv files to a table using firebirds built in
functionality. However when I query the fields I need the data returned
padded, for example if I query on a First_Name field I want the data
to be returned like "John " and trunicated if it exceedes the
field width.
I was thinking that I could set this up as a trigger for when the data
is droped into the table, and am hoping that I do not have to code the
padding routines into the client programs as that would increase the
complexity of the project ENOURMOUSLY!
Thank you all in advance for your help, sorry if this is an
exceptionaly newbish question.
scratched the surface of the documantation, but I have a hudge project
to do and very little time to do it in, and am hoping that I can get
some help here, or at least some sage advice.
I plan on googleing and researching my questions but if there is
anyone here who can answer me, your help would be greatly appreciated.
I am reading csv files to a table using firebirds built in
functionality. However when I query the fields I need the data returned
padded, for example if I query on a First_Name field I want the data
to be returned like "John " and trunicated if it exceedes the
field width.
I was thinking that I could set this up as a trigger for when the data
is droped into the table, and am hoping that I do not have to code the
padding routines into the client programs as that would increase the
complexity of the project ENOURMOUSLY!
Thank you all in advance for your help, sorry if this is an
exceptionaly newbish question.