Customizing the character sequence as per user's need


I have a column by the name of EMP_ID which is a random string of 8 characters. Now I need the first 3 characters of that string to be the same as the first 3 letters of the state that employee belongs to (state column in dataset), is there a way I can achieve this? Please let me know if there is.


Use the Character Sequence type with a value of “#####” and add the following as an inline formula:

field("state")[0..2].upcase + this

See Mockaroo - Random Data Generator and API Mocking Tool | JSON / CSV / SQL / Excel for an example