OL Learn

Data mapper join fields and padding

Hi all,

I want datamapper to take the vaules from two field and combine them into one field with padding to one cell, the input file is a .csv and lets call he field IMID and MARK, in short in excel this would be:

Any tips?

Try this:


or even better (didn’t realize padStart() was available):

1 Like

Thanks Phil,

Could not get the padding one to play ball but the 1st one worked like a treat and now I can add and remove data into new fields to my hearts content!