Query to extract

  • Thread starter Thread starter WDP
  • Start date Start date
W

WDP

I am trying to find a solution to the following. I have a Table with
thousands of records that look like the following:

"CN=ExchangeService

I want my QUERY to extract everything to the RIGHT of the "=" sign

In the example above.....I want to endup with

ExchangeService

Can anyone help me solve this??

Thanks
Warren Phillips
 
I am trying to find a solution to the following. I have a Table with
thousands of records that look like the following:

"CN=ExchangeService

I want my QUERY to extract everything to the RIGHT of the "=" sign

In the example above.....I want to endup with

ExchangeService

Can anyone help me solve this??

Thanks
Warren Phillips
Click to expand...

If the number of characters before the = sign can vary in length,
then...

ExtractedText:Mid([FieldName],InStr([FieldName],"=")+1)

If the characters before the = sign are always 2 characters, then ...
ExtractedText:Mid([Fieldname],4)
 
Vary in length. Your suggested worked perfectly.....WOW....Thank you very much

fredg said:
I am trying to find a solution to the following. I have a Table with
thousands of records that look like the following:

"CN=ExchangeService

I want my QUERY to extract everything to the RIGHT of the "=" sign

In the example above.....I want to endup with

ExchangeService

Can anyone help me solve this??

Thanks
Warren Phillips
Click to expand...

If the number of characters before the = sign can vary in length,
then...

ExtractedText:Mid([FieldName],InStr([FieldName],"=")+1)

If the characters before the = sign are always 2 characters, then ...
ExtractedText:Mid([Fieldname],4)
Click to expand...
 
Back
Top