You are viewing limited content. For full access, please sign in.

Question

Question

Substitution vs Pattern Matching

asked on December 7, 2016

Hello!  Need some assistance.  I may actually need both substitution and pattern matching...  I have a dollar amount that I have cleaned up, but now is not reading the "." (there actually isn't one...)

I am able to get it to read the figures, but now need to get it to format properly.  It will be anything from 10.41 to 154134.45 (examples) so it needs to be flexible for the number of preceding digits as I won't know.

 

Thank you for the help!

0 0

Answer

SELECTED ANSWER
replied on December 7, 2016

A substitution like this should work:

0 0

Replies

replied on December 13, 2016

That was it - thank you so much for your help :-)

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.