Extract section of text

Four Stars

Extract section of text

I have, 
10023_23447.pdf as text data in file ,i want only 10023 as output in destination text file ..how can i do? 

Highlighted
Employee

Re: Extract section of text

Hi,

 

Please refer the below screen shots.image.pngjob flow

 

image.pngtMap

You can use one of the below methods to extract the data.

 

row1.input.substring(0,5)

OR

row1.input.substring(0,row1.input.indexOf("_"))

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

Eleven Stars

Re: Extract section of text

 
Regards
Abhishek KUMAR
Employee

Re: Extract section of text

Hi @aishj431 

 

     Could you please mark the topic as resolved since I have answered your query?

 

     Marking a query promptly will help others in Talend community when they are looking solutions for similar queries.

 

     It is also a way of telling thank you to the contributor for spending their time for your query in between their regular work.

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

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 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog