Script to Take Substring of a Field (First 6 characters)

  • 94 Views
  • Last Post 14 February 2020
zroy21 posted this 13 February 2020

I am trying to take the first six characters of an extracted field and was wondering if anyone has done this in a simple VB script. I am open to use C# too but I am just more familiar with VB. 

 

Thanks in advance, everyone!

Order By: Standard | Newest | Votes
HamdiM posted this 14 February 2020

Can you please attach for me an exemple of the doc you have ? 

Regards,

 

HamdiM posted this 14 February 2020

Hello,

For C# :

 

string Field;

NewString = Field.Substring(0,6);

 

 

Regards,

Hamdi

 

zroy21 posted this 13 February 2020

Right now this is what I have but I do not believe that I am calling the variables correctly:

Field("ExportDate") = Field("Document Creation Time").Substring(0,6)

Close