Limited Field Length - CSV document

[AlbertoALRM]

Hello everyone, 

I am parsing a CSV document, which has a 254 field length. The document has no delimiters, all characters are all together without spaces.

I am using the formula tool to parse the data, using the Substring function. After reaching the 254 field length in the formula, Alteryx does not show any more values/characters. 

To solve this problem I have tried the following:

1) In the input tool I have set the field length to a very high number (let´s say 1.000.000), it hasn´t work the result remains the same. 

2) I have inserted a select tool after the input tool and change the size to a very high number (let´s say 1.000.000), it hasn´t work the result remains the same. 

3) I have inserted a formula tool and use the Length formula and the result has been 254. 

Let me know if there are any ways to solve this problem. 

Thank you in advance.

[grchavarri]

Hi @AlbertoALRM 

2 keys that I think could be the problem:

1. Could you please show us the encoding that you are using to input the csv? Sometimes some encodings different to UTF8 make some weird errors in the field length.

2. How are you extracting the file that you are using as an input? Is it coming from another alteryx flow and extracted from a browse tool? If this is the case, maybe you have to output the csv with and output tool because the browse tool always output the csv with the 254 length by default.

is there any of those cases??

hope it helps

[Garabujo7]

Hola @AlbertoALRM ,

You may check and change the file encoding here as @AlbertoALRM mentions.

Also, could you include a sample of the data to take a look at it.

Gabriel

[FláviaB]

Gracias por la publicación, @AlbertoALRM.  Y gracias por la ayuda, @grchavarri. 

Para que todos los miembros puedan seguir y comprender, aquí puedes comunicarte en español con total libertad. 😉