cancel
Showing results for 
Search instead for 
Did you mean: 

Mapper Snap - Preparing fixed width text datafile

budhan
New Contributor

I use a Generic JDBC Execute Snap to run a SQL query which fetches multiple column data and few of them are NUMERIC. The output from this SQL query is an input to the mapper and the mapper is being used to create fixed width text datafile. When I try this expression, how to ensure it is NUMERIC when XYZ is written the text file.

($XYZ + ('         ')).substring(0,9) 

 

0 REPLIES 0