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 :-)


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)
Seven Stars

Re: Extract section of text

 
Regards
Abhishek KUMAR
( Please mark the post as resolved if you found your solution )
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 :-)


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.