Hello FME expert,
I try to read a file (ZRM.csv) into Oracle db but my result looks like output.xls
I don't manage to get rid of the seperations |~| and [||] and [ with my reader because I have only 1 Delimiter Character in the CSV reader.
Is there a better way to extract and read only the items that I want?
Many thanks for your reply
I think the ~ represents a null?
And the ||] at the end of the line looks like an unused array?
Read the file as text
Remove the e||] at the end with a StringReplacer
Remove the ~ with a StringReplacer
Text to columns with the AttributeSplitter, drop empty parts (drop columns that used to contain a ~)
Create columns you need with the AttributeCreator
Wow, it finally works, I never thought about your solution using TXT. Thanks for your detailed explination Niels!!!