Detect csv file formt
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
sharmilaj
7 - Meteor
‎09-04-2023
07:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have a bunch of text documents which is read as csv in Alteryx.
The csv is formatted both in ANSI and UTF-8.
I need a way to detect each file in the path on whether it is ANSI or UTF-8. If so i want to maintain a similar kind of files maintain UTF-8.
Is there a way in Alteryx to detect and then change the file format. ?
Thanks!
Labels:
- Labels:
- Community
- Data Challenge
- Topic of Interest
1 REPLY 1
caltang
17 - Castor
‎09-05-2023
06:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can see that information via XML:
From there, you can fetch the code and compare it against the table at the bottom of this page: https://help.alteryx.com/20231/designer/code-pages
This is the best way I know of.
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/