Page 1 of 1
Hi ALL
Posted: Wed Aug 06, 2008 3:48 am
by 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!
Posted: Wed Aug 06, 2008 3:53 am
by keshav0307
find the position of A and read 1 to that position.
one option is to use
Field(%string%,%delimiter%,%occurrence%,[%number%])
Posted: Wed Aug 06, 2008 3:56 am
by 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
Hi
Posted: Wed Aug 06, 2008 3:58 am
by pradeep_nov18
keshav0307 wrote: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
Thanks
Posted: Wed Aug 06, 2008 4:01 am
by pradeep_nov18
shaonli wrote: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
Posted: Wed Aug 06, 2008 4:01 am
by keshav0307
A is the delimiter
Thanks
Posted: Wed Aug 06, 2008 4:06 am
by pradeep_nov18
keshav0307 wrote:A is the delimiter
thanks keshav number should be 1 right.