Selecting characgers from a text field

[Abay]

Hello ... I have a field (which is a file name) the contents of which look
like: "452F1234REVA.dwg" or 334M2222.001REVB.dwg".

I need to extract the contents to look like: 452-F-1234 AND 334M2222.001and
place them in another field. I need to place the revision no which is the A
and B at the end of "REV" in another field.

I can insert the dashes and extract the revision no, but need help
eliminating the REVA.dwg from the end of the file name ... the problem for
me is that the format is different between the two fields as shown above.

Any help would be most appreciated.

Abay

 

[tina]

if you always want to remove the "REV?.dwg" from the end of the text string
(the question mark standing in for any single-character revision value),
then try

Left(FieldName, Len(FieldName) - 8)

replace FieldName with the name of the field that holds the values you
posted, of course.

hth

 

[Abay]

Many thanks Tina ... that's exactly what I needed .. Abay

 

[tina]

you're welcome

Many thanks Tina ... that's exactly what I needed .. Abay