topic Locate and intercept data in QlikView

Locate and intercept data

LRAngela — Wed, 14 Dec 2022 07:37:16 GMT

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.

tresB — Wed, 14 Dec 2022 08:02:18 GMT

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

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

Mark_Little — Wed, 14 Dec 2022 08:02:19 GMT

HI,

Depends how you load script is being handled.

If it is load as a csv like below

LOAD

From ...

Just remove the forth field from the load like below.

LOAD

From ...

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

Mark

LRAngela — Wed, 14 Dec 2022 09:25:42 GMT

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 — Mon, 19 Dec 2022 05:36:42 GMT

it runs ok ,too.