IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

Profile: timo
About
User Name: timo
Forum Rank: Newbie
Real Name:
Location
Occupation:
Interests:
Gender: None Specified
Statistics
Joined: Sunday, April 9, 2017
Last Visit: Sunday, April 9, 2017 1:25:23 PM
Number of Posts: 1
[0.01% of all post / 0.00 posts per day]
Avatar
Last 10 Posts
Topic: expressions with import?
Posted: Sunday, April 9, 2017 12:51:11 PM
Does any Altova product offer the import feature where the developer can fill a column in the target database with the result of a (scripting language) expression:

Quote:
Target..........................File to be imported
firstname.....................firstname
lastname.....................lastname
zipcode........................=left(zip,5)
company.....................="ACME WIDGETS"


The zipcode column is populated with the first five characters of the import file's [zip] column. The company column is populated with the arbitrary string literal "ACME WIDGETS".

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.