Hello, How can I define formula to import the right srting after the last "_"? For example: Column1FormulaCONTINUITY_P_TXP_POS_400UA_TI1310PTI1310PCONTINUITY_DIG_NEG_2MA_CCLK CCLK Thaks in advance! Assaf

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

String parsing formula

Assaf1

Hello,

How can I define formula to import the right srting after the last "_"?

For example:

Column1	Formula
CONTINUITY_P_TXP_POS_400UA_TI1310P	TI1310P
CONTINUITY_DIG_NEG_2MA_CCLK	CCLK

Thaks in advance!

Assaf

Accepted answers

pmroz

Words will get you there. This formula will do the trick:

c = Words(:Column 1, "_"); 
d = c[N Items(c)];

All comments

uday_guntupalli

@Assaf1,
Do you need the formula to be in a table ? I can offer the following solution that works :

dt = Current Data Table(); // Ensure your data table is open and it is current 

Vals = :Column 1 << Get Values;  // Get Values out 

Res = List(); // Define empty list 


for(i = 1 , i <= N Items(Vals), i++,
	 Test = Words(Vals[i],"_"); // Words is the function that will split your string by delimiter 
	 
	 Insert Into(Res,Test[N Items(Test)]);

   );

Show(Res);

Alternatively,

You could use a similar approach to parse out the strings separated by the delimiter in a column formula as well, by using the following as a column formula:

Words(:Column 1, "_")

But then, I can't really think of a way to get the last string out in the column formula. Hope this helps some. Maybe look at "Substr" function - it might help

pmroz

Words will get you there. This formula will do the trick:

c = Words(:Column 1, "_"); 
d = c[N Items(c)];

Assaf1

Thanks a lot for your suport

It's work!

Justin_Chilton

Similarly, you could use the Word function to get the last "word" using an index of -1 (i.e. count backwards from the end). This just saves you from needing any JSL variables/lists.

Word( -1, :Column 1, "_");