Hi,
I have a .add file that I just could open it as a text file in FME. Do you know anyway to read this file as CSV? Or a way to replace all spaces with one space?
There are irregular spaces between them, and when I open it as a CSV, it is not a helpful file.
I tried to use SrtingReplacer to replace many spaces with one space, but there are many different numbers of spaces in each attribute.
Thank you for your assistance.
I think it is fixed width data?
If you count all characters between the start and the P from PO it will be the same for row 1 and row 4?
If so you could use the stringsplitter with 8s4s16s kind of settings. In this case it will split in 8 characters 4 characters and 16 characters and make this a list. Then you could use whitespace remove to remove all the whitespace at the end of the string. And use an attributecreator with ID = _list{0} etc.