Forum Discussion
Solved
Calculated Column Exctract text between characters
Hi I have a column with a text such as: SOS_name_subname_version_type_requester or just name_subname_version_type_requester and from this column I'd like to extract in a new column just "name...
Here’s my understanding of what you're trying to achieve:
- For strings that start with "SOS_":
You want to extract the portion of text between the first and fourth underscores. - For strings that do not start with "SOS_":
You want to extract the portion of text between the first and third underscores.
I used the column named Release and created a calculated column with the following formula to achieve the desired output:
=IF(LEFT([Release],4)="SOS_",MID([Release],FIND("_",[Release])+1,FIND("_",[Release],FIND("_",[Release],FIND("_",[Release],FIND("_",[Release])+1)+1)+1)-FIND("_",[Release])-1),MID([Release],1,FIND("_",[Release],FIND("_",[Release],FIND("_",[Release])+1)+1)-1))--------------------------------------------------------------------------
If this response was helpful, kindly consider marking it as the accepted answer.
- For strings that start with "SOS_":
Here’s my understanding of what you're trying to achieve:
- For strings that start with "SOS_":
You want to extract the portion of text between the first and fourth underscores. - For strings that do not start with "SOS_":
You want to extract the portion of text between the first and third underscores.
I used the column named Release and created a calculated column with the following formula to achieve the desired output:
=IF(LEFT([Release],4)="SOS_",MID([Release],FIND("_",[Release])+1,FIND("_",[Release],FIND("_",[Release],FIND("_",[Release],FIND("_",[Release])+1)+1)+1)-FIND("_",[Release])-1),MID([Release],1,FIND("_",[Release],FIND("_",[Release],FIND("_",[Release])+1)+1)-1))
--------------------------------------------------------------------------
If this response was helpful, kindly consider marking it as the accepted answer.
amazing, thank you very much for your swift reply, that worked!
