Skip to Content
0
Aug 08, 2023 at 10:20 AM

Replacing the specific number with another one

131 Views Last edit Aug 08, 2023 at 10:22 AM 2 rev

Hi ,

I have report (multilingual) which brings the medicinal details for different countries and it has one column where the temperature is coming at which the drug is stored.

Here the numbers are getting reversed for example:

Temperature 2 C and 8 C (expected) its getting reversed to Temperature 8 C and 2 C (incorrect) which is not correct.

The report is showing the correct values for some countries whereas for other its showing wrong.

Please suggest that how can i replace =if 8 is coming at first position then it must be replaced with 2 and 2 at last with 8.

Thanks

temp1.png

temp2.png

Attachments

temp1.png (3.8 kB)
temp2.png (3.2 kB)