LSMW - multiple "s in material text

[Former Member]

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.

[former_member188005]

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

[Former Member]

Thanks, Shakeel. Problem solved.

Regards,

sb.