balabharathi
15th September 2010, 17:13
Hi,
We are storing an item name and planner code in an CSV file and we are passing that through an input file for updating the planner code. In the input file we have item name "0001B1", but we have the same item name in the table after nine characters i.e " 001B1", so while fetching the record the control moves to selectempty rather than select do. Kindly provide us a solution so that both the value matches perfectly.

Thanks & Regards,
S.Bala

rberti
15th September 2010, 17:48
Hi S.Bala.
Perhaps you could use tt.align.according.domain() function.

Hope it helps!

Rafael

bdittmar
15th September 2010, 19:14
Hi,
We are storing an item name and planner code in an CSV file and we are passing that through an input file for updating the planner code. In the input file we have item name "0001B1", but we have the same item name in the table after nine characters i.e " 001B1", so while fetching the record the control moves to selectempty rather than select do. Kindly provide us a solution so that both the value matches perfectly.

Thanks & Regards,
S.Bala

Hello,
in LN the item code is segmented !
char. 1-9 is for PCS
Normal itemcode begins from character 9 on.

You have to consider the segmentation !

Regards

balabharathi
16th September 2010, 07:23
Hi Bernd,
Thanks a lot for your information.

Regards,
S.Bala

balabharathi
16th September 2010, 07:24
Hi Rafael,
I had used tt.align.according.domain() function also but it doesn't work in this case. Anyway thanks for your timely reply.

Regards,
S.Bala