nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Reading in strings - 256 char limit

JonPedder

Hi, I'm reading in text values from xls and csv files, I'm using row.getValue('Field_Name") to read the values in. This method is working well with short sentences but fails once it hits 256 chars.

Is there another method that allows more characters to be pulled in?

Thanks

Vind meer berichten getagd met

Accepted answers

curtvprice

I'm reading in text values from xls and csv files, I'm using row.getValue('Field_Name") to read the values in. This method is working well with short sentences but fails once it hits 256 chars.

Is there another method that allows more characters to be pulled in?

This is a limitation of how tables are read in ArcGIS (using Microsoft Jet). However, there are limitations writing large strings to some data types as well (.dbf, .mdb).

You may have more luck reading long strings in a .csv using the python csv module.

All comments

curtvprice

Thanks that was helpful.

The odd behavior in reading strings equal to or longer that 256 is that the entire script fails, not just the one long string. For a field named Description and pulling in 10 rows of data, if just one value is too large all 10 rows fail on that field. You'd think that just the one record would fail not all.

Microsoft Jet parses through the first few rows of the file to determine datatype. This setup process is clearly broken by your long strings!

Here's more about this in the 10.0 help:

Adding an ASCII or text file table

JonPedder

Thanks that was helpful.

The odd behavior in reading strings equal to or longer that 256 is that the entire script fails, not just the one long string. For a field named Description and pulling in 10 rows of data, if just one value is too large all 10 rows fail on that field. You'd think that just the one record would fail not all.

curtvprice

I'm reading in text values from xls and csv files, I'm using row.getValue('Field_Name") to read the values in. This method is working well with short sentences but fails once it hits 256 chars.

Is there another method that allows more characters to be pulled in?

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.