AnsweredAssumed Answered

Copy specific text from Field

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

Title

Copy specific text from Field

Post

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?

 

Outcomes