LSMW - multiple "s in material text
I'm trying to upload material texts using LSMW and an excel file.
If I've a material text like
the result appears like
Thanks in advance for any help.
Shakeeluddin Khaja replied
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.
Edited by: Shakeel on Sep 1, 2008 1:25 PM