text to column non-deliminated

i have two data sources and i need to compare a very large (150 characters in one, 160 characters in the other) field. This field is non-delimited but i have a listing of "of this field, the first 3 characters stands for body type, next 1 character is engine type, etc..". the problem is, a lot of them are 1 character fields and I was hoping to not have to specify 100 regex parts. Is it possible to break a field, 1 character at a type, without delimiters (and i can visually group the fields which need to be grouped)?

thanks

becki kain

Expression

Accepted answers

GiuseppeC

@becki, see if the attached works. I used @mmenth's suggestion to serialise the image into rows, then added a record ID and joind the 2 images based on that, then added a formula tool to compare the 2.

Hope this helps!

Giuseppe

Serialise and Compare.yxmd

All comments

GiuseppeC

Hi @becki,

it would be easier if you could post some sample of the data you want to compare/parse and the listing (suppose it could be used as a look up table somehow?).

Giuseppe

becki

it's a VO Image:

1FTYE1CM5HKB45608 E1CHK130 C 3 AG2 01FM083 VE G 5E673 C81D 1 BX C HF 316A218 L2 YZ VK GB M1FTY5A8 101A 9M6DE

but the spacing is significant, like i can't just take all the spaces inside the string. columns 1-3 mean something, column 4 is something else, etc...

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703