How do I use substring function in select inspection?

[demonoidea]

Hi All,

I need to select inspection by barcode scanner to select the individual file. (Barcode scanner is connect to PC by USB port.) The file name of inspection is part number only but barcode lable have partnumber&date&time. After scanned I need to cut the part number only before use in inspection table for select file. I cannot do that. Anyone please help me.

Thank you,
Aim

[AdnanZ]

What's the format of this string? Is there anything that's unique to all strings that are coming in? For example, is the length of the part number a constant? What about the date and time? If you can write a few examples, that would be great.

[demonoidea]

Hi Adnan,

First, I would like to say very thank you.

My barcode format is XXXXXXXXDD/MM/YYhh:mm:ss

XXXXXXXX = Part Number

DD = Day

MM = Month

YY = Year

hh = Hour

mm = Minute

ss = second

For example P123456714/12/1208:34:58

I need to cut only P1234567 to execute file P1234567.vbai

Regards,

Aim

[Silver_Shaper]

why don't you try string subset function found in string palette, or are you using vision builder?