Extracting particular row or column and particular data using regex.

One Star

Extracting particular row or column and particular data using regex.

Hi,
I have a requirement to append a specific value to the last row, last column of a .csv file.
Do we have any option in talend to do that?
Also i should extract some data based on the given regex from a .csv file. (eg : *efg should extract abcdefg).
Please suggest which function i should use for this.
One Star

Re: Extracting particular row or column and particular data using regex.

Note sure I understand your requirement.  It sounds like you have two separate questions.  It may be better to create two topics instead of combining them in one.
"append a specific value to the last row, last column of a .csv file"

Will it work for you to write the file and then append the last row in a different process?  You can use tFileOutputDelimited with append option selected to append a row to an existing file.
"extract some data based on the given regex"

perhaps tFileInputRegex or tExtractRegexFields will meet you needs? 
You can search for Regex in the pallet to see these components. 

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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch