String Extraction

[Jackson]

Hi,

I'm importing a provided file (repeatedly) and one of the fields will have
Price information in the following format: [email protected] or [email protected] for
examples. I want to extract from this text string the Value of the number
after the @ sign. Any ideas on how I would achieve this?

Any help would be greatly appreciated.

Cheers,
Jack.

 

[Guest]

Try:

Mid([FieldName], instr([FieldName], "@") + 1)

HTH
Dale

 

[jackwoodhead via AccessMonster.com]

That worked perfectly, thanks!

Try:

Mid([FieldName], instr([FieldName], "@") + 1)

HTH
Dale

Hi,

[quoted text clipped - 7 lines]

Cheers,
Jack.