I’m fairly new to FME and need help to get started on a workbench. I have a text file i need to convert into a readable format. Each line has information about a specific device and should be parsed into separate columns. The blank spaces also need to be removed. What transformer should I use? Any help is appreciated!
Solved
Parse Text File data into columns
+3- Contributor
Best answer by ebygomm
Another option is to use a CAT (Column Aligned Text) Reader
This will eliminate the blank spaces without anything further required
1 person upvoted this
+44- Evangelist
Hi
Do you have a sample data to share?
Remove blank space I suggest you to use the transformer AttributeTrimmer.
+26- Evangelist
Use a CSV Reader instead. It will parse any text file by any custom Delimiter character input into the Parameters. The sample preview looks like a space or Tab character is used.
It sometimes needs some trial and error with the Advanced Parameter settings, but it should give you what you want. One Parameter to be careful of is “Scan for Type” is left as “Yes”. If it determines the column is numeric, it will drop the leading zeros on this column, and can see that you do have these types of fields in the sample data.
+3- Contributor
1 person upvoted this
+44- Evangelist
Hi
Thanks for your data.
I created a Workspace that eliminate these blank spaces and generate a attributes.
Attached.
Thanks, Danilo!
+32- Influencer
- Best Answer
Another option is to use a CAT (Column Aligned Text) Reader
This will eliminate the blank spaces without anything further required
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.