Community forum

Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
View
Go to last post Go to first unread
Offline stevja01  
#1 Posted : Tuesday, April 2, 2019 3:48:59 PM(UTC)
stevja01

Rank: Paid support

Joined: 7/10/2012(UTC)
Posts: 104
Location: Bentonville, AR, USA

Thanks: 23 times
Was thanked: 3 time(s) in 3 post(s)
VisualCron 8.4.1

I'm using the EXCEL - Convert task type to convert an EXCEL file with special characters (e.g. LÉVIS) to text.
On conversion, the TEXT file does not display the special characters correctly, e.g. LÉVIS becomes LÉVIS
I did try using UTF-8 and UTF-17 as the Encoding type on the task but it didn't make any difference.
If I try to save the TEXT file and change the Encoding it doesn't help either.

Any ideas on how I can convert an EXCEL file to TEXT and preserve the special characters?
Offline Support  
#2 Posted : Wednesday, April 3, 2019 9:59:50 PM(UTC)
Support

Rank: Official support

Joined: 2/23/2008(UTC)
Posts: 11,222

Thanks: 874 times
Was thanked: 446 time(s) in 424 post(s)
Please export the Job and send sample file to support@visualcron.com
Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!
Offline stevja01  
#3 Posted : Wednesday, April 3, 2019 10:08:39 PM(UTC)
stevja01

Rank: Paid support

Joined: 7/10/2012(UTC)
Posts: 104
Location: Bentonville, AR, USA

Thanks: 23 times
Was thanked: 3 time(s) in 3 post(s)
Hi Henrik,
Sincere apologies, this is not where the special character corruption occurred. Just found that out a few minutes ago actually. So we can close this one for now, I'll open another topic if I find it's something VC can control. I suspect it's on the upload to SQL for transformation and SQL is actually causing the corruption. But not sure.
Users browsing this topic
Guest
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Scroll to Top