I am not able to find solution in FDM for below scenario. It is very grateful if anyone can give an idea for below scenario.
Currently in our system, we have "Street" column, which can hold max of 25 characters. If street name contains more than 25 CHARS then remaining characters would be filled in "Street_extension" column.
Now we have seed file for streets that may contains, Street names with more or less than 25 characters. Here how can I put logic like - take street name randomly from seed file and put first 25 characters in column "Street" and remaining characters in "Street_extension" in FDM with any masking technic.