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.
My input is a csv file. There are certain field names within the csv file which are more than 254 characters in length, they also have trailing spaces and line breaks. I'm using Input data tool to read the csv file. I tried to change the field length in the Input Data config to 1073871243 - looks like it affects only the field length not the fieldName length. Below is an example of a field name.
Please use the following definitions for this question:
If installed on your local computer, select 'Locally' (e.g., Microsoft Office) If hosted at the app, select 'Server-based' (e.g., Epic, Kronos) If accessed thr
Notice the truncation above.
I also tried renaming the column in select as shown below, but no luck :(. I also tried using the dynamic rename tool.
If your aim is to rename the header to "Installation Type" then the attached workflow should accomplish that. By reading the input file all as data, using regex to delete everything after the embedded new lines in header fields, and then dynamically renaming the columns via the first line you can cleanse any other columns with this issue.