Manipulate text between delimiters

Question

How can I covert following: 78756||23456||12345To: 787||234||123&nbsp;I want the first 3 digits&nbsp;

detlef_lewin · Answer

apei78759&nbsp;Try this.=TEXTJOIN("||",TRUE,LEFT(FILTERXML("&lt;y&gt;&lt;z&gt;"&amp;SUBSTITUTE(A1,"||","&lt;/z&gt;&lt;z&gt;")&amp;"&lt;/z&gt;&lt;/y&gt;","//z"),3))

oliverscheurich · Answer

apei78759&nbsp;=LEFT(A1,3)&amp;"||"&amp;MID(A1,FIND("||",A1)+2,3)&amp;"||"&amp;MID(A1,FIND("||",A1,FIND("||",A1)+1)+2,3)Maybe with this formula.&nbsp;

apei78759 · Answer

Thank you! This works for string for 3 entries: 78756||23456||12345But how about something that works regardless of the number of entries. For example, 578756||23456||12345||34567||09685

sergeibaklan · Answer

Detlef_Lewin&nbsp;
Exactly the same with Beta function
=TEXTJOIN("||", 1, LEFT( TEXTSPLIT(A1, "||"), 3) )

Forum Discussion

Manipulate text between delimiters

4 Replies

Resources