Get substring from string

[sifatnabil]

Hi all,

I have a string like this:

* 11.500%|955597946785402|10-Oct-2018|11.500

I need to get the bolded part but the part in red is arbitrary in length. Is there a good way to get this?

[marcus_sommer · Accepted solution]

Use: subfield(YourField, '|', 2)

- Marcus

[Colin-Albert]

Use the subfield command

subfield(YourFieldName, '|', 2)

subfield('11.500%|955597946785402|10-Oct-2018|11.500', '|', 2)  will return 955597946785402

[sinanozdemir]

Hi,

Subfield() should do it:

Thanks

[sifatnabil]

Ah this was so simple but saw it as more complicated than it really is. Thanks!