09-01-2008 12:10 PM
Dear Experts,
I'm trying to upload material texts using LSMW and an excel file.
If I've a material text like
BAR/FLAT/INTSEL SW/1/4"x4"x20'
the result appears like
"BAR/FLAT/INTSEL SW/1/4""x4""x20'"
Any idea?
Thanks in advance for any help.
Regards,
sb.
09-01-2008 12:24 PM
Sara,
When you convert the excel file to Text Tab Delimited the special characters( Such as , @ etc) are encoded in " (double cotes).
In your case you have to include the " (Inches) so your converted file will reflect "" for example for 14" it will be reflecting "14"".
Now open the Text file and then go to edit --> find and replace.
Then replace "" (ie inch symbol plus double cotes) with @ (symbol). Where ever inch symbol has to be there replace with @ symbol or any other specal character.
The result will be "14@ and then again find and replace "(inch symbol) with blank(space). the result will be 14@.
Again now replace the @ (symbol) with "(inch symbol) the result will be 14". Now save the file and assign it to LSMW object.
Replacing "" with @ symbol is if you find and replace " then it will replace inch symbol also.
Regards....
Edited by: Shakeel on Sep 1, 2008 1:25 PM
09-01-2008 12:24 PM
Sara,
When you convert the excel file to Text Tab Delimited the special characters( Such as , @ etc) are encoded in " (double cotes).
In your case you have to include the " (Inches) so your converted file will reflect "" for example for 14" it will be reflecting "14"".
Now open the Text file and then go to edit --> find and replace.
Then replace "" (ie inch symbol plus double cotes) with @ (symbol). Where ever inch symbol has to be there replace with @ symbol or any other specal character.
The result will be "14@ and then again find and replace "(inch symbol) with blank(space). the result will be 14@.
Again now replace the @ (symbol) with "(inch symbol) the result will be 14". Now save the file and assign it to LSMW object.
Replacing "" with @ symbol is if you find and replace " then it will replace inch symbol also.
Regards....
Edited by: Shakeel on Sep 1, 2008 1:25 PM
09-01-2008 12:40 PM