Hi Guys, I am trying to remove the space between $ and value. I have used the below mentioned query with * as a wildcard but it changes the whole value of cell into $*, I know i should use something like REGEX but i am not sure how to apply it. Please advice on how to solve this.
UPDATE TABLE NAME SET TABLE NAME.[COLUMN NAME] = "$*"
WHERE (((TABLE NAME.[COLUMN NAME]) Like "$ *"));
Example data of what i am trying to replace with.
Existing format Required format $ 58,700,000 $58,700,000 $ 2,076,890,000 $2,076,890,000 $ 313,797,052 $313,797,052