Reg:How to use field function

[pradeep_nov18]

Hi all,

I have requirement,Please help me how to Achieve these

Input Output
AD-ADE-0000000001 0000000001
AF-ADF-0000000002 0000000002

Thanks for your help in Advance.

[ray.wurlod]

You really should wrap fixed-format text in Code tags.

Code: Select all

Input              Output 
AD-ADE-0000000001 0000000001 
AF-ADF-0000000002 0000000002 

The delimiter in these delimited strings is "-", and that becomes the second argument to the Field() function. The delimited string that you want to extract is the third, so 3 is the third argument of the Field() function. You only want to extract one substring, so 1 is the fourth argument to the Field() function. From this we get:

Code: Select all

Field(InLink.Input, "-", 3, 1)

[chulett]

Let me give you the short version - 3rd field from a dash delimited string. Walla! :D

(yes, I know that is not how it is spelled)