Hi ALL

[pradeep_nov18]

If Source is having

A(I/P) b(o/p)
123.14A123 123.14A
4563.67A34 4563.67A
1A45322111 1A

'A' can be any where in source.please let me know how to achieve this.

Can anyone help me on this?thanks in advance for your reply!

[keshav0307]

find the position of A and read 1 to that position.

one option is to use

Field(%string%,%delimiter%,%occurrence%,[%number%])

[shaonli]

You can achieve this by using Index function which finds starting character position of substring.
Target=Inputcol[1,Index[Inputcol,'A',1]].
Please try this

Thanks
Shaonli

[pradeep_nov18]

find the position of A and read 1 to that position.

one option is to use

Field(%string%,%delimiter%,%occurrence%,[%number%])

Hi Keshav

Field(in.col,,1,) in Number can have any value and delimiter wat we have to give please can you Elaborate since there is no delimiter and number cannot be predicted

[pradeep_nov18]

You can achieve this by using Index function which finds starting character position of substring.
Target=Inputcol[1,Index[Inputcol,'A',1]].
Please try this

It should work

Thanks Shaolni


Thanks
Shaonli

[keshav0307]

A is the delimiter

[pradeep_nov18]

A is the delimiter

thanks keshav number should be 1 right.