AnsweredAssumed Answered

Copy specific text from Field

Question asked by AlexOrrow on Dec 2, 2014
Latest reply on Dec 3, 2014 by AlexOrrow


Copy specific text from Field


Hi, I currently import file names as separate records. The filename is always the same format " xxxx_xxx_xxxx"

I would like after importing a list of filenames to copy each string of the filename into separate fields on the same record.

So filename 1618_D18_0010 would be copied into the the following fields:

FieldJob: 1618

FieldDisc: 18

FieldNumber: 0010


Is there a script that can do this please?