This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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)?
@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.