separate "last, first" values from csv

  • 13Views
  • Last Post 22 April 2019
  • Topic Is Solved
0
votes
Peter Gutmann posted this 13 April 2019

I'm trying to upsert a csv of Contacts from Cvent into Salesforce. The Contact names in the csv are formatted "last, first", and I need to separate them so they import correctly into the Lastname and Firstname fields in the Salesforce Contact object. Can I do this with an expression? Or do I have to separate the values in the csv, and then import? Thanks!

Order By: Standard | Newest | Votes
1
votes
Mariia Zaharova posted this 15 April 2019

Hello Peter!

Yes, you can try using Expression mapping for this case. For example:

 

I.e.:

LastName: SUBSTRING([last, first],1,FINDSTRING([last, first],",",1)-1)

FirstName: SUBSTRING([last, first],FINDSTRING([last, first]," ",1)+1,(LEN([last, first])-FINDSTRING([last, first],",",1)+2))

 

Please tell me if this helps.

  • Supported by
  • Peter Gutmann
0
votes
Peter Gutmann posted this 22 April 2019

Excellent. Thanks much!

Close