I want to edit some value that will need some validating inside the source file with some condition inside the source file.
I know the easy way is to build the validation inside import script, but the import script usually will run for each row, if I put the logic inside it will make the performance slow, I assume, because every one row, it will open the file.
So I try to do one time conversion, so I choose to put my logic inside BefFileImport VBScript, but after my script run, the value was not change, it still stick with old value.
Need your help for this.
the below example, I want to do
Sub BefFileImport(strLoc, strCat, strPer, strFile)