Recent content by Steviet811

  1. S

    Add text at the beginning of a field

    I have a plan and wish to add a fixed length text string to the beginning of the field. Any suggestions would be gratefully received
  2. S

    Add text at the beginning of a field

    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...
  3. S

    Add text at the beginning of a field

    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...
  4. S

    Add text at the beginning of a field

    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?
  5. S

    Update query to remove spaces and export data

    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
Back
Top Bottom