topic Re: Maintaining a string in Talend Studio

Maintaining a string

Anonymous — Sat, 16 Nov 2024 07:21:19 GMT

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

Re: Maintaining a string

ankit7359 — Mon, 05 Nov 2018 06:57:36 GMT

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++

Re: Maintaining a string

Anonymous — Mon, 05 Nov 2018 22:40:54 GMT

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",

Re: Maintaining a string

Anonymous — Tue, 06 Nov 2018 08:10:10 GMT

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

Re: Maintaining a string

ankit7359 — Tue, 06 Nov 2018 08:13:01 GMT

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

Re: Maintaining a string

Anonymous — Tue, 06 Nov 2018 08:26:54 GMT

used this same data which you provided and works well