Hi jdraw
The hard returns are causing on import to the crm salesforce.com to create new fields which is then misaligning the data and it's ending up in the incorrect fields. I want to batch edit the notes field (as sample file) before export removing the spaces and the hard returns.
My plan...
Thanks very much for looking
My problem is that I'm trying to run an update query to add a text string to the start of the field to resolve an issue that I'm having with date characters that are at the beginning of some of the fields.
I'm exporting the data as a csv for use in the crm...
Hi
I wish to add text at the beginning of a string in a field. I will use the append query function but, do not know the syntax.
Can anyone help please?
Hi
I want to remove random spaces and hard returns from a field replacing them with single spaces. The field is a notes section in memo format and we want to output as a csv files to import into the crm salesforce.com.
Any advice would be gratefully received.
Steviet811