I have Description / Notes field, in which comma's should be deleted ( or replaced by point) for better exporting CSV.

đź’¬ General Discussion
1

I have Description / Notes field, in which comma’s should be deleted ( or replaced by point) for better exporting in CSV format

I have plus 60.000 so manual not possible and exporting to Excel, then in Excel find/replacing, is option but then importing again
is a difficult matter.
I have local installed SuiteCRM.

Is there an easy way ?

Thanks,
William

2

you could do it easily on database-level, mysql supports a string replace function:

select REPLACE(“im,a,test”, “,”, “.”)
-> returns im.a.test

you could use an empty replacement value as well
select REPLACE(“im,a,test”, “,”, “”)
-> returns imatest

using this function in an update-statement could fix your problem. but as always: create a dump first :slight_smile: