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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+54- Celebrity
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
+54- Celebrity
Hi
Thanks for your data.
I created a Workspace that eliminate these blank spaces and generate a attributes.
Attached.
Thanks, Danilo!
+51- Evangelist
- Best Answer
Another option is to use a CAT (Column Aligned Text) Reader
This will eliminate the blank spaces without anything further required
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.