sub String

[NavinReddy]

Dear Experts

I want to fetch a value mention in bracket,im using this expression its not working
please some one help me to fetch only "in USD"

=Mid('Jan Cost     (in USD)', Index('Jan Cost     (in USD)', ' ') +8)

Best Regards,

Niranjan

[maxgro · Accepted solution]

if your strin gis str

= mid('$(str)', Index('$(str)', '(')+1, Index('$(str)', ')')-Index('$(str)', '(')-1 )

see attachment

[Anonymous]

Hi,

mid('Jan Cost     (in USD)',11, 1 )

or

mid('Jan Cost     (in USD)',12, 1 ) - if there are two spaces in the string after Jan Cost

[NavinReddy]

Hi Massimo,

Thank you so much for your valuable response

Best Regards,

Niranjan

[MarcoWedel]

Hi,

one solution could be also:

TextBetween('Jan Cost    (in USD)', '(', ')')

hope this helps

regards

Marco

[NavinReddy]

Hi Marco,

Thanks Again

Best Regards,

Niranjan