You need to sign in to do that
Don't have an account?
Taha Haider
How do i separate strings in a Text field??
How do i separate strings in a Text field??
"Taha Haider"
I want break this name into 2 sections.
1:Taha
2:Haider
"Taha Haider"
I want break this name into 2 sections.
1:Taha
2:Haider
Try like below: (Replace the Name in below with your field name)
Thanks,
Maharajan.C
Try this:
SUBSTITUTE(Name , " ", "")
Please Mark it as Best Answer if it helps.
Thanks!
Suraj Tripathi47 nop its not wokring
Thanks,
Maharajan.C
Hi Taha Haider,
If you want to split this string in two section then you can split that string in two different fields ,lets take a custom field called name and the value on this field can be separated in firstname and lastname.You can try this:
Thanks
This one is helpfull
If( CONTAINS(Name__c, " "), LEFT( Name__c ,FIND(" ", Name__c )), Name__c ) - for First Name If( CONTAINS(Name__c, " "), MID( Name__c , FIND(" ", Name__c ), LEN(Name__c )), null) - for LastName
But i only want Firstname and Lastname not the mid one
For example: Chloe Chloeeee Smith
Firstname : Chloe
Lastname : Smith
Dont show the mid name
Hi Taha Haider,
Try this one,it will give you your expected Result:
And Please don't forget to Mark it as Best Answer,if it helps you.
Thanks
Name: Chloeeee Chloe Smith
Try this name.