How to trim the data?

[Anonymous]

Hi Friends,

I have a column with data like "00125460014600-CD", i want to trim and the output should be in 12 digits "125460014600".

Means trim first 2 digits and last 3 digits. Please help me out.

[tresB]

Try this:

Mid('00125460014600-CD',3, len('00125460014600-CD')-5)

[kogasawara]

hi!!

try this!!

-------------------------------------------

mid('00125460014600',3,12)

-------------------------------------------

[Anonymous]

say if a column(DmdUnit) has n no of data , how can i use the above conversion?

[Anonymous]

say if a column(DmdUnit) has n no of data , how can i use the above conversion?

[tresB · Accepted solution]

Then,

Mid(DmdUnit,3, len(DmdUnit)-5)

Assuming that the data in the field would be of similar format.

[kogasawara]

hi thank you for your replay!!!

how about this??

=left(right(DmdUnit,len(DmdUnit)-2),len(right(DmdUnit,len(DmdUnit)-2))-3)