Hi there,
I am trying to use the Parse CSV function to take a file supplied by a FTP server and import it into Hubspot. The FTP data is supplied with a header sep=, which is causing issues with make reading the correct number of columns. I belive this is added by some systems for excel. How do i get make to ingore this text and sart after the fist delimiter.
Welcome to the Make community!
How does it actually look like? Can you please upload the file here, or take a screenshot of the issue?
Generally, you should be able to use the built-in function replace
For more information, see the replace function documentation in the Help Center and do the tutorials in the Make Academy.
To allow others to assist you, please provide the following:
You can upload images here using the Upload icon in the text editor:
Sharing these details will make it easier for others to assist you.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
Thanks Samilew,
I have uploaded some screenshots below for reference. The CSV is a simple output from a SFTP server. I used the below Replace function to remove the “sep=,” issue that I was having and it seemed to run fine until recently where it is now showing an error on the last line of whatever data i import saying that it does not match the header.
Any help is greatly appreciated.
Looks right. Issue is with your CSV file, so we’ll need to view a copy of that to help find the problem.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
thanks - have sent it to you via DM
