Skip to Content
avatar image
Former Member

LSMW - multiple "s in material text

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 01, 2008 at 11:24 AM

    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

    Add comment
    10|10000 characters needed characters exceeded