Extract string from text file which has data fields in string format

How can I extract a string from a text file (attached)?
I need all numeric data present in rows A, D, G column particularly.

  1. account dates from and to both,
  2. ADT/OCDS both and
  3. Day/Units

gg.txt (1.2 KB)

Hello @shikharno.7,

First use write csv to convert the text file to csv file then use read csv and acces through for each row

3 Likes

Hi,

Hope the following sample helps you.

Sample20200522-2.zip (16.3 KB)

Regards,

1 Like

Thank you Yoichi for the quick help :slight_smile:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.