Find $

  • Thread starter Thread starter Max
  • Start date Start date
M

Max

I have data that starts with $ which is easy to find.

But sometime the $ is blended in the text

please note this data is in Access??? But if I have to move it to excel ok...

Hello-$10.00 SPEC COPAY
Hello - $30.00 SPEC COPAY
VARIOUS COPAYS,INCL. $10 SPEC
Hello $20 SPEC COPAY / $0 FOR KIDS

How can I pick in a new column as follow
$10
$30
$10
$20

Thanks
 
That was great:)

I forgot this one

CCI - $0 INN-OON $25 PCP CPY

its picking the $0 and i need the $25.


KARL DEWEY said:
MyDollars: Format(Val(Mid([YourField], InStr([YourField], "$")+1)), "$0")

--
Build a little, test a little.


Max said:
I have data that starts with $ which is easy to find.

But sometime the $ is blended in the text

please note this data is in Access??? But if I have to move it to excel ok...

Hello-$10.00 SPEC COPAY
Hello - $30.00 SPEC COPAY
VARIOUS COPAYS,INCL. $10 SPEC
Hello $20 SPEC COPAY / $0 FOR KIDS

How can I pick in a new column as follow
$10
$30
$10
$20

Thanks
Click to expand...
Click to expand...
 
Dont worry... Thanks again

KARL DEWEY said:
MyDollars: Format(Val(Mid([YourField], InStr([YourField], "$")+1)), "$0")

--
Build a little, test a little.


Max said:
I have data that starts with $ which is easy to find.

But sometime the $ is blended in the text

please note this data is in Access??? But if I have to move it to excel ok...

Hello-$10.00 SPEC COPAY
Hello - $30.00 SPEC COPAY
VARIOUS COPAYS,INCL. $10 SPEC
Hello $20 SPEC COPAY / $0 FOR KIDS

How can I pick in a new column as follow
$10
$30
$10
$20

Thanks
Click to expand...
Click to expand...
 
Try this --
MyDollars: Format(IIF(Val(Mid([YourField], InStr([YourField], "$")+1)) =
0,Val(Mid([YourField], InStrRev([YourField], "$")+1)), Val(Mid([YourField],
InStr([YourField], "$")+1))), "$0")

--
Build a little, test a little.


Max said:
That was great:)

I forgot this one

CCI - $0 INN-OON $25 PCP CPY

its picking the $0 and i need the $25.


KARL DEWEY said:
MyDollars: Format(Val(Mid([YourField], InStr([YourField], "$")+1)), "$0")

--
Build a little, test a little.


Max said:
I have data that starts with $ which is easy to find.

But sometime the $ is blended in the text

please note this data is in Access??? But if I have to move it to excel ok...

Hello-$10.00 SPEC COPAY
Hello - $30.00 SPEC COPAY
VARIOUS COPAYS,INCL. $10 SPEC
Hello $20 SPEC COPAY / $0 FOR KIDS

How can I pick in a new column as follow
$10
$30
$10
$20

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top