SubField

[NiTo]

Hi, 

Have a Good Day to all.

Need to retrieve, right side of the value from a record.

For eg, if the records shows like

a,b

c,b

1,2

3,4

So I need to retrieve, 

b

b

2

4

thanks

[BrunPierre]

This works at the back end and front end.

Text(SubField(A,',',-1))

[Hania]

Hello @NiTo  ,

I think the result you want is,

T1:
load * Inline [
Value
a,b

c,b

1,2

3,4

] (delimiter is '|');

Load Value,
SubField(Value, ',',2) as V1,

text(SubField(Value, ',',2)) as V2           //(For if want all values  as string)

Resident T1;
Drop Table T1;

please consider following snap as Result.

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!

[NiTo]

Thanks for your reply guys.

I later found it..

cheerszzz