Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

remove commas from a column data

dmikester1's profile image dmikester1 posted 4 years ago in General
Hello,
Loving this program. I came from Toad which was constantly crashing on me. One thing about this that bugs me is the addition of commas to all numbers in columns. Is there a way to remove commas from a specific column?
Emma Taylor's profile image Emma Taylor posted 4 years ago
In sql server you can use REPLACE for remove data and STUFF to add data

as follows

replace('Your String','charater you want to replace','with what')



stuff('Your String',position,count,'data')
ansgar's profile image ansgar posted 4 years ago
@dmikester1: I guess you mean integer and float columns, which are formatted by HeidiSQL in your local number format by default.

You can disable local number formatting in Tools > Preferences > Text formatting > "Local number format"


Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.
dmikester1's profile image dmikester1 posted 4 years ago
@ansgar: that did the trick, thank you very much!
danoldenkamp's profile image danoldenkamp posted 5 months ago

in 10.1 Tools > Preferences > Text formatting > "Local number format" is not there.

Found it under:

Tools > Preferences > Grid Formatting > uncheck "Local Number Format"

Please login to leave a reply, or register at first.