+2Hello 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
+54I 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 [||] 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
+2Wow, it finally works, I never thought about your solution using TXT. Thanks for your detailed explination Niels!!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
