Maintaining a string

[Anonymous]

So the next issue I have is retaining the state of a string.  

For example I have an input field that contains things like bullet points or other and after transformation or even just a simple field push through, it changes the bullet points to a question mark etc...

Source data from csv file

This foundational unit provides content such as:
• Introductory principles and techniques of garment fabrication
• Introductory principles and techniques of garment patternmaking
• Fabric characteristics.

output data - Converts to after a simple transform automatically - output is csv file

This foundational unit provides content such as:
? Introductory principles and techniques of garment fabrication
? Introductory principles and techniques of garment patternmaking
? Fabric characteristics.

Naturally I want to retain the original state of the data including bullets

[ankit7359]

hi,

Just as you have considered an input field in source side having bullets points at data level, i too have considered... with respect to Job-level... there isnt much which can be done thereby i have put the source data in the excel and target i have opened with notepad++...if you by chance open with excel then you will encounter special characters or question marks etc...

pls find the attached screenshots of the scenario.. and how i dealt it...

Pls refer to the captions jus below the screenshots such you would get an idea..

Source DataTalend JobTmap settingsOutput csv if opened in ExcelOutput csv if opened in Notepad++

[Anonymous]

unfortunately not for me.

in notepad++

? Quantitative structure activity relationships (QSAR)
? The absorption, distribution, metabolism and excretion of pharmaceuticals.
? The mechanism of action and therapeutic application of the main classes of drugs.
? Drug-receptor, drug-enzyme and drug-drug interactions.
? Drug toxicity and adverse effects
? Professional, scientific communication","12.00000",

[Anonymous]

hi,

you better change the encoding in notepad++ and in excel,

In notepad++ click encoding tab and select "Encode in UTF-8"

and for excel refer  http://www.accompa.com/kb/answer.html?answer_id=264

and look for method 2 in this link.

regards 

Chandra Kant

[ankit7359 · Accepted solution]

can you send the sample csv
basing on that lemme try.. maybe i can clear it off

[Anonymous]

This foundational unit provides content such as:
• Introductory principles and techniques of garment fabrication
• Introductory principles and techniques of garment patternmaking
• Fabric characteristics.

used this same data which you provided and works well