Limited Field Length - CSV document

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.

Data Investigation

Accepted answers

All comments

AncientPandaman

if 1,000,000 not enough, just extend it to 1,073,741,823. (Max size the alteryx have.)

if still not enough, you may need to try to either change your data source or change tool to use.

beside, i saw you manual split the data, you can try this way. (if the data is split by fixed length)

regex formula : (.{10}|.{0,10}$)

mceleavey

Hi @AlbertoALRM ,

can you post a sample of the data so we can help?

Tony_Castillo

In your Input tool, trying changing the Delimiters to \n

Also, update the Field Length in the Input Tool to 254000000

AlbertoALRM

Hello,

I have tried to extend it to 1,073,741,823. (Max size the alteryx have.), but is still not working.

The data is not split by fixed length unfortunately.

AlbertoALRM

Hello Tony,

I used your suggestion and although I do not see all the fields in the formula tool I can see there are all fields in formula output.

Your solution may have partially solved the problem.

Thank you.

AncientPandaman

just realise if it pure number, the text length is double up to 2147483647 (2,147,483,647)

Tgigs

I have a text file that contains 1000 lines with long strings. I read in with no delimiter and field length 16777216. Setting this field length is max you can read from CSV.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703