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 am trying to parse a flat file by different, known-in-advance lengths (ie, characters 1-25, 25-50, 50-65, etc.) with each entry ~600 characters long. I am getting Null outputs and the input field cells show that they have truncated characters. This is shown below.
Can anyone help me figure out what is going wrong here?
Can you provide an example of what you mean? I have tried adding ".*" in a few different place in the Regex with no success. Also if you can direct me to somewhere that has all-encompassing Regex syntax, that would be helpful as well. I haven't been able to find a good source yet that explains what all the syntax items (\d, ., *, etc) mean.
I'll use a tool like Excel or Notepad++ to help me. If I construct the <Fields> values and paste them into a document named MyLayout.FLAT I can import that as part of the INPUT tool and create the right NAMES and filetypes.
Using excel's concatenate function, I can read an input list of fields and sizes and quickly construct the xml. Yes, i could do that in Alteryx. too.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.
I converted the .dat file I was using to .xlsx, but am still getting the character truncation error. Can anyone explain what is happening here? I am trying to read in string records with whitespaces that are up to ~600 characters in length.
A cleaned sample file is attached with two rows of data. The file has 24 columns of different, but known lengths. The lengths of each field (including empties) that I am trying to extract is as follows: