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!
Hi ALL
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 92
- Joined: Wed Mar 05, 2008 4:09 am
- Location: chennai
- Contact:
Hi ALL
pradeep.v
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 92
- Joined: Wed Mar 05, 2008 4:09 am
- Location: chennai
- Contact:
Hi
Hi Keshavkeshav0307 wrote:find the position of A and read 1 to that position.
one option is to use
Field(%string%,%delimiter%,%occurrence%,[%number%])
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.v
-
- Participant
- Posts: 92
- Joined: Wed Mar 05, 2008 4:09 am
- Location: chennai
- Contact:
Thanks
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
pradeep.v
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 92
- Joined: Wed Mar 05, 2008 4:09 am
- Location: chennai
- Contact: