Material short text transfer using LSMW

[Former Member]

Hi!

We are in the process of loading changes to our material master data using LSMW & load file conaining existing mateial data + changes(delimited .txt file). We do not face any issues with other data except material short text having " ( like :12" valve). We have noticed that after the data trasnfer the existing short text (like: 12" valve) gets changed to ( "12"" valve) - it gets additional " "(at the start & end ). All other short tet data stays ok. Please guide on how to avoid this. It may happen with some other special characters also (like , - although the question right now is for ".

Do we need to add "i" infront of existing text data so that it may not change?

Please guide. We are on ECC6.0.

Regards,

Raj

[Former Member]

Hi!

We are in the process of loading changes to our material master data using LSMW & load file conaining existing mateial data + changes(delimited .txt file). We do not face any issues with other data except material short text having " ( like :12" valve). We have noticed that after the data trasnfer the existing short text (like: 12" valve) gets changed to ( "12"" valve) - it gets additional " "(at the start & end ). All other short tet data stays ok. Please guide on how to avoid this. It may happen with some other special characters also (like , - although the question right now is for ".

Do we need to add "i" infront of existing text data so that it may not change?

Please guide. We are on ECC6.0.

Regards,

Raj

[Former Member]

hi

in Excel u hav the material desc as " Material Desc " select that column and replace, all

"(double quotes) by #(hash)

and convert it into text file...

in text file u replace

"(double qoutes) by blank space and then replace,

all #(hash) by "(double quotes)

Regards

Smitha

[former_member438956]

Hi Rajiv,

This is a common issue while saving the text delimited file thr excel. Excel adds text qualifier(") to each column where it finds any of the qualifiers like ,",:,- and many others. The best way to avoid this problem is to save the data and then open the same file with notepad and replace all " with blank.

This will solve ur problem.

Regards,

Anil N.

[Former Member]

convert your .TXT file with UTF-8 format and load the data....