DSXchange

Hi, guys. I have a CFF stage to read a 400 bytes fixed block COBOL file. The records have some end filler bytes. Example: 230 data bytes and 170 filler bytes, according to the book/file definitions. When I set the fields on the Records tab, if I define 170 bytes for the filler, the second record &qu...

Guys, I got it using "sed -r".

Thanks for all!

Thanks a lot, Ray. Now I'm trying to implement the command to insert the double quotes after the first regex, but I'm having issues (it's new to me). After looking for a solution on internet, I tried to use sed 's/(^[0-9]{1,8}\|[0-9]{1,8}\|)/\1"/' but I got an error that I could not solve yet. ...

I have a sequential file where the delimiter is pipe character ("|"), but it is possible that a specific column has "|" in your content. Example of a row of the file: 1234567|12345| Specific column|with pipe in the content |123456|2016-12-31 10:20:53.0|2017-01-31 19:10:26.0|||0|t...