You’re offline. This is a read only version of the page.
21
Hello,
Periodically I want to export to .csv a list of records from a filtered table. Example :
Customer Pallettype Date
------------------------------------
Nike Europal1 2023-05-26
Adidas Europal2 2023-05-24
Asics Europal1 2023-05-24
But I don't want to export directly these raw fields. I shall convert them so that my .csv export fits with a 3rd party app that will import the .csv
Nike shall be 0215-NIKE
Adidas shall be 3548-ADIDAS
Asics shall be 4782-ASICS
Europal1 shall be EURO 90 X 120
Europal2 shall be EURO 100 X 100
Could you please help me to figure out what's the more conveniant way to perform these fields translations ? Doable by SourceExpr Property ?
I think the easiest way would be to write code in the OnBeforeExport trigger for the pallet field.
Then you can make sure that the correct value is being exported.
Edit your dataport and press F9 to get access to the code for the triggers.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (