After transferring csv (tab separated) file from local to IAM server, it is getting changed as in the attached screenshot.
Can anyone guide me how to keep the file intact as the file is being generated from windows powershell script that runs in sharepoint server.
Had to do some workaround within sharepoint script, by changing the tab separated into quotes enclosed comma separated using the below statement.
Import-Csv <filename.csv> -Delimiter `t | Export-Csv <newfilename.csv> -NoTypeInformation
And handled the output with inbuilt option from L&G. Its working absolutely fine.