You need to sign in to do that
Don't have an account?
Hector Diaz
Parse text fields
Hi
i have a text field separate by semicolon, for example
word1;word2;word3;word4;word5
and i want a custom formula field for each word, for example
field A populated by word1
field B populated by word2
field C populated by word3
field D populated by word4
field E populated by word5
i have these formula, but only works with one semicolon
LEFT(textfield__c, (FIND(",", textfield__c)-1))
RIGHT(textfield__c, (LEN(textfield__c) – FIND(",", textfield__c)))
Thanks for your help
i have a text field separate by semicolon, for example
word1;word2;word3;word4;word5
and i want a custom formula field for each word, for example
field A populated by word1
field B populated by word2
field C populated by word3
field D populated by word4
field E populated by word5
i have these formula, but only works with one semicolon
LEFT(textfield__c, (FIND(",", textfield__c)-1))
RIGHT(textfield__c, (LEN(textfield__c) – FIND(",", textfield__c)))
Thanks for your help
Try this for text5__c
right(Text__c,len(Text__c)-find(';',Text__c,find(text4__c,Text__c)))
Thanks
Please mark this answer as best if this resolves the issue.
All Answers
tks for your answer,maybe a batch it's not good idea becuse these kind of fields such as word1,word2,word3,word4,word5 are not very frecuent in my org.
best,
Hi Diaz,
considering textfield__C as text__C
field A text1__C
field B text2__C
field C text3__C
field D text4__C
field E text5__C
formula for text1__c is left(text__c,find(';',text__c)-1)
formula for text2__c is left(trim(substitute(text__c,text1__c+';',' ')),find(';',trim(substitute(text__c,text1__c+';',' ')))-1)
formula for text3__c is left(trim(substitute(text__c,text1__c+';'+text2__c+';',' ')),find(';',trim(substitute(text__c,text1__c+';'+text2__c+';',' ')))-1)
formula for text4__c is left(trim(substitute(text__c,text1__c+';'+text2__c+';'+text3__c+';',' ')),find(';',trim(substitute(text__c,text1__c+';'+text2__c+';'+text3__c+';',' ')))-1)
formula for text5__c is trim(substitute(text__c,text1__c+';'+text2__c+';'+text3__c+';'+text4__c+';',' '))
Hope this works. Thanks!
:(
best,
Try this for text5__c
right(Text__c,len(Text__c)-find(';',Text__c,find(text4__c,Text__c)))
Thanks
Please mark this answer as best if this resolves the issue.
your formulas works excelent, thanks four your support :)
best,
Could someone help write up a sample forumla for Text 3 with comma as delimiter? Thank you!