Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Material short text transfer using LSMW

Former Member
0 Kudos
183

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

3 REPLIES 3

former_member342013
Contributor
0 Kudos
60

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
Active Participant
0 Kudos
60

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
0 Kudos
60

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