Maintaining a string

Six Stars

Maintaining a string

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 bulletsimg1.jpg

 

 


Accepted Solutions
Nine Stars

Re: Maintaining a string

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

Re: Maintaining a string

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


All Replies
Nine Stars

Re: Maintaining a string

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

bullets-source.PNGSource Databullets-1.PNGTalend Jobbullets-2.PNGTmap settingsbullets-output(excel).PNGOutput csv if opened in Excelbullets-output.PNGOutput csv if opened in Notepad++

 

Six Stars

Re: Maintaining a string

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

Seven Stars

Re: Maintaining a string

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

 

Nine Stars

Re: Maintaining a string

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

Re: Maintaining a string

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog