Hello !
I have amount fields in the below format that need to be converted as
Thank you that works but i cant understand, would you be kind enough to break it down.
For example what is the first condition that you are checking
Sorry if i sound stupid.
@AbhijeetChib I replied to your latest post
@AbhijeetChib Can you check the user settings and check the thousand separator configured properly ?
Hello @binu_acs
Thanks for your response - The thousand separator is fine.
Sometimes in the input files i get Amount in both formats
123456789 as well as 1,234,567.89 and 1.234.567,89\
Need to ensure they all are separated by , in thousands and .in decimal
@AbhijeetChib
Thanks a lot @binu_acs
Although it did solve a bit of the issue but it messed up others, here is the data
Thanks for your help again
@AbhijeetChib the amount ending with decimal doesn’t need any update , the first condition checks whether the amount ending with decimal ( the RIGHT() will take the last 3 character then the LEFT () function check the first chat from left is a decimal or not) , if not ending with decimal then apply the formatting
Thank you @binu_acs
In the above sample the below formats are not being arranged properly
