crionsynx Posted May 5, 2022 Report Share Posted May 5, 2022 I have a data import/export task that loads data from csv file through sftp. How do you update a text field with existing value to null or empty value from the csv file? I found that this is possible in a date field by passing 'null' value without single quotes but this is not working for a text field. Quote Link to comment Share on other sites More sharing options...
0 Tubby Posted May 27, 2022 Report Share Posted May 27, 2022 Have you tried using a single space? I think Text(255) fields ignores the value if it only contains a single space. Quote Link to comment Share on other sites More sharing options...
Question
crionsynx
I have a data import/export task that loads data from csv file through sftp. How do you update a text field with existing value to null or empty value from the csv file? I found that this is possible in a date field by passing 'null' value without single quotes but this is not working for a text field.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.