on Oct 31, 2016After 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.
A couple suggestions which may or may not help...
When you upload the file, try using Text/ASCII mode instead of binary. File transfer clients such as WinSCP support this option.
You can try the dos2unix command on the Linux server to convert the file to the proper characters:
e.x. dos2unix myfile.csv
Yes, I tried with this option. But no luck. Data remains same, Is that something to do with sharepoint server which doesn't have MS-Office installed.
RSA Customer Support (Internal) RSA Customer Support Appreciated if someone helps me with this on priority.
Hi,
Can you attach the file with few sample data here so that I can reproduce.
Thanks, Amit
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.
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.