Locate and intercept data

[LRAngela]

Could you help me solve this  question?  I want to intercept the string after the last comma.

For example, the three rows of data on the picture intercept the part with the red line. Thanks in advance.

[tresesco · Accepted solution]

Try subfield() with -1 field no parameter, like:

Subfield('your string here with ....... , expected output here', ',' , -1)

[Mark_Little]

HI,

Depends how you load script is being handled. 

If it is load as a csv like below

LOAD

A,

B,

C,

D

From ...

Just remove the forth field from the load like below.

LOAD

A,

B,

C,

D

From ...

Else you would need to look at Subfield function if it is loaded in a single field.

Mark

[LRAngela · Accepted solution]

thanks .i have a solution for this problem.

i can run use this way,

mid(Address,Index(Address,',',-1)+1,(len(Address)-Index(Address,',',-1)))

[LRAngela]

it runs ok ,too.