URGENT : REG-EX PARSING

Hi,

I have attached a sample text file having the different fields lengths. Also attached a column definition file explaining each column length.

I want to parse the file & separate based on columns i.e. A,B,C etc.

Please advise the syntax in reg ex tool.

Regards

Vaibhav Jain

parsing_file1.yxzp

sample_parsing.txt

columns_defination.txt

Regex

Accepted answers

JohnJPS

Hi @vaibhav_jain,

If the given fields are always in the same place in the file, you can pick those locations in the input tool... don't select any particular file type, and on this screen:

... make sure to read it as a "fixed width file" ... this will take you to another screen where you can simply point-and-click the field lengths:

In my screen shot, I've clicked in the first 4 fields... you can scroll right and easily click in your entire field list. Make sure to adjust the "Record Length" such that you can see everything.

Hope that helps!

All comments

vaibhav_jain

Hi,

Desired Output

Column A Column B Column C Column D

5679000765430000 67890123456000400 00/00/0000 12/05/2016

Regards

Vaibhav Jain

JohnJPS

Hi @vaibhav_jain,

If the given fields are always in the same place in the file, you can pick those locations in the input tool... don't select any particular file type, and on this screen:

... make sure to read it as a "fixed width file" ... this will take you to another screen where you can simply point-and-click the field lengths:

In my screen shot, I've clicked in the first 4 fields... you can scroll right and easily click in your entire field list. Make sure to adjust the "Record Length" such that you can see everything.

Hope that helps!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703