This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I apologize for the simplicity of this question (new user), but would anyone know offhand how I could handle an input file (.csv) that uses pipe symbols to separate columns?
I'd like to be able to select each column separately but haven't much success using the 'Data Cleansing' option. Unfortunately the file I'm working with is pretty massive and I'm unable to open in Excel. I suppose I could probably do a find and replace in Notepad but am curious if there's a way I could do this directly in Alteryx without having to manipulate the input file beforehand.
Thank you for any help in advance, I appreciate it!