AppGini Community Forums

Posted: **2023-01-08 20:57**

Hi everyone, when I export a file using the csv export button i am getting an apostrophe before negative values. I have tried updating the data list here

Code: Select all

// output CSV data
		while($row = db_fetch_row($result)) {
			$prep = array_map(function($field) {
				return strip_tags(
					preg_replace(
						['/<br\s*\/?>/i', '/^([=+\-@]+)/', '/[\r\n]+/', '/"/'], 
						[' ',             '\'$1',          ' ',         '""']
						trim($field)
					)
				);
			}, $row);

			$csvData[] = '"' . implode("\"{$this->CSVSeparator}\"", $prep) . '"';
		}

by adding in

Code: Select all

['/'/', '""']
in the preg_replace

But this does not work. does anyone have any ideas?

Posted: **2023-02-23 14:02**

Not sure if anyone will need this but I did get it to work. I know I am changing a central file which is not a great solution but this works for me for now.

Code: Select all

				return strip_tags(
					preg_replace(
						['/<br\s*\/?>/i', '/^([=+\-@]+)/', '/[\r\n]+/', '/"/', "/'/"], //Remove apostrophe
						[' ', 			'\'$1',	           ' ',            '',    ''],
						trim($field)
					)
				);

AppGini Community Forums

apostrophe before negative values in export csv file

apostrophe before negative values in export csv file

Re: apostrophe before negative values in export csv file