span8
span4
span8
span4
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
Wow,it finally works,I never thought about your solution using TXT.Thanks for your detailed explination Niels!!!
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 [||] 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
© 2019 亚搏在线Safe Software Inc |法律