AnsweredAssumed Answered

How is this data delimited?

Question asked by danlunsford on Oct 30, 2017
Latest reply on Nov 15, 2017 by xander_bakker

Hello all,

 

We received this data from our friendly neighborhood appraisal district- their 2017 certified tax roll.  We're trying to work with it, but the very first task is to figure out how it is delimited!  It doesn't seem to be comma, tab or anything else- maybe custom but darn if we can figure out what that might be (FF? 000000000000000? Other)?

 

We contacted the CAD and they don't know either- something they're working with their new software vendor to figure out.  In the meantime, I thought I would pose this question to the community and see what folks say.  Here's a sample of one record copied directly from the Wordpad file:

 

 

000000000000000

000000100002R 02017000000000000A 3505-0006-0001-000 000000450876TSB LTD F000000000000 510 BERING DR STE 310 HOUSTON TX 77057 FF Y ABST 628 PAGE 135 LOTS 1 & 2 BLK 6 GALVESTON 0000000000002560S3505 3505.3 000000000000000000000000030120000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000030120000000000000000000000000030120 F 001-52-0811 000000000000 000000000000 F FF FFFFFFFFFFF FFFFFFFFFF C1

 

Quite frankly, I'm not even sure where one record ends and the next begins... The link below goes to the data itself (click the, "2017 Certified Roll" link):

 

 

http://www.galvestoncad.org/index.php/Tax_Information

 

Thanks!  I will provide additional information as I can and as requested

Outcomes